|
Excel: Work Smarter
Simple Functions
Now all of the pieces are in place to figure out the bonus
for each of your sales reps. What would a Chart of the Total Sales
look like?
Try it: Enter the Equation
Select cell D2
Enter the following
equation: =B2*C2
Try it: Create a Sales Chart,
Select Cells A1 through B5.
Go to Insert -> Pie Chart Insert
-> Pie Chart |
|||
|
| |||
Microsoft Excel 2007 Exam 77-602 Topic: 4. Presenting Data Visually
4.1.2. Select appropriate chart types to represent data sources: Create a chart that shows part of a range