Ch 11: Use Cell Ranges & References for Formulas & Functions in Excel

About This Chapter

Learn how to use cell references and ranges for formulas and functions in Excel. Follow our sequential video lessons to take your Excel expertise to the next level.

Use Cell Ranges & References for Formulas & Functions: Chapter Summary

Once you've learned how to create a table in Excel, you can explore the steps for using cell ranges and references to make calculations in your tables. This collection of lessons shows you how to use cell formulas and functions, define the order of operations and reference cell ranges or other worksheets in Excel.

Skilled experts show you all the essential steps through our brief instructional videos. Each lesson has a quick self-assessment quiz for feedback on your progress. Watch the videos as often as needed, and you can also refer to the lesson transcripts.

Lessons include the following topics:

  • Using formulas and functions in Excel
  • Understanding the difference between relative, absolute and mixed cell references
  • Defining the order of operations
  • Referencing cell ranges or other worksheets in your formulas

(Note: All demonstrations in this chapter will be using Microsoft Excel 2013. Certain features, tools, or displays may be different in other versions.)

Excel is a trademark of the Microsoft Corporation, which is not affiliated with

Chapter Practice Exam
Test your knowledge of this chapter with a 30 question practice chapter exam.
Not Taken
Practice Final Exam
Test your knowledge of the entire course with a 50 question practice final exam.
Not Taken

Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.