In Excel, what is the purpose of the 'Freeze Panes' feature? MCQ with Answer and Explanation

In Excel, what is the purpose of the 'Freeze Panes' feature?
A. Locks cell formatting
B. Prevents any changes to the worksheet
C. Keeps selected rows or columns visible while scrolling
D. Splits the window into multiple panes that can scroll independently
Answer: Option C
Solution (By JKExamLibrary)
Freeze Panes locks rows/columns. Split creates independent scrollable panes but doesn't lock.

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
In MS Word, what does the 'Gutter Margin' property refer to?
A. The bottom layout margin reserved for footnote entries.
B. The extra margin space added to the binding side of a document to prevent text coverage during binding.
C. The empty space located at the outer margins of headers.
D. The vertical spacing buffer separating two columns of text data.

Correct Answer: Option B


Explanation:
A gutter margin adds extra space to the side or top margin of a document intended for binding, ensuring that text remains fully visible and readable after the document is bound.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
What is the shortcut key to undo the last action in MS Office?
A. Ctrl + Y
B. Both A and C
C. Ctrl + Z
D. Alt + Backspace

Correct Answer: Option B


Explanation:
Ctrl+Z is the standard undo, and Alt+Backspace also works in many Office apps as undo. So both are valid.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In Access, which of the following is a valid data type for storing yes/no values?
A. All of the above
B. Yes/No
C. Boolean
D. Logical

Correct Answer: Option B


Explanation:
The data type in Access is called 'Yes/No' (or sometimes 'Boolean' in other databases). Access uses Yes/No. So B is correct.

This question belongs to: Computer Microsoft Office