Question

Xavier wants to ensure that if he scrolls down through a worksheet that contains numerous rows of data that the initial column headings are not scrolling, making it easier to read the information in the spreadsheet. Which step should Xavier follow? A Hide the column heading rows. B Freeze the column heading rows. C Split the worksheet. D Merge the worksheet.

Answer 1

The correct answer is Choice B.

When you don’t want the top row to move as you are scrolling down the correct thing to do is freeze the column heading rows. This will keep the frozen row on the screen, while still scrolling through the rows below.

Answer 2

Given the context that Xavier wants to scroll through the worksheet without losing sight of the initial column headings, the correct answer would be...

B. Freeze the column.

Why B? Because A Hide the column is exactly the opposite of what we are looking for, we want to continue seeing the column, not lose sight of it. C Split the worksheet wouldn't change what scrolling does nor would D. Merge the worksheet. Basically, B is the logical answer of the 4 without a doubt because it is the only answer that even sounds like it would do what we are looking for.

Also, for those wondering, the easiest way to freeze the column is to type in the search bar "freeze" and then either select what you want to be froze then click freeze panes, or just click freeze top column.