MO-211 practice question 19 of 35
What is the purpose of the Freeze Panes command in Excel?
Full set: 355 questionsDomain Manage presentations
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.
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.
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."
Keep practicing
Take the free MO-211 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MO-211 practice questions
- Question 1What formula can be used to calculate the sum of a range of cells in Excel?
- Question 2Which chart type is best used to display trends over time?
- Question 3What is the formula used in Excel to calculate the percentage change between two numbers?
- Question 4What is a slicer in Excel?
- Question 5What is the shortcut key to insert a new worksheet in Excel?
- Question 6What is the shortcut key for copying a formula in Excel?
