basic computer MCQ #1882

The '#VALUE! error in Microsoft Excel represents:

basic computer MCQ #1882

  1. Question 1

    Q1. The '#VALUE! error in Microsoft Excel represents:

    • A) The width of the cell is less than needed to display the answer
    • B) A parameter provided to the function is of the wrong data type
    • C) The value of the answer needs to be rounded off
    • D) When Excel does not recognize the format

    Answer: A parameter provided to the function is of the wrong data type

    Explanation: The #VALUE! error occurs when a formula includes a cell with the wrong data type — for example, using text where a number is expected.