In MS-Excel ...... option can be used to keep the desired rows and columns…
2022
In MS-Excel ...... option can be used to keep the desired rows and columns visible while the rest of the sheet scrolls.
- A.
Headings
- B.
Watch window
- C.
Freeze panes
- D.
Print Titles
Attempted by 630 students.
Show answer & explanation
Correct answer: C
To keep specific rows and columns visible while scrolling in MS-Excel, the correct feature must allow permanent visibility of selected areas during navigation. Option A: Headings are used to label data and do not provide any functionality to freeze rows or columns during scrolling. Option B: Watch window is used to monitor the values of specific cells, not to keep rows or columns visible while scrolling. Option C: Freeze panes allows users to lock specific rows and columns so they remain visible when scrolling through the rest of the worksheet. Option D: Print Titles is used to repeat certain rows or columns on every printed page, not during screen scrolling.