Excel Column and Row Management

This video tutorial covers how to insert and adjust rows and columns in Excel. It explains two methods for inserting single and multiple rows or columns, how to adjust their sizes, and how to move columns. The tutorial provides step-by-step instructions for each task, ensuring users can efficiently manage their Excel spreadsheets.

What is one method to insert a column to the left of a selected column in Excel?

• Highlight the column, go to the Home tab, and click 'Insert Sheet Columns'.

• Use the 'Format' menu to add a column.

• Select the column, press 'Delete', and then 'Insert'.

• Right-click the column and choose 'Delete'.

How can you insert a row above a selected row in Excel?

• Select the row, go to the Home tab, and click 'Insert Sheet Rows'.

• Use the 'Format' menu to add a row.

• Highlight the row, press 'Delete', and then 'Insert'.

• Right-click the row and choose 'Delete'.

What is the result of selecting a cell and right-clicking 'Insert'?

• The cell is deleted.

• A row or column is added above or to the left of the selected cell.

• The cell is moved.

• The cell is highlighted.

To insert three columns to the left of a specific column, what should you do?

• Highlight one column, go to the Home tab, and click 'Insert'.

• Select one column, right-click, and choose 'Insert'.

• Highlight three columns, right-click, and select 'Insert'.

• Use the 'Format' menu to add columns.

What is the correct way to adjust the size of a column in Excel?

• Highlight the column and press 'Delete'.

• Right-click the column and select 'Delete'.

• Use the 'Format' menu to delete the column.

• Drag the boundary between columns or double-click it.

How can you adjust multiple rows to the same size in Excel?

• Highlight one row and press 'Delete'.

• Highlight all rows, adjust one, and all will follow.

• Select one row, right-click, and choose 'Delete'.

• Use the 'Format' menu to adjust each row individually.

What happens if you double-click the boundary between two columns?

• The column is moved.

• The column is highlighted.

• The column is deleted.

• The column adjusts to fit the content automatically.

What is the first step to move a column to a new location in Excel?

• Highlight the column and press 'Delete'.

• Use the 'Format' menu to move the column.

• Right-click the column and choose 'Delete'.

• Select the column, go to the Home tab, and click 'Cut'.

When moving a column, why do you select the column to the right of the target location?

• To highlight the column.

• To format the column.

• To delete the column.

• To ensure the column is placed correctly.

How do you move two columns to a new location in Excel?

• Highlight both columns and press 'Delete'.

• Select both columns, cut them, and select two columns to the right of the target location.

• Highlight one column, right-click, and choose 'Delete'.

• Use the 'Format' menu to move each column individually.