Font size
WorksheetsQuiz 5 Spreadsheet
Total questions: 10
Worksheet time: 7mins
Match the following spreadsheet error to its description.
####
When the data in the cell is too wide to fit in the column
#NUM!
When your formula or data contain invalid numeric values .
#REF
This error arises due to a reference missing.
#NULL!
It is wrong supply of the value to the required parameters.
#Name?
When the text in the formula is not recognized
True or False.
In the IF function, you can decide both the return values and the condition.
TRUE
FALSE
True or False
If you try to divide the number by zero or vice versa it will give you a
#DIV/! error.
TRUE
FALSE
It is #DIV/0?
FALSE
It is #DIV/0!
FALSE
It is #DIV
Text values in the formula needs to be in parenthesis ( ).
True
False
in quotes " "
False
in comma ,
False
in semicolon ;
The AND function returns TRUE if all its arguments evaluate to TRUE and return FALSE if one or all arguments evaluate to FALSE.
TRUE
FALSE
In OR Function, the result is TRUE if
all the conditions are TRUE
if one of the condition is TRUE
if all the conditions is false
Which formula is correct?
=IF(AND(A3="Red",B3="Green"),"TRUE","FALSE")
=IF(AND(A3=Red",B3="Green"),TRUE,FALSE)
IF(AND(A3="Red"B3="Green"),TRUE,
FALSE)
=IF((A3="Red",B3="Green"),TRUE,
FALSE))
Which is the correct syntax of IF Function?
IF(LOGICAL TEST,"true","false")
=(IF LOGICAL TEST,"true","false")
=IF("true","false")
=IF(LOGICAL TEST,"true","false")
True or False.
Every function in Excel requires an opening and closing parenthesis ().
TRUE
FALSE
it requires comma only
FALSE
it is not required as long as the formula have an equal sign
Which of the following best describes the Nested If?
one IF function inside of another
one logical test with multiple results
multiple logical tests with a single result
to evaluate one condition in different value
