Excel: Modifying Columns, Rows, and Cells Quiz

What happens when you increase the column width in Excel?

• The content in the column is duplicated.

• The content in the column becomes hidden.

• The content in the column becomes visible.

• The content in the column is deleted.

What does the AutoFit feature do in Excel?

• It deletes the content of the column.

• It automatically adjusts the column width to fit the content.

• It merges the cells in the column.

• It changes the font size of the content.

How can you modify the height of all rows in a worksheet at once?

• By changing the font size.

• By clicking the Select All button and dragging the row line.

• By using the AutoFit feature.

• By selecting each row individually.

What is the result of inserting a new row in Excel?

• The new row appears at the beginning of the worksheet.

• The new row appears at the end of the worksheet.

• The new row appears above the selected row.

• The new row appears below the selected row.

What happens when you delete a row in Excel?

• The row is deleted and the rows below shift up.

• The row is duplicated.

• The row is hidden.

• The row is moved to the end of the worksheet.

How can you move a column in Excel?

• By using the Merge command.

• By using the Delete command.

• By using the Cut command and Insert Cut Cells.

• By using the Copy command.

What is the purpose of hiding columns in Excel?

• To merge the columns.

• To change the color of the columns.

• To compare certain columns without changing the worksheet organization.

• To delete the columns permanently.

What does the Wrap Text command do?

• It allows cell content to be displayed on multiple lines.

• It merges the selected cells.

• It changes the font style of the text.

• It deletes the content of the cells.

What happens when you merge cells using the Merge & Center command?

• The selected cells are deleted.

• The selected cells are merged and the text is centered.

• The selected cells are hidden.

• The selected cells are duplicated.

What is a potential issue with merging cells in Excel?

• It can make it difficult to move, copy, and paste content.

• It deletes the content of the cells.

• It changes the font size of the text.

• It automatically hides the cells.