MO-211 practice question 19 of 35

What is the purpose of the Freeze Panes command in Excel?

Full set: 355 questions

Domain Manage presentations

Answer options
A: To protect a worksheet from being edited
B: To lock specific cells in a worksheet
C: To split a worksheet into multiple panes
D: To prevent specific rows or columns from scrolling out of view Correct answer
Correct Answer:
D. To prevent specific rows or columns from scrolling out of view
Explanation

The Freeze Panes command is a viewing feature in Microsoft Excel designed to enhance data readability in large worksheets. Its specific purpose is to lock designated rows and/or columns in place. When a user scrolls vertically or horizontally through the data, the frozen rows (typically containing headers) and columns (often containing labels or identifiers) remain visible on the screen. This allows the user to maintain context and easily reference headers while navigating extensive datasets, preventing them from scrolling out of view.

Why Incorrect

A. To protect a worksheet from being edited is incorrect. This functionality is handled by the "Protect Sheet" command, found on the Review tab, which restricts editing capabilities.
B. To lock specific cells in a worksheet is incorrect. While related to protection, locking cells is a property set in the "Format Cells" dialog and is only enforced when "Protect Sheet" is activated.
C. To split a worksheet into multiple panes is incorrect. This describes the "Split" command, which divides the worksheet into two or four separate, independently scrollable panes.

References

1. Microsoft Corporation. (n.d.). Freeze panes to lock rows and columns. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f.

Reference Point: The first paragraph states

"To keep an area of a worksheet visible while you scroll to another area of the worksheet

go to the View tab

where you can Freeze Panes to lock specific rows and columns in place..."

2. University of Wisconsin-Madison. (n.d.). Excel - Freeze or Unfreeze Rows and Columns. KnowledgeBase. Retrieved from https://kb.wisc.edu/helpdesk/page.php?id=2544.

Reference Point: The introductory section notes

"When working with a large amount of data

you can freeze rows or columns. This allows you to keep the rows and/or columns visible while you scroll through the rest of the worksheet."

3. GCFGlobal.org. (n.d.). Excel: Freezing Panes and View Options. Goodwill Community Foundation

Inc. Retrieved from https://edu.gcfglobal.org/en/excel/freezing-panes-and-view-options/1/.

Reference Point: Under the "Freezing rows and columns" section

it explains

"Freezing panes allows you to lock a certain number of rows and/or columns. This means that when you scroll down or to the right

the frozen panes will stay on the screen."

Scroll to Top