I need help with questions 9 given for Excel. SodiumQXFile5.eIF34AutoSave OffUndoSC EX19 3b JeffreyWang 2 ✓Home Insert Draw Page Layout Formulas.-XPasteSEditService Category5Market research$6 Retail merchandising $7Product promotion $8Social marketing$9Total$1011 Percentage per Month12Share13141516AmountNet Amount1718 Net Commission %192021B I UBIUService CategoryClipboard5SSUBSCRIPTION CANCELLED On Sunday, December 18, 2022, most features of Excel will✓ X✓ fx=IF(89-275000)$VBAccessibility: investigateEFont12July=IF(89=275000)V$15%JanuaryDocumentation Sales Report43%4aAugust78,672.15 $56,742.12 $July72,344.50 $52,474.35 $81,550.21 $ 88.967.74 $48,073.52 $ 55,027.26 $254,442.58 $ 279,409.27 $Α' ΑA$сAugustData Review ViewdoFebruary965==ME17%RT$DdSeptember79,884.67 $49,330.69 $88.814.48 $55,781.80 $273,811.64 $SeptemberMarch6HelpAlignmentbe disabled.16%2 Wrap TextO Search (Alt+Q)Merge & CenterMonthly Sales$&EReactivateCommissions PaidOctoberEstimated Sales717%AprilNovemberOctober75,380.26 $ 81.610.14 $58,080.67 $52,785.58 $91.815.96 $87,934.09 $62,852.10 $ 60,019.22 $278,952.03 $ 291,525.99 $144154al$Accounting8$%95898FNumberMayNovemberDH17%hp9$GINConditional Format as CellStylesFormatting TableStylesDecember83,352.6862,109.7693,009.4365,272.37303,744.2418%DecemberJune-htOHTrendTrendTotalSZÉInsert Delete Format$$Total471,244.40331,523,17$ 532,091,91347,026.27$$ 1,681,885.75Total$$CellsAvg. Clientsport scJeffrey WangHelpE-47WEProjectionsVJWdeleteSort & Find &Filter SelectEditingbackspaceK#+1828LComments(D)INAnalyzeDataAnalysisnumlockD0TemplatesMofficeatworkSM12:3810/5/2 8.9.Amir wants to determine how the sales of each month contributed to the total sales.Calculate this information for him as follows:In cell B12, insert a formula without using a function that divides the total sales forJuly (cell B9) by the total sales (cell 19).Use an absolute reference to cell 19 in the formula.Use the Fill Handle to fill the range C12:G12 with the formula in cell B12.Amir also needs to calculate the commissions paid each month. If the company earns$275,000 or more in a month, the commission is 26% of the sales. If the companyearns less than $275,000 in a month, the commission is 17% of the sales. Calculate thecommissions as follows:a.b.12.C.a.b.C.d.a.b.10. Change the sparklines in the range H16:H17 as follows to use a format similar to theMonthly Sales sparklines:In cell B16, enter a formula that uses the IF function and tests whether the totalsales for July (cell B9) is greater than or equal to 275000.a.If the condition is true, multiply the total sales for July (cell B9) by 0.26 tocalculate a commission of 26%.b.If the condition is false, multiple the total sales for July (cell B9) by 0.17 tocalculate a commission of 17%.11. Amir would like to increase the average number of clients served per month. Becauseretail merchandising has the lowest sales, Amir wants to know how many retailmerchandising clients he needs to reach the goal of 35 clients served per month.Use the Fill Handle to fill the range C16:G16 with the formula in cell B16 tocalculate the commissions for August through December.C.Use Goal Seek to set the average number of clients for all services (cell 126) to thevalue of 35 by changing the average number of retail merchandising clients (cell 123).Format the text in cell 021 to clarify what it refers to as follows:Merge and center the range 021:026.Rotate the text down in the merged cell.Change the Column sparklines to Line sparklines.Apply the sparkline style Dark Red, Sparkline Style Accent 1, Darker 50%(1st row, 1st column of the Sparkline Color theme palette) to make the sparklineseasier to see.Change the width of column 3 to 7.00.13. Delete row 32 to keep the Estimated Commissions information together.

Question

I need help with questions 9 given for Excel. SodiumQXFile5.eIF34AutoSave OffUndoSC EX19 3b JeffreyWang 2 ✓Home Insert Draw Page Layout Formulas.-XPasteSEditService Category5Market research$6 Retail merchandising $7Product promotion $8Social marketing$9Total$1011 Percentage per Month12Share13141516AmountNet Amount1718 Net Commission %192021B I UBIUService CategoryClipboard5SSUBSCRIPTION CANCELLED On Sunday, December 18, 2022, most features of Excel will✓ X✓ fx=IF(89>-275000)$VBAccessibility: investigateEFont12July=IF(89>=275000)V$15%JanuaryDocumentation Sales Report43%4aAugust78,672.15 $56,742.12 $July72,344.50 $52,474.35 $81,550.21 $ 88.967.74 $48,073.52 $ 55,027.26 $254,442.58 $ 279,409.27 $Α' ΑA$сAugustData Review ViewdoFebruary965==ME17%RT$DdSeptember79,884.67 $49,330.69 $88.814.48 $55,781.80 $273,811.64 $SeptemberMarch6HelpAlignmentbe disabled.16%2 Wrap TextO Search (Alt+Q)Merge & CenterMonthly Sales$&EReactivateCommissions PaidOctoberEstimated Sales717%AprilNovemberOctober75,380.26 $ 81.610.14 $58,080.67 $52,785.58 $91.815.96 $87,934.09 $62,852.10 $ 60,019.22 $278,952.03 $ 291,525.99 $144154al$Accounting8$%95898FNumberMayNovemberDH17%hp9$GINConditional Format as CellStylesFormatting TableStylesDecember83,352.6862,109.7693,009.4365,272.37303,744.2418%DecemberJune-htOHTrendTrendTotalSZÉInsert Delete Format$$Total471,244.40331,523,17$ 532,091,91347,026.27$$ 1,681,885.75Total$$CellsAvg. Clientsport scJeffrey WangHelpE-47WEProjectionsVJWdeleteSort & Find &Filter SelectEditingbackspaceK#+1828LComments(D)INAnalyzeDataAnalysisnumlockD0TemplatesMofficeatworkSM12:3810/5/2 8.9.Amir wants to determine how the sales of each month contributed to the total sales.Calculate this information for him as follows:In cell B12, insert a formula without using a function that divides the total sales forJuly (cell B9) by the total sales (cell 19).Use an absolute reference to cell 19 in the formula.Use the Fill Handle to fill the range C12:G12 with the formula in cell B12.Amir also needs to calculate the commissions paid each month. If the company earns$275,000 or more in a month, the commission is 26% of the sales. If the companyearns less than $275,000 in a month, the commission is 17% of the sales. Calculate thecommissions as follows:a.b.12.C.a.b.C.d.a.b.10. Change the sparklines in the range H16:H17 as follows to use a format similar to theMonthly Sales sparklines:In cell B16, enter a formula that uses the IF function and tests whether the totalsales for July (cell B9) is greater than or equal to 275000.a.If the condition is true, multiply the total sales for July (cell B9) by 0.26 tocalculate a commission of 26%.b.If the condition is false, multiple the total sales for July (cell B9) by 0.17 tocalculate a commission of 17%.11. Amir would like to increase the average number of clients served per month. Becauseretail merchandising has the lowest sales, Amir wants to know how many retailmerchandising clients he needs to reach the goal of 35 clients served per month.Use the Fill Handle to fill the range C16:G16 with the formula in cell B16 tocalculate the commissions for August through December.C.Use Goal Seek to set the average number of clients for all services (cell 126) to thevalue of 35 by changing the average number of retail merchandising clients (cell 123).Format the text in cell 021 to clarify what it refers to as follows:Merge and center the range 021:026.Rotate the text down in the merged cell.Change the Column sparklines to Line sparklines.Apply the sparkline style Dark Red, Sparkline Style Accent 1, Darker 50%(1st row, 1st column of the Sparkline Color theme palette) to make the sparklineseasier to see.Change the width of column 3 to 7.00.13. Delete row 32 to keep the Estimated Commissions information together.

Accepted Answer

Commission is the expenses to the company and which are paid to the employees or the marketers of…