How to Add & Remove Columns & Rows in an Excel Table


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

question 1 of 3

If you wanted to convert standard worksheet data into an Excel table, what command would you use?

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. Why does adding a table to an Excel worksheet make adding data easy?

2. What is the name of the command that will help you adjust the number of columns and rows in an Excel table?

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

Taking a look at what can sometimes be a tricky process, this quiz and corresponding worksheet will help you gauge your knowledge of how to add and remove columns and rows in Microsoft Excel. Topics you'll need to know to pass the quiz include understanding the command to convert data into an Excel table, as well as knowing the benefits of using a table.

Quiz & Worksheet Goals

Use this printable worksheet and quiz to review the following Excel concepts:

  • Command to convert data into a table
  • Benefits of using a table
  • Name of the command to adjust the rows and columns
  • Where to find the Resize command
  • How to delete table rows and columns

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 lesson on columns and rows in Excel
  • Interpreting information - verify you can read information regarding the command to convert data into a table and interpret it correctly
  • Knowledge application - use your knowledge to answer a question about the name of the command to adjust the rows and columns

Additional Learning

To learn more about how to get Excel tables to do exactly what you want, review the corresponding lesson titled How to Add & Remove Columns & Rows in an Excel Table. This lesson will help you:

  • Understand what working with tables in Excel involves
  • Describe the advantages to using tables within the program
  • Identify how to remove and add data to the tables
  • Appreciate what you must do to insert and delete rows and columns
  • Know what it takes to resize tables in Excel
Final Exam
Chapter Exam
Create a Table in Excel
Chapter too short for exam