Worksheets"If Function" Excel Quiz
Total questions: 10
Worksheet time: 8mins
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")
