Learn Excel EasyDaily One Lesson

Quiz › Fixes & Errors › Which error will you get?

Which error will you get?: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

  1. A1 = 10 and B1 = 0. What will this formula return?
    =A1/B1
    • A. #DIV/0!
    • B. #VALUE!
    • C. 0
    • D. 10
    Show the answerA — #DIV/0!. You cannot divide by zero, so Excel shows #DIV/0!.
  2. A1 = 10 and B1 has the word abc. What will this formula return?
    =A1+B1
    • A. 10
    • B. #VALUE!
    • C. #NAME?
    • D. 0
    Show the answerB — #VALUE!. You cannot add a word to a number, so Excel shows #VALUE!.
  3. SUM is spelled wrong here. What will this formula return?
    =SUME(A1:A5)
    • A. 0
    • B. #REF!
    • C. #VALUE!
    • D. #NAME?
    Show the answerD — #NAME?. Excel does not know the name SUME, so it shows #NAME?.
  4. Mango is not in column A. What will this formula return?
    =VLOOKUP("Mango",A:B,2,FALSE)
    • A. #NAME?
    • B. #N/A
    • C. 0
    • D. Mango
    Show the answerB — #N/A. #N/A means no match was found.
  5. C1 has =A1+B1. You delete column B. What does the formula show now?
    • A. #N/A
    • B. #REF!
    • C. 0
    • D. #VALUE!
    Show the answerB — #REF!. The formula points to a cell that is gone, so Excel shows #REF!.

Want to learn this? Read the Fixes & Errors lessons →
← More Fixes & Errors topics · All quiz categories