Question

In MS Excel 2016, a window can be split into two parts by which of the following options?
1. Format -> Window
2. Developer -> Window -> Split
3. View -> Window -> Split
4. Page Layout -> Split

Answer 1

Correct Answer - Option 3 : View -> Window -> Split

The correct answer is option 3.

 View > Window > Split option can be used to split windows into two.

When you split a sheet into separate panes, you can scroll in both panes independently.

1. Select below the row where you want the split or the column to the right of where you want the split.
2. On the View tab, in the Window group, click Split. To remove the split panes, click Split again.

Hence the correct answer is View -> Window -> Split.