Question

____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.

Answer 1

"Freezing" rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.

The important point to consider is that you can freeze only rows at the top and columns on the left side of the worksheet and you cannot freeze in the middle of worksheet.The Freeze Panes summon isn't accessible when you're in cell altering mode (that is, you're entering an equation or information in a cell) or when a worksheet is ensured. To scratch off cell altering mode, press Enter or Esc. 
when you are going to freeze both rows and columns, you have to freeze them at the same time.

Answer 2

Freezing is the technique to keep headings in sight as you move about a worksheet. In modern Excel, the Freeze Panes command in the View menu lets you freeze a desired section (either on top, on the left, or both) so that it stays on the screen as you navigate, letting you keep track of the rows and column names as you go.