GCFLearnFree.org

Wish I had found you before I spent $100 to take a class. Thanks!”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel Formulas
  • Relative and Absolute Cell References

Excel Formulas

Single page view print copy

Relative and Absolute Cell References

Challenge!

  1. Open an existing Excel workbook. If you want, you can use the example file for this lesson.
  2. Create a formula that uses a relative reference. If you are using the example, use the fill handle to fill in the formula in cells E4 through E14. Double-click a cell to see the copied formula and the relative cell references.
  3. Create a formula that uses an absolute reference. If you are using the example, correct the formula in cell D4 to refer only to the tax rate in cell E2 as an absolute reference, then use the fill handle to fill the formula from cells D4 to D14. 
  4. Try referencing a cell across worksheets. If you are using the example, create a cell reference in cell B3 on the Catering Invoice worksheet for cell E15 on the Menu Order worksheet.

previous next
previous 1 2 3 4 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.

Cancel