How to Find and Replace Data in Excel


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

question 1 of 3

Under what ribbon menu and group of commands will you see the Find & Select tool?

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 wanted to search for all text 'Boulder' and replace with 'Denver,' and you wanted to search the entire workbook, which image shows the correct action?

2. What other find options will you see if you click on the Options button in the Find dialogue box?

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

This quiz/worksheet combo will help gauge your understanding of running searches in Excel. In order to pass the quiz, you will need to determine where the Find & Select tool is, how to replace text, and what information and options are available to you in the Find dialogue box.

Quiz & Worksheet Goals

Use these assessment tools to assess your knowledge of:

  • Replacing text in both Excel worksheets and workbooks
  • The options button in Excel's Find dialogue box
  • Where to locate the Find & Select tool in Excel
  • Information provided in the Find dialogue box

Skills Practiced

This worksheet and quiz let you practice the following skills:

  • Distinguishing differences - compare and contrast topics from the lesson, such as searching and replacing text in a workbook compared to a worksheet in Excel
  • Reading comprehension - ensure that you draw the most important information about information and options provided by the Find dialogue box from the related Excel lesson
  • Knowledge application - use your knowledge of Excel's Find & Select tool to answer questions about replacing text

Additional Learning

To learn more about the Find & Select tool in Excel, check out the corresponding lesson on How to Find and Replace Data in Excel. This lesson will help you with the following objectives:

  • Learn the purpose of the Find & Select tool in Excel
  • Investigate an example of finding information on an Excel spreadsheet
  • Identify the steps for both finding and replacing records in Excel
  • Recognize further options available to users with Excel's Find tool