Exam 77-420 Microsoft Excel 2013 4. Apply Formulas and Functions 4.1 Apply Cell Ranges and References In Formulas and Functions: Reference Cell Ranges in Formulas

The Grand Total, cont. 4. Lastly, go to the Pigs sheet Select Cell E2 Hit Enter on your keyboard...   5. You will be taken back to Cell C2 in the Summary spreadsheet.   6. AutoFill this equation and you've got a formula that adds all of the sales for each product. Well done.   What Do You See? The formula says: =Spreadsheet!Cell where Legs, Eggs, and Pigs are the names of our spreadsheets. We linked several spreadsheets together to Sum up sales in one place. Way cool. This is a good place for a Cookie Break. Save your work and take a few minutes off.