In Excel, which error value indicates that a formula contains invalid numeric values? MCQ with Answer and Explanation

In Excel, which error value indicates that a formula contains invalid numeric values?
A. #NAME?
B. #VALUE!
C. #DIV/0!
D. #REF!
Answer: Option B
Solution (By JKExamLibrary)
#VALUE! appears when wrong data type is used. #REF! invalid reference, #DIV/0! division by zero, #NAME? unrecognized text.

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 MS Word, which feature enables you to repeat headings across the top edge of every single physical printed sheet automatically?
A. Header
B. Watermark
C. Footnote
D. Endnote

Correct Answer: Option A


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
Question #2 Report Error
Which keyboard shortcut opens the 'Find and Replace' dialog box with the 'Replace' tab directly active in MS Word?
A. Ctrl + H
B. Ctrl + F
C. Ctrl + R
D. Ctrl + G

Correct Answer: Option A


Explanation:
Ctrl + H opens the Find and Replace dialog box focusing immediately on the Replace tab. Ctrl + F launches the Navigation/Find pane.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In MS Word, what type of section break moves the section split marker onto the next page layout boundary, forcing new text onto a new sheet?
A. Continuous Section Break
B. Even Page Section Split
C. Next Page Section Break
D. Column Page Break Layout

Correct Answer: Option C


Explanation:
A 'Next Page' section break starts the new section on the following page, while a 'Continuous' section break starts the new section on the same page.

This question belongs to: Computer Microsoft Office