Excel Freezing and Splitting Features

The video tutorial explains how to use Excel's freeze panes and split features. It covers freezing the top row, the first column, and both rows and columns simultaneously. Additionally, it demonstrates the split feature, allowing users to view different sections of a spreadsheet independently. The tutorial provides step-by-step instructions for each feature, helping users manage large datasets effectively.

What is the purpose of freezing the top row in Excel?

• To keep the first column visible while scrolling

• To highlight the first row

• To lock the entire worksheet

• To keep the headers visible while scrolling down

Which menu option allows you to freeze the top row in Excel?

• Data

• View

• Home

• Insert

What happens when you freeze the first column in Excel?

• The first row is locked

• The first column remains visible while scrolling horizontally

• The entire worksheet is locked

• The last column is highlighted

How can you freeze both rows and columns at the same time?

• By selecting the entire worksheet

• By highlighting the first cell

• By selecting a specific cell and using the freeze panes option

• By using the sort feature

If you want to freeze the first row and the first column, which cell should you select?

• B2

• D2

• A1

• C1

What does the split feature in Excel allow you to do?

• Highlight specific cells

• Sort data in ascending order

• Divide the worksheet into multiple sections for better navigation

• Lock the entire worksheet

How can you adjust the split lines in Excel?

• By using the sort feature

• By clicking the Home tab

• By selecting the entire worksheet

• By dragging the lines to the desired position

What should you do to remove the split feature in Excel?

• Click the Home tab

• Use the sort feature

• Select the entire worksheet

• Click the split button under the View tab

Which feature allows you to keep certain portions of the worksheet visible while scrolling?

• Filter

• Sort

• Conditional Formatting

• Freeze Panes

What is the result of using the split feature on a worksheet?

• The worksheet is locked

• The worksheet is divided into four sections

• The first row is highlighted

• The last column is locked