|
Excel: Work Smarter
The next step is an example of how to reference data
on a different sheet.
Try it: Create a reference equation
Go to the Bonus spreadsheet
Select Cell B2 and type: =
Go the 2007 Sales Rep worksheet
Click on Cell H19,
the total for Alex.
Hit the Enter key to return to the
Bonus spreadsheet.
Make an equation for each of the four sales
representatives. |
|||
|
| |||
Microsoft Excel 2007 Exam 77-602 Topic: 3.1. Reference data in formulas
3.1.2. Create formulas that reference data from other worksheets or workbooks