In Excel, what does the error '#N/A' mean? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, what does the error '#N/A' mean?

A. Division by zero

B. Name not recognized

C. A value is not available to a function or formula

D. Invalid cell reference

Answer: Option C

Solution (By JKSSB Mock Tests)

#N/A indicates no value available, common in lookup functions.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1

Share Report

In MS Access, the default name of the first table created in a blank database is:

A. NewTable

B. Default

C. Table1

D. MainTable

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Access names new table Table1.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, what does the function =IF(A1>70, "Pass", "Fail") return if A1 contains 85?

A. Fail

B. TRUE

C. Pass

D. 85

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The condition A1>70 is true (85>70), so IF returns the value_if_true "Pass".

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Excel, which function will return 'TRUE' if the value in A1 is greater than 10 and less than 20?

A. =OR(A1>10, A1<20)

B. =NOT(A1>10)

C. =AND(A1>10, A1<20)

D. =IF(A1>10, A1<20)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
AND returns TRUE if all conditions are true.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs