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

Question

Share Report Error

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

A. Formula name not recognized

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

C. Wrong data type

D. Division by zero

Answer: Option B

Solution (By JKSSB Mock Tests)

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

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

What is the shortcut to maximize a document window in MS Word?

A. Alt + F10

B. Ctrl + F12

C. F11

D. Ctrl + F10

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+F10 maximizes document window.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, which function is used to join text from multiple cells with a delimiter (Excel 2019/365)?

A. JOIN()

B. CONCATENATE()

C. CONCAT()

D. TEXTJOIN()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
TEXTJOIN has a delimiter argument. CONCAT does not have delimiter.

This question belongs to: Computer Microsoft Office

Question #3

In MS Word, which feature enables you to repeat headings across the top edge of every single physical printed sheet automatically?

A. Footnote

B. Watermark

C. Header

D. Endnote

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A Header is a specialized layout zone positioned within the top margins of a document to display titles or page indexes uniformly.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs