Quiz 5 Spreadsheet

Match the following spreadsheet error to its description.

• When the text in the formula is not recognized

• #NULL!

• This error arises due to a reference missing.

• #NUM!

• It is wrong supply of the value to the required parameters.

• ####

• When the data in the cell is too wide to fit in the column

• #Name?

• When your formula or data contain invalid numeric values .

• #REF

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