Which Excel view option splits the display area into multiple panes?

• A. Freeze Panes
• B. New Window
• C. Split
• D. View Side by Side

Answer: (C)

The ability to view different parts of a worksheet at once by dividing the screen into independent panes is being tested. The Split option creates horizontal and/or vertical split bars within the current window, so you can scroll each pane separately and keep specific rows or columns in view while you work in another area. This is handy for comparing data in distant parts of a sheet or keeping headers visible as you navigate.

Freeze Panes, by contrast, locks certain rows or columns so they stay visible while you scroll, but it doesn’t create multiple independent panes in the same window. New Window opens a separate window for the same workbook, allowing you to arrange windows side by side, which is not the same as splitting a single window. View Side by Side arranges two windows for comparison but again involves separate windows rather than splitting one window into panes.