How to Insert & Delete Columns & Rows in Excel


Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

What are the different ways to take action in Excel?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 79,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime
Already registered? Log in here for access

1. If you right-click on a row reference number and click on Insert, where will the row be added?

2. To use the ribbon commands, what menu and grouping of commands will you find the Insert and Delete command?

Create your account to access this entire worksheet
A Premium account gives you access to all lesson, practice exams, quizzes & worksheets
Access to all video lessons
Quizzes, practice exams & worksheets
Certificate of Completion
Access to instructors
Create an account to get started Create Account

About This Quiz & Worksheet

Focusing on how to make the functions of Excel easier, this quiz and corresponding worksheet will help you gauge your knowledge of how to insert and delete columns and rows in Microsoft Excel. Topics you'll need to know to pass the quiz include understanding the different ways to take action in Excel as well as knowing the location of a row to be added.

Quiz & Worksheet Goals

Use this printable worksheet and quiz to review:

  • Different ways to take action in Excel
  • Location of a row to be added
  • Where to find the insert and delete command
  • What happens when you choose insert
  • How to quickly insert a column or row

Skills Practiced

This worksheet and quiz will let you practice the following skills:

  • Reading comprehension - ensure that you draw the most important information from the related columns and rows lesson
  • Interpreting information - verify you can read information regarding how to quickly insert a column or row and interpret it correctly
  • Knowledge application - use your knowledge to answer questions about the location of a row to be added

Additional Learning

To learn more about the advanced features of Excel, review the corresponding lesson How to Insert & Delete Columns & Rows in Excel. This lesson will help you:

  • Know the importance of columns and rows in a spreadsheet
  • Identify the ways to insert and delete rows and columns
  • Describe how to use the ribbon commands
  • Understand how the right-click method can be used and the difference from commands
  • Appreciate the benefits of keyboard short-cuts