Intro to Excel

What does this error mean? #DIV/0

Which of the following is not an error value but a special value that you can manually enter into a cell to indicate that you don’t yet have a necessary value?

• #DIV/0

• #NAME?

• #NULL

• None of the above

Draw the error that you would see in Excel when a person enters the wrong type of argument in a function or wrong type of operation.

This error occurs when you delete a cell referred to in the formula or if you paste cells over the ones referred to in the formula.

• #N/A

• #REF!

• #DIV/0

• None of the above

Explain this error that occurs in MS Excel: #NAME?

#NUM means that

• You have too many numbers in the formula

• You specified an intersection of two cell ranges whose cells don’t actually intersect

• There is a problem with a number in the formula.

• All of the above