Question

Identify the error which will be displayed on the screen when the value is not available to a function or formula:

• A. Correct #DIV/0! Error
• B. Correct #NUM! Error
• C. Correct #N/A Error
• D. Correct #Name Error

Hint:

The \#N/A error in Excel indicates "No Value Available". It is commonly seen in lookup functions like VLOOKUP or MATCH when the lookup value is not found.

Answer 1

The Correct Option is C

Each error type in Excel has a specific meaning: 
(A) #DIV/0! Error \(\Rightarrow\) Occurs when a number is divided by zero or an empty cell. 
(B) #NUM! Error \(\Rightarrow\) Appears when there are invalid numeric values in a formula (e.g., square root of a negative number). 
(C) #N/A Error \(\Rightarrow\) Indicates that a value is not available to a function or formula. 
(D) #NAME? Error \(\Rightarrow\) Happens when Excel doesn't recognize a function name or named range. 
\(\Rightarrow\) The question asks about missing or unavailable values. 
\(\Rightarrow\) This matches the meaning of #N/A Error.