How would I write this formula?

5-1 AaBbCcD AaBbCcl AaBbCe BodyCopy 1BT Incorrec.. Styles abc x, x Font Paragraph In the stacked column chart (with the title Monthly Sales per Item), change the number format of the vertical axis to Accounting style with zero decimal places 1. 12. In the 3-D pie chart (titled Share of Total Sales), change the chart style to nt: 3rd column, 2nd row] of the Chart Styles -110AT y Ar i Verdana 13. using the Outside End style. 14. Roz wants to calculate her gross monthly sales commissions. The rule is that he gets a 2.7% commission on the total sales amount every month andsie In cell 831, create a formula using the IF function to check whether the value a. If this condition is true, the function should multiply cell B10 by 3.5%, to receives 3.5% if her sales exceeded $80,000 in a given month. of cell B10 is greater than 80000. 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's commission. (Hint: For the if false value, use b. B10 .027.) Copy the formula in B31 to the range C31:G31. The net amount of Ror'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 an absolute reference to cell B33 (because the net commission percentage won't change) and a relative reference to cell B3)1 Copy the formula in cell 832 to the range C32:G32. 16. In the range H31:H32, update the Column Sparklines as described below: Change the Sparkline type to Line. a. Change the sparkline style to sparkline style Dark #4 (4th column, 5th row of the Sparkline Styles palette [Mac Hint: 7th column, 4th row]). (Hint: Depending on your version of Office, the Sparkline style may appear as Black, sparkline Style Dark #4.) b. 17. In the range A31:A32, Increase the indent of the cell contents once. Roz would also like to close 2018 with a net commission totaling $30,000, using the estimate that her gross commission rate will be an average of 3.1% (cell 837) from July through December 18. Select cell 839, and then use Goal Seek to determine what value of cell 836 (Estimated July-Dec Sales Total) is necessary to set the value of cell B39 to 30000. Leave the result of the Goal Seek analysis as the new value for cell 836