Cell References in Excel: Relative, Absolute & Mixed


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

question 1 of 3

There are three types of cell references. Relative and Mixed are two of them. What is the third?

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. Which cell reference will not change if copied or moved?

2. If in D3 you have =A1, what cell does D3 refer to?

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

Use this quiz to measure how well you understand cell references in Excel. Select the correct answer from your options to complete this quiz.

Quiz & Worksheet Goals

You will demonstrate your knowledge regarding:

  • Types of cell references
  • Cell references that stay the same or change when moved
  • Identifying cell references

Skills Practiced

The quiz also provides opportunities for you to practice:

  • Reading comprehension - ensure that you draw the most important information from the related cell references lesson
  • Knowledge application - use your knowledge to answer questions about structuring cell references
  • Information recall - access the knowledge you've gained regarding the types of cell references that will change or stay the same when moved

Additional Learning

You can continue learning about cell references in Excel by studying the lesson that accompanies this quiz, entitled Cell References in Excel: Relative, Absolute & Mixed. Within this lesson you will find information about:

  • What a cell reference means
  • The different types of cell references
  • How each type of cell reference is used