"If Function" Excel Quiz

Which of the following is the correct formula for the IF function in Excel?

• IF (logical_test, value_if_true, value_if_false)

• =IF (logical_test, value_if_true, value_if_false)

• =(logical_test, value_if_true, value_if_false)

• None of the above

If the cell B2 is 68, what will this IF function give you as a result? =IF (B2>60, 'pass', 'fail')

• Pass

• Fail

• 68

• None of the above

Which is the correct way to write this function:

IF B4 is greater than 200, show "High", otherwise, show "Low"

• =IF(B4>200,"High","Low")

• =IF(B4>200"High","")

• IF(B4>200,"High","Low")

• =IF(B4<200,"High","Low")

In an IF function, what symbols need to be around text that you want to show up as the true or false of the condition

• parenthesis ( )

• quotation marks " "

• nothing

• Option 'A' and 'B'

Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result

• AND

• OR

• IF

• NOT

Which of the following is correct syntax in Excel?

• =IF(LogicalTest, TrueResult, FalseResult)

• =IF(LogicalTest, (TrueResult, FalseResult))

• =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)

• =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

Which of the following statements are TRUE?

• You use SUMIFs to count cells based on specified ranges and criteria.

• You have to first use an IF statement in a worksheet before you can use SUMIFs or COUNTIFs.

• You use COUNTIFs to count the number of cells specified by a given set of conditions or criteria.

• None of the options listed above are correct.

What is a nested IF statement?

• It is an IF statement that has been inserted into a cell.

• It is an IF statement that has been inserted into a graphic such as a shape.

• It is an IF statement that has been inserted into another IF statement.

• None of the options listed above are correct.

Which of the following is NOT an argument you will find in a SUMIFs function?

• sum_range

• value_if_true

• criteria_range1

• criteria2

Which of the following nested IF functions are CORRECT?

• =IF(B5="Shirt",IF(A5="large",20,10),"Unavailable")

• =IFS(B5="Shirt",IF(A5="large",20,10),"Unavailable")

• =IF(B5="Shirt",=IF(A5="large",20,10),"Unavailable")

• =IF:(B5="Shirt",IF(A5="large",20,10),"Unavailable")