In this practice session, you'll pivot the report to figure out whether each salesperson earned a 10 percent or 7 percent bonus (the practice figures are a bit different from the lesson, just to change things a little). Then you'll figure out the bonus amount. Finally, you'll use PivotTable data in a formula outside of the report to find out the total bonus amount for one of the salespersons.
About the practice session
When you click Practice in Excel, a practice worksheet will download to your computer and open in Excel, and a separate window with practice instructions will appear alongside (see picture).
Note You need to have Excel 2003 installed on your computer.
Tips
- If the practice instructions aren't visible, or if they disappear when you click in Excel, click the Excel Help taskbar button and then click the Auto Tile button in the upper-left corner of the instructions.
- If the practice instructions cover up Excel, click the Auto Tile button in the upper-left corner of the instructions.
Before you begin
Make sure to close Excel if it is already running.
Start the practice
Click the Practice in Excel button now.
