What is the shortcut to lock a cell reference (toggle absolute/relative) while editing a formula in Excel? MCQ with Answer and Explanation

What is the shortcut to lock a cell reference (toggle absolute/relative) while editing a formula in Excel?
A. Alt + Enter
B. Ctrl + 1
C. F2
D. F4
Answer: Option D
Solution (By JKExamLibrary)
F4 cycles through reference types in formula edit mode.

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 tab contains the 'Slide Master' command in MS PowerPoint?
A. Design
B. Insert
C. Home
D. View

Correct Answer: Option D


Explanation:
Slide Master is located under the View tab, in the Master Views group. It is not in Design, though Design affects themes.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In MS Word, 'Kerning for fonts' can be set from:
A. Styles
B. Font dialog -> Advanced tab
C. Page Setup
D. Paragraph dialog

Correct Answer: Option B


Explanation:
Kerning is under Font -> Advanced.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In PowerPoint, which view allows you to see the presenter's notes while the audience sees only slides?
A. Notes Page view
B. Slide Show view
C. Presenter View
D. Normal view

Correct Answer: Option C


Explanation:
Presenter View (available with dual monitors) shows notes and next slide. Notes Page view is for editing notes.

This question belongs to: Computer Microsoft Office