Referencing Cell Ranges and Other Worksheets in Formulas


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

question 1 of 3

Which statement is true when referring to cell references?

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 formula is correct when referencing cells in a different worksheet?

2. If you were to write a formula that adds cells A1, A2, A3, and A4 together, which formula would be the most efficient?

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 and worksheet to review what you know about Excel referencing formulas. You will need to prove you understand several formulas in order to pass this quiz.

Quiz & Worksheet Goals

You will be responsible for answering questions that deal with:

  • Formulas that reference other worksheets
  • Determining which formulas are efficient
  • Identifying cell references

Skills Practiced

Take this quiz and you'll be able get practice using these study skills:

  • Reading comprehension - ensure that you draw the most important information from the related lesson on Excel referencing formulas
  • Interpreting information - verify that you can read statements regarding cell references and interpret if they are true or false
  • Information recall - access the knowledge you've gained to identify a part of a formula

Additional Learning

You can find out more about this subject by studying the lesson entitled Referencing Cell Ranges and Other Worksheets in Formulas. This lesson will provide you with information about:

  • What a cell reference is
  • How cell ranges are used
  • The steps for referencing another worksheet