How to Band Rows & Columns in an Excel Table


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

question 1 of 3

You learned in this lesson that there are two ways to apply color banding to data in a worksheet. Which option gives you more control and lets you customize the color scheme?

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. Where will you find the Format as Table command?

2. Where in the ribbon will you find the gallery of Table Styles?

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

Checking out more professional uses of the program than the average user, this quiz and corresponding worksheet will help you gauge your knowledge of banding rows and columns in Microsoft Excel tables. Topics you'll need to know to pass the quiz include understanding which of the two ways to apply color banding gives more control as well as knowing where to find the format as table command.

Quiz & Worksheet Goals

Use this printable worksheet and quiz to review:

  • Which way to apply color banding gives more control
  • Where to find the format as table command
  • Location of the gallery of table styles
  • Formula for using conditional formatting
  • Easier option to apply color banding

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 banding rows and columns in Excel tables lesson
  • Distinguishing Differences - compare and contrast topics from the lesson, such as the two options to apply color banding
  • Knowledge application - use your knowledge to answer questions about where to find the format as table command

Additional Learning

To learn more about how to work like a pro in Excel, review the corresponding lesson How to Band Rows & Columns in an Excel Table. This lesson will help you:

  • Define what banded rows are in Excel
  • Understand the two different ways to add color banding to a worksheet
  • Describe the ease of use of the table styles option
  • Identify how conditional formatting can be used
  • Appreciate the differences between the two ways to apply color banding
Final Exam
Chapter Exam
Modify a Table in Excel
Chapter too short for exam