About This Chapter
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 Study.com.
1. How to Use Formulas & Functions in Excel
When you need Excel to do the math for you and run the calculations for totals and subtotals, formulas are your go-to feature. This lesson will introduce you to formulas, how they work and the different elements that make up a formula in Excel.
2. Cell References in Excel: Relative, Absolute & Mixed
Cell references are often used when creating Excel worksheets and writing formulas. This lesson will discuss the different types of cell references, such as absolute and relative. We will also look at examples of each one.
3. Defining Order of Operations in Excel
If you plan to write formulas in your Excel worksheets, understanding the order of operations is important. This lesson will explain how Excel performs the calculations in formulas and the order of mathematical operations.
4. Referencing Cell Ranges and Other Worksheets in Formulas
To save time and eliminate duplicate efforts, you want to have a complete understanding of cell references when using Excel. This lesson will explain the meaning of a cell reference and show you how to use them in formulas.
Earning College Credit
Did you know… We have over 160 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? Study.com 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.
Other chapters within the Intro to Excel: Essential Training & Tutorials course
- Creating Worksheets & Workbooks in Excel
- Formatting Worksheets & Workbooks in Excel
- Customizing Options & Views in Excel
- Configure to Print & Save in Excel
- Format Cells & Ranges in Excel
- Insert Data in Cells and Ranges in Excel
- Filter and Sort a Table in Excel
- Order & Group Cells & Ranges in Excel
- Create a Table in Excel
- Modify a Table in Excel
- Summarize Data with Functions in Excel
- Functions with Conditional Logic in Excel
- Format & Modify Text with Functions in Excel
- Create a Chart in Excel