Question

Sarah is entering weekly sales data for week 37 of the current year; however, when she moves down to thecells where she needs to enter the data, the column headings scroll out of view and sometimes she losestrack of which column she is working in. What can Sarah do to keep the column headings visible even whileshe is working in a distant portion of the worksheet?a. Freeze the panes.b. Reset the window position.c. Cascade the window.d. Adjust the zoom so that she can see the entire worksheet on screen.

Answer 1

Answer:

a) freeze the panes

Explanation:

By freezing the panes she can lock the row that has the headers of each column and scroll down as much as she wants without losing sight of the rows locked. This can also be done with columns if the spreadsheet is organized horizontally.

Answer 2

Answer:

a. Freeze the panes

Explanation:

Spreadsheet programs like Excel have the command freeze panes that allows to visualize different parts of the worksheet at the same time by freezing rows or columns which helps you to view the cells chosen permanently when moving around the content. For example, you can freeze the top row that contains the names of the columns. According to this, the answer is that Sara can freeze the panes to keep the column headings visible even while she is working in a distant portion of the worksheet.