Excel: Work Smarter Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Calculate the Bonus

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