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

Excel_IF_Function_Lesson

ustvaril/-a
Natisni
Vdelaj

Lestvica vodilnih

Vizualni slog

Možnosti

Preklopi predlogo

Obnovi samodejno shranjeno: ?