Home / SSC(ENG) - GSEB Board / Reading Mode

📖 Reading Mode: SSC(ENG) - GSEB Board

Chapter: Functions in Calc • Total: 32 MCQs

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