Recall & Review
beginner
What does the IFERROR function do in Excel?
IFERROR checks a formula for an error. If there is an error, it shows a value you choose instead of the error message.
Click to reveal answer
beginner
Write the syntax of the IFERROR function.
IFERROR(value, value_if_error)<br><br>Where
value is the formula or expression to check, and value_if_error is what to show if there is an error.Click to reveal answer
beginner
Why use IFERROR instead of just letting Excel show error messages?
IFERROR helps keep your spreadsheet clean and easy to read by replacing errors with friendly messages or alternative results.
Click to reveal answer
beginner
Example: What will
=IFERROR(10/0, "Oops") show?It will show "Oops" because dividing by zero causes an error, and IFERROR replaces it with "Oops".
Click to reveal answer
intermediate
Can IFERROR handle all types of errors in Excel formulas?
Yes, IFERROR catches all error types like #DIV/0!, #N/A, #VALUE!, #REF!, #NAME?, and #NUM!.
Click to reveal answer
What does IFERROR(value, value_if_error) do if
value has no error?✗ Incorrect
IFERROR returns the original
value if there is no error.Which of these is a correct use of IFERROR to avoid #DIV/0! error?
✗ Incorrect
Option C divides A1 by B1 and shows 0 if there is a division error.
What will this formula show if A1 contains text "apple"?
=IFERROR(A1/2, "Invalid")✗ Incorrect
Dividing text by a number causes an error, so IFERROR shows "Invalid".
Which error type can IFERROR NOT catch?
✗ Incorrect
IFERROR catches all standard Excel error types.
What is the best reason to use IFERROR in your formulas?
✗ Incorrect
IFERROR helps make spreadsheets easier to read by hiding error messages.
Explain how IFERROR works and why it is useful in Excel.
Think about what happens when a formula causes an error.
You got /3 concepts.
Write an example formula using IFERROR to handle division by zero errors.
Use something like =IFERROR(A1/B1, 0)
You got /3 concepts.