Brenau University Sales Commission Worksheet Follow the directions for Project EX-3 (page 410) in your textbook. Submit your finished spreadsheet. 410 Proj

Brenau University Sales Commission Worksheet Follow the directions for Project EX-3 (page 410) in your textbook. Submit your finished spreadsheet. 410 Projects Spreadsheet Projects
Project EX-3: Using Absolute and Relative References
In this project, you’ll apply what you’ve learned about absolute and relative references to
complete a sales commission worksheet.
Requirements: This project requires Microsoft Excel.
Project file: Pr EX-3.xlsx
1. Copy the file PrjEX-3.xlsx to your Project folder using the Copy It! button on this page
COPYIT!
in the Practical Computer Literacy digital book.
2. Start Microsoft Excel.
3. Open the file PrjEX-3.xlsx from your Project folder.
4. Notice that cell B2 contains a sales commission rate. Each salesperson receives
a commission equal to his or her total sales multiplied by the commission rate. The
commission rate changes periodically. The worksheet is set up so that if the sales
manager changes the rate in cell B2, all the sales commissions will be recalculated.
5. Create a formula in cell B10 to calculate the sales commission for column B by
multiplying the Total Sales in cell B9 by the Commission Rate in cell B2. (Hint: You must
use an absolute reference for the Commission Rate in the formula.)
6. Copy the formula from cell B10 to cells C10 through E10.
7. Check the results of the copied formulas to make sure that they are correct. If cells C10
through E10 contain zeros, you did not use the correct absolute reference for the formula
that you entered in Step 5. If necessary, modify the formula in cell B10, then recopy it to
cells C10 through E10.
8. Compare your worksheet to the one shown in the figure on the next page, but don’t
save it until you complete Steps 9 and 10.
Projects EX-3
411
• Using Absolute and Relative References (continued)
QH6
FILE
HOME
INSERT
PEX 3
REVIEW
7
PAGE LAYOUT
FORMULAS DATA
VIEW
Anal
General
2
BTW
Conditionem
Famostat
• Cell Styles
net
Delete
Format
– 96
33
Sort & Find &
Select
pboard
→
Font
Alignment
017
C
2 Commission Rate:
Commission Worksheet
0.02
3
4 Salesperson
$ Week 1
Renfrew, Steven Anderson, Jane Cole, Michael James, Ron
Week 2
$ 14,283.00 $ 11,020.00 $ 13,477.00 $ 12,405.00
Week 3
$ 17,808.00 $ 12,381.00 $ 1,100.00 $ 12,889.00
8 Week 4
$ 12,302.00 $ 14,830.00 $ 13,747.00 $ 14,700.00
s Total Sales
$ 13,100.00 $ 19,787.00 $ 18,483.00 $ 15,806.00
$ 57,493.00 $ 58,018.00 $ 46,807.00 $
55,800.00
10 Sales Commission
$ 1,149.86 $ 1,160.36 $ 936.14 $
1,116.00
1+ Base Salary
$ 500.00 $ 501.00 $ 502.00 $ 503.00
12 Salary Plus Commission $ 1,649.86 $ 1,661.36 $ 1,438.14 $
1,619.00
13
15
18
19
20
Sheet1
1005
READY
TO 419 PM
x
9. Change the contents of cell B2 to 0.03.
10. Enter your name in cell B4.
11. Save your worksheet in your Project folder using the file name PrjEX-3 [Your Name).
12. Submit the project file as an e-mail attachment, as a printout, on a USB flash drive, or
in any other format specified by your instructor.

Purchase answer to see full
attachment