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

In Excel, a cell reference that changes when a formula is copied to another cell is called:
A. Mixed reference
B. Relative reference
C. Circular reference
D. Absolute reference
Answer: Option B
Solution (By JKExamLibrary)
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

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error
Which layout object in MS PowerPoint controls the global background colors, slide layout footprints, default paragraph sizes, and alignment rules for standard text blocks?
A. Slide Master
B. Handout Master
C. Notes Master
D. Design Ribbon

Correct Answer: Option A


Explanation:
The Slide Master is the foundational blueprint that controls style formatting rules and structural layouts for every slide inside a presentation.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
What is the shortcut key to paste without formatting in MS Office?
A. Alt + E, S, V
B. Both B and C
C. Ctrl + Alt + V
D. Ctrl + Shift + V

Correct Answer: Option B


Explanation:
Ctrl+Alt+V opens Paste Special, then you can choose unformatted text. Alt+E,S,V also does that. Ctrl+Shift+V is not standard in Office (it works in some non-Office apps).

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In MS Access, which of the following is NOT an action query?
A. Select query
B. Update query
C. Append query
D. Delete query

Correct Answer: Option A


Explanation:
Select queries retrieve data; they do not modify data. Action queries modify data.

This question belongs to: Computer Microsoft Office