What error code is returned by MS Excel if a formula references a cell location that has been completely deleted by removing its row or column? MCQ with Answer and Explanation

Question

What error code is returned by MS Excel if a formula references a cell location that has been completely deleted by removing its row or column?

A. #NUM!

B. #VALUE!

C. #REF!

D. #NAME?

Answer: Option C

Solution (By JKSSB Mock Tests)

The #REF! error signals an invalid cell reference, which typically happens when cells targeted by formulas are deleted from the spreadsheet layout.

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 Word, what is the function of the 'Format Painter'?

A. Checks spelling and grammar

B. Changes the font of the entire document

C. Clears all formatting

D. Copies formatting from one piece of text and applies it to another

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Format Painter copies format. Clear Formatting removes formatting.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Access, which object stores data in a structured format of rows and columns?

A. Report

B. Form

C. Query

D. Table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Tables hold the raw data. Queries extract data, forms display it, reports present it.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Word, which reference tool places short citations at the bottom boundary of the same page where a number indicator reference was added?

A. Endnote

B. Bibliography

C. Footnote

D. Caption index

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Footnotes reside at the bottom base of the active page. Endnotes are compiled at the end of the entire document.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs