Which feature allows you to view four areas of a worksheet at once, with independent scrolling?

Which feature allows you to view four areas of a worksheet at once, with independent scrolling?

• A. View, Split.
• B. View, Freeze Panes.
• C. Page Layout, Breaks.
• D. Review tab, Protect Workbook.

Answer: (A)

Viewing four areas of a worksheet at once with independent scrolling is achieved by splitting the window. In the View tab, choosing Split creates vertical and horizontal split bars that divide the sheet into four panes, each with its own scrollbar. This lets you scroll one pane while the others stay in place, which is great for comparing distant data or keeping headers visible while you inspect other parts of the sheet. The other options don’t create multiple independent panes: Freeze Panes keeps selected rows or columns visible as you scroll but doesn’t provide four separate scrolling areas; Page Layout and Breaks are about page formatting; Protect Workbook is about security and does not affect how you view the worksheet.

Viewing four areas of a worksheet at once with independent scrolling is achieved by splitting the window. In the View tab, choosing Split creates vertical and horizontal split bars that divide the sheet into four panes, each with its own scrollbar. This lets you scroll one pane while the others stay in place, which is great for comparing distant data or keeping headers visible while you inspect other parts of the sheet. The other options don’t create multiple independent panes: Freeze Panes keeps selected rows or columns visible as you scroll but doesn’t provide four separate scrolling areas; Page Layout and Breaks are about page formatting; Protect Workbook is about security and does not affect how you view the worksheet.