In MS Excel, what does the 'Freeze Panes' utility option accomplish? MCQ with Answer and Explanation

In MS Excel, what does the 'Freeze Panes' utility option accomplish?
A. Keeps rows or columns visible on screen while scrolling down the rest of the worksheet
B. Hides the formula visibility bar from the upper toolbar interface
C. Locks down specific cells to prevent unauthorized editing changes
D. Prevents formulas from performing background recalculations
Answer: Option A
Solution (By JKSSB Mock Tests)
Freeze Panes locks rows or columns in place, so they remain fully viewable while navigating through deep rows or long columns.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
To apply double line spacing in MS Word, press:
A. Ctrl + 1
B. Ctrl + 2
C. Ctrl + 5
D. Ctrl + D

Correct Answer: Option B


Explanation:
Ctrl+2 double spacing.

This question belongs to: Computer Microsoft Office
Question #2
In Word, which of the following is used to insert a symbol?
A. Insert > Symbol
B. Insert > Advanced Symbol
C. Home > Symbol
D. Both A and B

Correct Answer: Option D


Explanation:
Insert > Symbol and Insert > Advanced Symbol are similar.

This question belongs to: Computer Microsoft Office
Question #3
What is the keyboard shortcut to apply a hanging indent to a selected paragraph block in MS Word?
A. Ctrl + Shift + H
B. Ctrl + H
C. Ctrl + T
D. Ctrl + M

Correct Answer: Option C


Explanation:
Ctrl + T applies a hanging indent to the selected paragraph. Pressing Ctrl + Shift + T removes or reduces the hanging indent. Ctrl + M applies a standard left indent.

This question belongs to: Computer Microsoft Office