The Complete Excel Guide: Beginners to Advanced - Split Screen Option

The video tutorial covers the split screen feature in Excel, explaining how it allows users to view different parts of a workbook simultaneously without scrolling. The instructor demonstrates how to activate and adjust the splitter, use scroll bars, and turn off the feature. Advanced usage techniques are also discussed, providing flexibility in viewing multiple sections. The tutorial concludes with a transition to the next module, focusing on page setup and print options.

What is the primary purpose of the split screen option in Excel?

• To add a new worksheet

• To delete a worksheet

• To change the color of the worksheet

• To view two different parts of a worksheet simultaneously

In the example provided, which row contains the interest paid in the first month of the loan?

• Row 8

• Row 9

• Row 68

• Row 60

How can you deactivate the split screen in Excel?

• By clicking 'Split' again or dragging the splitter to the top

• By changing the worksheet color

• By closing the Excel application

• By deleting the worksheet

What happens if you save your Excel file with the splitter on?

• The file will not save

• The splitter will remain active when you reopen the file

• The file will be corrupted

• The splitter will be removed when you reopen the file

What additional functionality does the split screen offer besides vertical splits?

• Color changes

• Horizontal splits

• Deleting worksheets

• Adding new worksheets