Using Spreadsheets to Solve Problems EXERCISE 1.3-4 FUNCTIONS: CHAPTER REVIEW A B D E F G 1 ZAP Vacuum Company - Monthly Compensation Commission 2 Rate 10% % Change Mar Total April April April Total April from last % of April 3 Salesman Compensation Salaries Sales Commissions Compensation Month Sales 4 Arnold $ 1,400 5 500 $ 10,000 $ 1,000 $ 1,500 7% 23% 5 Potsie S 3,000 $ 500S 5,000 $ 500 $ 1,000 11% 6 Howard $ 2.780$ 500 $ 25,000 $ 2.500 5 3,000 8% 56% 7 Ron $ 1,925 $ 500 $ 250 $ 25 $ 525 -73% 1% 8 Lavem $ 500 5 500 5 3.000 $ 300 $ 800 60% 9 Shirley $ 1.000 $ 500S 1,000 $ 100 $ 600 40% 2% 10 11 Total $ 10.6055 3,000 $ 44,250 $ 4,425$ 7,425 12 Minimum $ 500 $ 500 $ 250 $ 25$ 525 13 Maximum $ 3,000 $ 500S 25,000 $ 2.500 5 3,000 14 Average S 1.768 500 $ 7,375$ 738 1,238 You are the manager of a sales force for the ZAP Vacuum Company. Each month you prepare a report totaling the compensation for each salesman and comparing it to the previous month's compensation. The spreadsheet you will fill out for this report is above and includes the following information about salesman salaries and commissions: Each salesman earns a monthly salary plus a commission for their sales in that month. The rate of commission can be found in cell B2, which has been named "comm". You may assume that the cells shaded gray are inputs provided for you. Answer the following questions to fill in the rest of the worksheet, using cell references wherever possible. 1. Write a formula in cell E4 to calculate the value of Arnold's commission for April. Use the named range "comm" when writing your formula. The formula must work when copied down the column to row 9. 2. Write a formula in cell F4, which can be copied down, to calculate the total compensation received by Arnold in April. 3. Write a formula to be put in cell B11, which can be copied across the row, to calculate the total compensation that was paid in March