"If Function" Excel Quiz
Authored by Rotary RECB3190
Computers, Professional Development, Education
6th Grade - Professional Development
Used 15+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
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
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
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
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
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")
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
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'
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
AND
OR
IF
NOT
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
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)
7.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
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.
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
