G6 - Excel: Modifying Columns, Rows, and Cells Quiz

How can you modify the width of a column in Excel?

• Double-click the mouse

• Click and drag the mouse to increase or decrease the column width

• Right-click the mouse and select 'Modify Width'

• Press Ctrl+C on your keyboard

What does Excel display if the column is too narrow to show numerical data?

• Dollar signs ($$$$$)

• Asterisks (*****)

• Exclamation marks (!!!)

• Pound signs (#######)

How can you set a column's width to fit its content automatically in Excel?

• Double-click the mouse

• Right-click the mouse and select 'AutoFit'

• Press Ctrl+Shift+A on your keyboard

• Click and drag the mouse to increase or decrease the column width

What is the method to modify the height and width of every row and column at the same time in Excel?

• Select the entire worksheet and press Ctrl+M

• Click and drag the mouse to increase or decrease the row height

• Right-click the mouse and select 'Modify All'

• Locate and click the Select All button, then click and drag the mouse

How can you insert a new row between existing rows in Excel?

• Press Alt+I on your keyboard

• Click the Insert command on the Home tab

• Right-click the mouse and select 'Insert New Row'

• Double-click the mouse

What happens when you delete a row or column in Excel?

• The selected row or column will be deleted and those around it will shift

• The selected row or column will be moved to a different location

• The selected row or column will be hidden

• The selected row or column will be cleared of its contents

How can you move a column to a different location in Excel?

• Select the desired column heading, click the Cut command, then click the Insert command at the desired location

• Click the Cut command on the Home tab, then select the desired location

• Right-click the mouse and select 'Move Column'

• Select the desired column heading, then click the Move command on the Home tab

What is the purpose of hiding rows and columns in Excel?

• To permanently delete the rows and columns

• To increase the performance of the worksheet

• To compare certain rows or columns without changing the organization of the worksheet

• To make the worksheet look cleaner

When would you decide to wrap the text or merge the cell in Excel?

• When the cell content is too short to be displayed in a single cell

• When the cell content is in a different language

• When the cell content is too long to be displayed in a single cell

• When the cell content is in a different format

What does the AutoFit feature in Excel do?

• Automatically changes the color of the cell content

• Automatically adjusts the font size of the cell content

• Automatically fits the content of a cell to the height of the row

• Automatically fits the content of a cell to the width of the column