Correct option is C
In MS Excel 2016, the
Split option is located under the
View tab in the
Window group. This feature allows you to divide the Excel window into multiple panes, enabling users to view and work on different parts of the same worksheet simultaneously.
Important Key Points:
1.
Split divides the active worksheet into sections either horizontally, vertically, or both.
2. It helps users manage large datasets efficiently by keeping certain rows or columns in view.
3. To remove the split, simply click the
Split button again.
Knowledge Booster:
·
Format and
Page Layout: Focus on styling and page setup options, not window management.
·
Developer Tab: Used for advanced functions like macros and does not include the split option.
· The Split feature is commonly used alongside the Freeze Panes option for enhanced worksheet navigation.