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

Create the Formulas The next steps use a simple formula to create a Relative Cell Reference that links the data from the Sales Subtotal by Rep spreadsheet that Subtotals each Reps sales. 3. Try it: Create the Formulas Start on the Bonus spreadsheet. All equations begin with equals.   Select Cell B2 and type: =. Go to the Sales Subtotal by Rep sheet and click on the amount for Alex in the H column.   Select Cell B3 and type: =. Go to Sales Subtotal by Rep and click on the amount for Connie in the H column.   Please create formulas for Elizabeth and Nikki 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.