# Using the RIGHT, LEFT and MID Functions in Excel

Instructions:

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

question 1 of 3

### Which formula would you use to capture the first 4 characters of the data string located in B4?

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 for 30 days. Cancel anytime

### 2. The following string of characters is entered into cell D4, DLM343456B82. You would like to extract the last 3 characters and have them display in D5. What formula do you enter in D5?

Create your account to access this entire worksheet
A Premium account gives you access to all lesson, practice exams, quizzes & worksheets
Quizzes, practice exams & worksheets
Certificate of Completion
Create an account to get started

Quiz/worksheet questions will be in regard to things like uses of different Excel formulas, and the necessary formulas for certain desired outcomes. These questions will primarily come in the form of example problems.

## Quiz & Worksheet Goals

These practice questions will be on:

• A formula used to capture certain characters
• The way different formulas are applied
• Proper Excel formula structure

## Skills Practiced

• Information recall - access the knowledge you've gained regarding Excel's functions
• Interpreting information - verify that you can read information regarding character extraction in Excel and interpret it correctly
• Reading comprehension - ensure that you draw the most important information from the related lesson on Excel's Right, Left, and Mid functions