Instructions, SC EX16 3b - Word Kevin Tran Insert Design Layout References Mai lings Review View Help Tell me ux, xA.ABody Copy Font Paragraph Styles Roz wants to calculate her gross monthly sales commissions. The rule is that mmission on the total sales amount every month, and she 14. she gets a 27% co receives 3.5% if her sales exceeded $80,000 in a given month. In cell 831, create a formula using the IF function to check whether the value of cell B10 is greater than 80000 a. If this condition is true, the function should multiply cell B10 by 3.5% to determine Roz's commission. (Hint: For the if true value, use B10*.035.) If this condition is false, the function should multiply the value in cell B10 by 2.7%, to determine Roz' B10*.027.) b. s commission. (Hint: For the if false value, use Copy the formula in B31 to the range C31:G31. The net amount of Roz's commissions after all deductions is 85% (cell B33). 15. In cell 832, enter a formula that multiplies the value of cell B31 (gross monthly commission) by cell B33 (net commission percentage). Use a reference to cell 833 (because the net commission percentage won't change) and a relative reference to cell B31. n absolute Copy the formula in cell 832 to the range C32:G32. In the range H31:H32, update the Column Sparklines as described below: a. b. 16. Change the Sparkline type to Line. Change the sparkline style to sparkline Style Dark #4 (4th column, 5th row of the Sparkline Styles palette [Mac Hint: 7th column, 4th row]) Depending on your version of Office, the Sparkline style may appear as Black, sparkline Style Dark #4.) 17. In the range A31:A32, increase the indent of the cell contents once