In Excel, a cell reference that changes when a formula is copied to another cell is called: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, a cell reference that changes when a formula is copied to another cell is called:

A. Relative reference

B. Circular reference

C. Mixed reference

D. Absolute reference

Answer: Option A

Solution (By JKSSB Mock Tests)

Relative references (e.g., A1) adjust based on position. Absolute references ($A$1) stay fixed. Mixed references ($A1 or A$1) are partly fixed.

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

In MS PowerPoint, what is the action or function of the shortcut 'Ctrl + M'?

A. Saves the file

B. Inserts a new blank slide

C. Minimizes the interface

D. Opens a new window

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
In MS PowerPoint, Ctrl + M inserts a new slide into the active presentation, while Ctrl + N opens a brand-new blank file.

This question belongs to: Computer Microsoft Office

Question #2

What is the native file extension format for workbook files saved in modern versions of Microsoft Excel?

A. .xlsx

B. .xlsm

C. .xltx

D. .xls

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
.xlsx is the standard, macro-free XML-based file extension format for MS Excel workbooks since the 2007 version.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, which of the following is the correct syntax for SUMIF?

A. SUMIF(range, criteria, [sum_range])

B. SUMIF(criteria, sum_range)

C. SUMIF(criteria, range, sum_range)

D. SUMIF(range, sum_range, criteria)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
SUMIF(range, criteria, [sum_range]) is correct.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs