Q1. What does the IF function do in Excel?, Adds numbers, Makes decisions, Q2. What does IF check?, A condition, A color, Q3. Which symbol starts an Excel formula?, #, =, Q4. What does TRUE mean?, The condition is correct, The condition is wrong, Q5. What does FALSE mean?, The formula is finished, The condition is wrong, Q6. Which formula is correct?, =IF(B2>=50,"PASS","FAIL"), =IF(B2>=50,PASS,"FAIL"), Q7. If the grade is 80, what is the result?, FAIL, PASS, Q8. If the grade is 30, what is the result?, FAIL, TRUE, Q9. What does >= mean?, Greater than or equal to, Equal to only, Q10. What do we use quotation marks for in the IF formula?, Numbers, Text
0%
Excel_IF_Function_Lesson
Share
Share
by
Tahaomar
Edit Content
Save
Like
Print
Embed
More
Assignments
Leaderboard
Show more
Show less
This leaderboard is currently private. Click
Share
to make it public.
This leaderboard has been disabled by the resource owner.
This leaderboard is disabled as your options are different to the resource owner.
Revert Options
Win or lose quiz
is an open-ended template. It does not generate scores for a leaderboard.
Log in required
Visual style
Fonts
Subscription required
Options
Switch template
Show all
Open results
Copy link
QR code
Delete
Continue editing:
?
