From the course: Excel 2016 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Working with relative, absolute, and mixed references
From the course: Excel 2016 Essential Training
Working with relative, absolute, and mixed references
- We're looking at a worksheet called Absolute in our workbook 03 - Creating Formulas and Functions. In cell F2, we're about to calculate a new salary not only for Lisa but for all the others in our list here. Now, if everybody's going to get $2,000 more, we could write a simple formula here, equal E2, type it or click it, plus 2,000. And we can copy this down the column. Even before pressing Enter, we can point to the lower right-hand corner. Click and drag downward, and that formula will have been copied downward, and our original formula, E2 plus 2,000, has been copied here automatically to say E3 plus 2,000, and this is what we call a relative reference. As we copy a formula into a different row, the row reference in the formula, the row 2, becomes row 3, and becomes row 4, and down at the bottom, row 13. That happens automatically. It's referred to as a relative reference. But what if our salary calculation is going to be based on a percent increase 2.1%? Instead of this formula,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Creating simple formulas7m 11s
-
(Locked)
Copying a formula into adjacent cells3m 48s
-
(Locked)
Calculating year-to-date totals3m 49s
-
(Locked)
Creating a percentage-change formula7m 37s
-
(Locked)
Working with relative, absolute, and mixed references5m 32s
-
(Locked)
Using SUM and AVERAGE5m 18s
-
(Locked)
Using other common functions7m 44s
-
(Locked)
-
-
-
-
-
-
-
-
-
-
-
-
-