Finding & Fixing Errors in Excel

Ho can you resolve the #NAME? error

• Type your name

• Delete the formula

• Correct the spelling mistake

What does the #VALUE! error mean?

• If a cell contains text when a formula expects a number

• The number is too high

• The number is too low

Why does the #DIV/0! error appear?

• To turn on the IFERROR tool

• When you are trying to divide a number by zero

• When you are trying to multiply by zero

What is a circular reference?

• A long formula

• A reference with a zero

• When a formula refers to its own cell

What could be a disadvantage of using CTRL + ` to check your formulas?

• You have to check each formula manually

• It automatically gives you an error message

• You don't have to use the riibon