Question

Freeze panes so the first row containing column headings (row 5) on the Support Calls worksheet will remain static when scrolling. Ensure that rows 1-4 are visible.

a) View > Freeze Panes > Freeze Top Row
b) View > Freeze Panes > Freeze First Column
c) View > Freeze Panes > Freeze Panes
d) View > Freeze Panes > Split

Answer 1

Freeze panes so the first row containing column headings (row 5) on the Support Calls worksheet will remain static when scrolling. Ensure that rows 1-4 are visible.

a) View > Freeze Panes > Freeze Top Row

Step-by-step explanation:

To freeze panes in Microsoft Excel so that the first row containing column headings (row 5) remains static when scrolling, the correct option is a) View > Freeze Panes > Freeze Top Row. This action ensures that when you scroll down through the worksheet, rows 1-4 remain visible, and only row 5, which contains the column headings, stays fixed at the top of the screen.

Option b) Freeze First Column is used when you want to keep the first column visible while scrolling horizontally. Option c) Freeze Panes is a general option that freezes both rows and columns based on the active cell's position. Option d) Split is used to create separate panes within the worksheet, but it doesn't specifically freeze rows or columns.

By selecting View > Freeze Panes > Freeze Top Row, you are indicating that you want the top row to be frozen, ensuring that your column headings are always visible, providing a helpful reference as you navigate through the data. This Excel feature is particularly useful when dealing with large datasets, making it easier to understand and analyze information without losing track of column headers.

Answer 2

To freeze the first row with column headings (row 5) and keep rows 1-4 visible in Excel, you should select any cell in row 6, go to the View tab, click Freeze Panes, and then choose Freeze Panes from the dropdown menu.

The correct option is c.

Step-by-step explanation:

The question pertains to how to freeze panes in a spreadsheet, specifically in Microsoft Excel, so that certain rows remain visible while scrolling through the rest of the worksheet.

The correct option to freeze the first row that contains column headings (which is row 5 in this case) while ensuring that rows 1-4 remain visible is:

c) View > Freeze Panes > Freeze Panes

Here are the steps to freeze the panes correctly:

1. Select the cell in the row directly below the row you want to freeze, which would be any cell in row 6 for this scenario.
2. Go to the View tab in the Excel ribbon.
3. Click on Freeze Panes in the Window group.
4. Select Freeze Panes from the dropdown menu.

By doing this, row 5 will remain static at the top of the worksheet as you scroll down, and rows 1-4 will also be visible.

The correct option is c.