How to Code & Recode Data in Excel


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

question 1 of 3

In Microsoft Excel, the _____ command compares a value against a translation table and assigns a new value.

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. The _____ command is used to tell Excel what to do if the conditions of a query are not met.

2. When using Excel, re-coding data is necessary when:

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

We've made it easy to assess your understanding of coding and recoding data in Excel with help from this engaging quiz/worksheet combo. Before you move on to other subjects or take an important test, answer these questions about the Excel command that outlines what to do if the conditions of a query aren't met and when re-coding data is necessary.

Quiz & Worksheet Goals

Use this tool to see how well you know:

  • Which command compares a value against a translation table and assigns a new value
  • Situations in which data must be re-coded
  • The Excel command that's associated with the action of comparing one value to another and then taking action
  • The Excel worksheet where new values are substituted for original values

Skills Practiced

  • Interpreting information - verify that you can read information regarding the Excel command that compares a value against a transaction table and interpret it correctly
  • Knowledge application - use your knowledge to answer questions about the Excel worksheet that involves the substitution of new values for original ones
  • Reading comprehension - ensure that you draw the most important information from the related lesson on coding and recoding data in Excel

Additional Learning

For more information about this concept, take a look at our engaging lesson called How to Code & Recode Data in Excel. Once you complete this lesson, you should be ready to:

  • Explain what the COUNT command in Excel does
  • Give an example of the use of the IF command
  • Outline the Excel commands for recoding data