A basic knowledge of Microsoft Office applications such as MS Word, MS Excel and MS PowerPoint is often required for most jobs. Practise and prepare for your aptitude test with these frequently asked MS Office questions and answers.
The Excel ____ function returns the Boolean value FALSE.
TRUEFALSE(0)
FALSE()
Both of the above
There is no such function
Correct answer is B
The Excel FALSE() function returns the Boolean value FALSE.
Example:
=IF(A1>18,"Young",FALSE())
OR
AND
IF
ANDIF
Correct answer is A
The OR() function is used to test multiple conditions and returns TRUE if one or more evaluates to TRUE, and returns FALSE if all arguments evaluate to FALSE.
Syntax:
=OR (logical1, [logical2], ...)
In Excel, which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?
OR
AND
IF
ANDIF
Correct answer is B
The AND() function is used to test multiple conditions and returns TRUE if all arguments evaluate TRUE; FALSE if not.
Syntax:
=AND (logical1, [logical2], ...)
The fill function can be ____ to complete formulas in a range.
Single clicked
Double-clicked
Triple clicked
Right clicked
Correct answer is B
No explanation has been provided for this answer.
The intersection of a column and a row in a worksheet is called ____
Box
Cell
Range
Page Break
Correct answer is B
No explanation has been provided for this answer.