Leadership

Computer

Test your understanding of this lesson Excel Adding, Deleting, and Hiding Rows and Columns:-

1)
How can you add a new row in Excel?
  • Right-click on the row and choose "Add Row"
  • Press the "Ctrl + R" keyboard shortcut
  • Go to the "Insert" tab and click on "Row"
  • None of the above
2)
What happens when you delete a column in Excel?
  • The column is completely removed from the worksheet
  • The column becomes hidden but can be unhidden later
  • The column turns into a blank column with no data
  • None of the above
3)
How can you hide a row in Excel?
  • Right-click on the row and choose "Hide"
  • Press the "Ctrl + H" keyboard shortcut
  • Go to the "Format" tab and click on "Hide Row"
  • None of the above
4)
How can you unhide a hidden column in Excel?
  • Right-click on any column and choose "Unhide"
  • Go to the "View" tab and click on "Unhide Column"
  • Use the "Ctrl + Shift + C" keyboard shortcut
  • None of the above
5)
Which ribbon tab contains the option to hide and unhide rows and columns in Excel?
  • Home
  • Insert
  • Format
  • View
Hand draw

Hide

Forgot your password?

Close

Error message here!

Hide

Lost your password? Please enter your email address. You will receive a link to create a new password.

Back to log-in

Close