Correct Answer:
B. View → Window → Split
Excel's 'Split Window' feature is incredibly useful for viewing different sections of a large worksheet simultaneously, allowing users to keep headers or specific data visible while scrolling through other parts. The question asks for the correct path to access this feature in Excel 2016.
- The correct option is View → Window → Split. In Excel 2016 and subsequent versions, the 'Split' command is located under the 'View' tab on the Ribbon, within the 'Window' group. Clicking this command divides the worksheet window into separate panes, which can be scrolled independently.
- 'Format → Window → Split' is incorrect. The 'Format' tab primarily deals with formatting cells, rows, columns, and objects, not window management.
- 'Page Layout → Split' is incorrect. The 'Page Layout' tab is dedicated to settings related to printing, such as margins, orientation, and page breaks, not splitting the view of the worksheet.
By using the 'View' tab, users can manage how their worksheet is displayed, including options like splitting, freezing panes, and arranging windows.