|
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.
Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.3. Apply cell references in
formulas: Reference data from other worksheets or workbooks
|
|
| |
