graphic1

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.

This equation will link the Summary sheet to each of the product sheets: Legs, Eggs, and Pigs.

 

Try it: Create reference links

1. Start on the Summary Sheet

Select Cell C2 type: =.

All good equations begin with "="

 

2. Go to the Legs sheet

Select Cell E2.

Type + (to add the next variable)

 

3. Go to the Eggs sheet

Select Cell E2.

Type + (to add the next variable)

 

Keep going, please...

graphic2
graphic4