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
Del
Del
af
Tahaomar
Rediger indhold
Gem
Synes om
Trykke
Integrere
Mere
Tildelinger
Rangliste
Vis mere
Vis mindre
Denne rangliste er i øjeblikket privat. Klik på
Del
for at gøre det offentligt.
Denne rangliste er deaktiveret af ressourceejeren.
Denne rangliste er deaktiveret, da dine muligheder er forskellige fra ressourceejerens.
Indstillinger for gendannelse
Vind eller tab quiz
er en åben skabelon. Det genererer ikke resultater for en rangliste.
Log ind påkrævet
Visuel stil
Skrifttyper
Kræver abonnement
Indstillinger
Skift skabelon
Vis alle
Åbne resultater
Kopiér link
QR-kode
Slette
Gendan automatisk gemt:
?