Question

You try to enter your name into a cell that accepts a numeric value. What error would you receive? A. #NAME B. #VALUE C. #REF D. ##### E. #DIV

Answer 1

Answer: value

Step-by-step explanation:

Answer 2

Option B: #VALUE

is the correct answer.

Step-by-step explanation:

Reasons of #VALUE error:

• When cells are not given the expected type of value.
• If cells are left blank unnoticeable or for giving a null value.
• For entering dates and other numerical data in text form.

Correcting and fixing #VALUE error:

This type of error can only be fixed by finding the cell in which there is wrong data entered and correct it.

Fixing the #VALUE error is tricky as some functions automatically ignore the data that is invalid.

EXAMPLE:

• Suppose a cell contains the value as cost of the object and in order to make it 0, NA is inserted into the cell.

• While making total of all the costs, that particular cell might cause #VALUE error.
• Following image attach will help you clear the concept.

I hope it will help you!