Exam 77-420 Microsoft Excel 2013 4. Apply Formulas and Functions 4.2 Summarize Data with Functions: Summarize Data with Functions

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. Press the ENTER key.   Select Cell B3 and type: = Go to Sales Subtotal by Month and click on the amount for February in Column H. Press the ENTER key.   AutoFill will NOT work here. 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.