In Excel, the error '#REF!' indicates: MCQ with Answer and Explanation

Question Report Error

In Excel, the error '#REF!' indicates:

A. Invalid cell reference (cell may have been deleted)

B. Division by zero

C. Formula name not recognized

D. Wrong data type

Answer: Option A

Solution (By JKExamLibrary)

#REF! means a reference is invalid. #DIV/0! division by zero, #NAME? unrecognized text, #VALUE! wrong type.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error

In Excel, the 'Solver' add-in is used for:

A. Solving equations

B. Statistical analysis

C. Optimization and what-if analysis with multiple constraints

D. Goal seeking

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Solver finds optimal value for a target cell by changing multiple variables.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

To navigate to the next cell in a table in MS Word, press:

A. Ctrl + Right arrow

B. Enter

C. Tab

D. Arrow keys

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Tab moves to next cell; Shift+Tab to previous.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In MS Access, which of the following is NOT a valid data type?

A. Currency

B. DateTime

C. Memo

D. Yes/No

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
The correct name is Date/Time, not DateTime.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs