I don't understand how to complete the chapter 6, e06p1Commission practice exercise 1 from the Microsoft excel 2016 textbook by the series creator Dr. Robert T. Grauer.
Practice Exercises Monthly Commission You are a sales rep for Speedway International auto sales, an w e dealership that specialises in online sales. Each month you are paid 2%. common on all sales and you pay 4. Income tax based on your current home once. You have decided to create an Excel worksheet and use one and two-variable data tables to help predict your net income due to the varianty in monthly sales and tax rate based on the sales location. You will b e Sohn to help determine the exact amount of sales required to meet your monthly income pal and create ang nanies to make your references easier to understand within your financial calculations Refer to Figure 5.42 you complete this exercise FIGURE 6.42 a. Open 06pl Commission and save it as e06p 1 Commission LastFirst. b. Select the ranges A2:14 and 18:310. Click the Formulas tab, click Create from Selection in the Defined Names group and click OK c. Click Name Manager and edit each of the newly created range names to the following then click close: Commission Rate Commission Gross Commission Gross Net Income Net . Monthly Sales Sales d. Use the named ranges created in the prior step to enter formulas in the following cells B Sales Commission 39 Gross Tax Rate B10 = Gross-Income Taxes Practice Exercises. Excel 2016 Chick cell and complete the wing sto r ies of suston vales for the Type Lck and Entertoperche the dininthe SS the Soprabow, the 1. Inter the references to come in the following cells VUUUUUUUU y dog the following Complete the near b Select the range DXGIE . Click the Data tab, click What Analysis in the wat group and then select Data Chek is the Column input cellbes.clickr 12. then click OK Select the range 161 ck the Home tab, and then select Accounting Number Format wchodermal places Crew column headings for the datatable by the following Type Sales in cell D2. . Click cell and click the Number Die Box Launcher in the Number group - Che Custome r scroll up in the type and then select General . Select General Type bort tip s and then click OK Adapt the c ustom e r format to display Taxes cell and Net Set the copying the range dating in steps of 1 Type Net in cell 12. k. Complete the two variables table by doing the bowing - Select the range 12:M13 Chick the Date tablick What Analysis in the Forec a - Click cell to enter that lence in the Row b ox Chick in the Cali put cell box dick cell and thenck OK best the range BM and apply Accounting Number or with a del Ballander data in this cell et cell 10. cik the Duta tablet Solven the th i ng paris Se Objective Net Te Valo 3200 Bly Changing Variable Cell Sales Tax Rate m. Click Add enter the constraint Tax Ilate Ock the cost Tax Rate . dick OK e. Click Save and Report Create Range Names, Chacell Al und paste a list of the range O f with your enthede. the sheet name code in the center and the VOLU Save and close the workbook. Based on your instructor's directions CHAPTER 6 Practice Practice Exercises Monthly Commission You are a sales rep for Speedway International auto sales, an w e dealership that specialises in online sales. Each month you are paid 2%. common on all sales and you pay 4. Income tax based on your current home once. You have decided to create an Excel worksheet and use one and two-variable data tables to help predict your net income due to the varianty in monthly sales and tax rate based on the sales location. You will b e Sohn to help determine the exact amount of sales required to meet your monthly income pal and create ang nanies to make your references easier to understand within your financial calculations Refer to Figure 5.42 you complete this exercise FIGURE 6.42 a. Open 06pl Commission and save it as e06p 1 Commission LastFirst. b. Select the ranges A2:14 and 18:310. Click the Formulas tab, click Create from Selection in the Defined Names group and click OK c. Click Name Manager and edit each of the newly created range names to the following then click close: Commission Rate Commission Gross Commission Gross Net Income Net . Monthly Sales Sales d. Use the named ranges created in the prior step to enter formulas in the following cells B Sales Commission 39 Gross Tax Rate B10 = Gross-Income Taxes Practice Exercises. Excel 2016 Chick cell and complete the wing sto r ies of suston vales for the Type Lck and Entertoperche the dininthe SS the Soprabow, the 1. Inter the references to come in the following cells VUUUUUUUU y dog the following Complete the near b Select the range DXGIE . Click the Data tab, click What Analysis in the wat group and then select Data Chek is the Column input cellbes.clickr 12. then click OK Select the range 161 ck the Home tab, and then select Accounting Number Format wchodermal places Crew column headings for the datatable by the following Type Sales in cell D2. . Click cell and click the Number Die Box Launcher in the Number group - Che Custome r scroll up in the type and then select General . Select General Type bort tip s and then click OK Adapt the c ustom e r format to display Taxes cell and Net Set the copying the range dating in steps of 1 Type Net in cell 12. k. Complete the two variables table by doing the bowing - Select the range 12:M13 Chick the Date tablick What Analysis in the Forec a - Click cell to enter that lence in the Row b ox Chick in the Cali put cell box dick cell and thenck OK best the range BM and apply Accounting Number or with a del Ballander data in this cell et cell 10. cik the Duta tablet Solven the th i ng paris Se Objective Net Te Valo 3200 Bly Changing Variable Cell Sales Tax Rate m. Click Add enter the constraint Tax Ilate Ock the cost Tax Rate . dick OK e. Click Save and Report Create Range Names, Chacell Al und paste a list of the range O f with your enthede. the sheet name code in the center and the VOLU Save and close the workbook. Based on your instructor's directions CHAPTER 6 Practice
