How to Highlight Cells in Excel


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

question 1 of 3

What do you need to do before you can add a currency format to a range of cells?

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. There are three ways to highlight cells. You can click, hold and drag with your mouse, you can use the Shift key to select the first and last cells in your range or you can enter the range in the name box. If you wanted the range from A1 to G15, what would be the correct entry in the Name Box?

2. Under what ribbon menu and in what grouping of commands will you find the Color Fill 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

Underscoring the importance of this function in the program, this quiz and corresponding worksheet will help you gauge your knowledge of how to highlight cells within Microsoft Excel. Topics you'll need to know to pass the quiz include understanding what needs to be done before adding a currency format to a range of cells as well as knowing how to find the correct range in a name box.

Quiz & Worksheet Goals

Use this printable worksheet and quiz to review:

  • How to add a currency format to a range of cells
  • Finding the correct range in a name box
  • Where to find the color fill command
  • Most popular way to select cells

Skills Practiced

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

  • Problem solving - use acquired knowledge to solve ranges in Excel problems
  • Interpreting information - verify you can read information regarding the features of the color fill command and interpret it correctly
  • Knowledge application - use your knowledge to answer questions about how to add a currency format to a range of cells

Additional Learning

To learn more about how to select a range of cells, review the corresponding lesson How to Highlight Cells in Excel. This lesson will help you:

  • Define what highlighting means in Excel
  • Identify the two different operations in highlighting
  • Describe the process of how to highlight to select
  • Understand what highlighting involves to draw attention
  • Appreciate the differences between the two methods