Answer:
Option B: #VALUE
is the correct answer.
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!
