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

Online Learner

Creating Opportunities For A Better Life.®

Excel 2013

Single page view print copy

Relative and Absolute Cell References

Challenge!

  1. Open an existing Excel workbook. If you want, you can use the Lesson 15 Practice Workbook.
  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.
1 2 3 4