In Excel, a cell address $A1 is an example of: MCQ with Answer and Explanation

In Excel, a cell address $A1 is an example of:
A. Circular reference
B. Mixed reference
C. Relative reference
D. Absolute reference
Answer: Option B
Solution (By JKSSB Mock Tests)
$A1 has column absolute, row relative, so it's mixed.

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 object allows you to add reusable content like a company logo to every slide?
A. Header & Footer
B. Notes Master
C. Slide Master
D. Handout Master

Correct Answer: Option C


Explanation:
Slide Master controls the overall layout and design of all slides in a presentation; adding a logo to the Slide Master will place it on all slides. Header & Footer is for page numbers, date, etc. Notes Master and Handout Master are for notes and handouts.

This question belongs to: Computer Microsoft Office
Question #2
In PowerPoint, to compress all images in a presentation to reduce file size, use:
A. View -> Slide Master
B. Insert -> Picture -> Compress
C. File -> Compress Pictures (under Save As Tools) or Picture Format -> Compress Pictures
D. Design -> Compress Media

Correct Answer: Option C


Explanation:
Compress Pictures option is available in Picture Format tab or via File > Save As > Tools.

This question belongs to: Computer Microsoft Office
Question #3
Which shortcut key exits a live running slide show presentation immediately and returns to the workspace interface in MS PowerPoint?
A. Esc
B. Backspace
C. Spacebar
D. Enter

Correct Answer: Option A


Explanation:
The Escape (Esc) key terminates an active presentation run immediately, safely dropping back into the designer workspace.

This question belongs to: Computer Microsoft Office