NEW
Font size
WorksheetsG6 - Excel: Modifying Columns, Rows, and Cells Quiz
Total questions: 10
Worksheet time: 3mins
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
