Reading Mode - SSC(ENG)

MCQ 1 ALL

In Calc,the function arguments are given in which brackets ?

A [ ]

B < >

C { }

D ( )

MCQ 2 ALL

Which function returns the value of the factorial function for the given number ?

A FAC ( )

B FAT ( )

C FACT ( )

D FACTORIAL ( )

MCQ 3 ALL

In Calc,what is the output of = MID ( "Net-X Computer Class "; 3;3)?

A Net-X

B Net

C t-X

D IIT

MCQ 4 ALL

Which sign is used to join two or more than two strings ?

A +

B &

C #

D *

MCQ 5 ALL

Which of the following is relative cell address ?

A =A1:A2

B =$A$1:$A$2

C Both A and B

D None of these

MCQ 6 ALL

Which of the following sing is used to specify cell range in function ?

A ,

B ;

C .

D :

MCQ 7 ALL

Which function returns the number raised to the given number ?

A POWER()

B EXP()

C FACT()

D PRODUCT()

MCQ 8 ALL

In Calc, what is the output of =Soft & ware?

A Soft

B ware

C Software

D Error

MCQ 9 ALL

In Calc, the EXACT() function returns which output value if two string are not same ?

A 0

B 1

C FALSE

D TRUE

MCQ 10 Making Decision(if in calc)

........is the syntax of IF condition.

A =IF(TEST)

B =IF("TRUE","FALSE")

C =IF(TEST,"TRUE","FALSE")

D =IF(TEST, "FALSE", "TRUE")

MCQ 11 Mathematical Function in Calc

........is the syntax of POWER function.

A =POWER(n)

B =POWER(-n)

C =POWER(n, p)

D =POWER(p)

MCQ 12 Introduction of Function

After name of the function,value provided in bracket is known ........

A variables of function region

B cells of function region

C prefix of function region

D arguments of the function

MCQ 13 Introduction of Function

........ can be given as the argument of the function.

A Cell address

B Cell range

C Constant value

D Any of these

MCQ 14 Introduction of Function

The cell mentioned in formula is displayed with........color.

A red

B blue

C green

D yellow

MCQ 15 Introduction of Function

........is compulsory for function.

A Variable of function (Argument)

B Correct spelling of function

C Both (A) and (B)

D None of these

MCQ 16 SUM() in Calc

When = sign is used ?

A In the beginning for entering variable

B At the end of the variable

C In the beginning of entering the function

D At the end of the function

MCQ 17 Function Wizard

For what Function Wizard is used?

A It is not possible to keep all the icons of the functions in the bar

B It is difficult to remember all the functions with their syntaxes

C Both (A) and (B)

D None of these

MCQ 18 Function Wizard

Function wizard tool is displayed on........bar

A Standard bar

B Formula bar

C Formatting bar

D Status bar

MCQ 19 Function Wizard

........is the shortcut key to open the function wizard.

A Ctrl + F2

B Shift + F2

C Alt + F2

D Ctrl + Alt + F2

MCQ 20 Function Wizard

How many types of categories are there for the functions?

A 10

B 11

C 12

D 13

MCQ 21 Function Wizard

In sum function,maximum how many variable,values or Cell addresses can be given?

A 10

B 20

C 30

D 40

MCQ 22 Mathematical Function in Calc

LOG10 is ........ type of function.

A string

B mathematical

C logical

D statistical

MCQ 23 Mathematical Function in Calc

=ROUND(12.15652;2) results to .......

A 12.15

B 12.16

C 12

D 12

MCQ 24 Mathematical Function in Calc

TRUNC stands for .........

A Truncation

B Truncate

C Traction

D Tractor

MCQ 25 Statistical Function in Calc

AVERAGE is known ....... .

A Mean of arithmetic

B Mean of Statistics

C Mean of string

D Average mean

MCQ 26 Statistical Function in Calc

COUNTA,MAX,MEDIAN,MODE,MIN are........type of function.

A Statistical

B Financial

C String

D Logical

MCQ 27 Relational Operators

What does Relational operator = suggest?

A One operand is smaller than second operand.

B One operand is bigger than second operand.

C Both operands are different.

D Both operands are same.

MCQ 28 Logical Function

........is the logical operator

A IF

B TRUE, FALSE

C AND,OR,NOT

D All of these

MCQ 29 Making Decision(if in calc)

How many arguments are there in IF function?

A 2

B 3

C 4

D 5

MCQ 30 Logical Function

........function reverse the logical value

A AND

B OR

C IF

D NOT

MCQ 31 Logical Function

The result displayed as TRUE and FALSE are known as ........ value

A boolean

B binary

C biometric

D master

MCQ 32 String Function

LEFT,RIGHT,MID,LEN is ........ type of function.

A Statistical function

B String function

C Mathematical Function

D Logical function

📖 Reading Mode: SSC(ENG) - GSEB Board

In Calc,the function arguments are given in which brackets ?

Which function returns the value of the factorial function for the given number ?

In Calc,what is the output of = MID ( "Net-X Computer Class "; 3;3)?

Which sign is used to join two or more than two strings ?

Which of the following is relative cell address ?

Which of the following sing is used to specify cell range in function ?

Which function returns the number raised to the given number ?

In Calc, what is the output of =Soft & ware?

In Calc, the EXACT() function returns which output value if two string are not same ?

........is the syntax of IF condition.

........is the syntax of POWER function.

After name of the function,value provided in bracket is known ........

........ can be given as the argument of the function.

The cell mentioned in formula is displayed with........color.

........is compulsory for function.

When = sign is used ?

For what Function Wizard is used?

Function wizard tool is displayed on........bar

........is the shortcut key to open the function wizard.

How many types of categories are there for the functions?

In sum function,maximum how many variable,values or Cell addresses can be given?

LOG10 is ........ type of function.

=ROUND(12.15652;2) results to .......

TRUNC stands for .........

AVERAGE is known ....... .

COUNTA,MAX,MEDIAN,MODE,MIN are........type of function.

What does Relational operator = suggest?

........is the logical operator

How many arguments are there in IF function?

........function reverse the logical value

The result displayed as TRUE and FALSE are known as ........ value

LEFT,RIGHT,MID,LEN is ........ type of function.

⚠️ Report Question Issue