Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.3. Apply cell references in formulas: Use Absolute and Relative cell references

Create the Formulas

The next steps use a formula to create a Relative Cell Reference that links data from the Sales Subtotal by Month spreadsheet that Subtotals each Month's sales.

3. Try it: Create the Formulas

Start on the Sparkline spreadsheet.

All equations begin with equals.


Select Cell B2 and type: =.

Go to the Sales Subtotal by Month sheet and click on the amount for January in Column H.

Select Cell B3 and type: =.

Go to Sales Subtotal by Month and click on the amount for February in Column H.


Please create formulas for the other months as well. Keep going...!


Memo to Self: You can use the sample spreadsheet  or just type the data that you see on this page if you wish.