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.