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

Question
In Excel, a cell reference that changes when a formula is copied to another cell is called:
A. Absolute reference
B. Relative reference
C. Circular reference
D. Mixed reference
Answer: Option B
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, which pane is used to alter the sequence order, adjust triggers, or apply delays to individual slide entry animations?
A. Slide Master Layout
B. Transition Properties
C. Selection Pane
D. Animation Pane
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Animation Pane opens on the right side of the screen, allowing users to fine-tune animation timings, ordering, and playback mechanics.
This question belongs to: Computer Microsoft Office
Question #2
What is the shortcut key to open the 'Spelling and Grammar' check in MS Word?
A. F9
B. F5
C. Shift + F7
D. F7
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
F7 launches the Spelling and Grammar checker. F5 opens Find and Replace, F9 updates fields, Shift+F7 opens the Thesaurus.
This question belongs to: Computer Microsoft Office
Question #3
In MS Word, what does the 'Ctrl + Shift + K' shortcut do?
A. Inserts a hyperlink
B. Changes the font to Symbol
C. Applies small caps formatting
D. Starts a new line without breaking paragraph
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Shift+K toggles small caps.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: