Answer from Q # 5 to Q # 9

5 2 4 3 ExpT9_Excel chod can coketing Grade han utomatically added your und name to the beginning of the filename On the Direct Marketing worksheet create appropriate range names for Design Feed Cost Per Ad cell B). Total_Clicks (cell), Profit Per_Click(841) and Growt_Prol (ool 612) Edit the existing name range Design Fee to Design Fe2021 to reflect the current year Use the newly created range rames to create a formula to calculate Cross Profooll 012 and Net Profit (cell 013) Create a new worksheet named Range Names, paste the newly created rangeme information in cel A1, and resize the columns as needed for proper display 4 5 6 5 7 3 8 9 10 Mac users use the Insert menu to insert a new worksheet and paste the range names On the Direct Marketing worksheets Goal Seok to determine the optimal click rate in order to earn a $5,000 net profit Starting in cell 4 Complete the series of substitution values ranging from 2% to 6.5% increments of 50% vertically down column Enter references to the Gross Profit and Net Profit in the correct location for a one variable datatable Complete the one-variable datatable, and then format the results with Accounting Number Format with two decimal places Apply custom number formats to display Gross Prolit in cell F3 and Net Profit in cel 03 Copy the response rate substitution values from the one-variable data table, and then pasto the values starting in cell 14 Type 10000 in cell 3. Complete the series of substitution values from 10000 to 40000 5000 increments Enter the reference to net profit formula in the correct location for a two variable datatable Complete the two-variable data table and format the results with Accounting Number Format with two decimal places Apply a custom number format to make the formula reforence appear as Net Profit 4 11 3 12 4 13 7 14 3 15 1 Exp19_Excel_Choo_Cap. High West Fashions 15 Created On: 08/12/2020 5 2 4 3 ExpT9_Excel chod can coketing Grade han utomatically added your und name to the beginning of the filename On the Direct Marketing worksheet create appropriate range names for Design Feed Cost Per Ad cell B). Total_Clicks (cell), Profit Per_Click(841) and Growt_Prol (ool 612) Edit the existing name range Design Fee to Design Fe2021 to reflect the current year Use the newly created range rames to create a formula to calculate Cross Profooll 012 and Net Profit (cell 013) Create a new worksheet named Range Names, paste the newly created rangeme information in cel A1, and resize the columns as needed for proper display 4 5 6 5 7 3 8 9 10 Mac users use the Insert menu to insert a new worksheet and paste the range names On the Direct Marketing worksheets Goal Seok to determine the optimal click rate in order to earn a $5,000 net profit Starting in cell 4 Complete the series of substitution values ranging from 2% to 6.5% increments of 50% vertically down column Enter references to the Gross Profit and Net Profit in the correct location for a one variable datatable Complete the one-variable datatable, and then format the results with Accounting Number Format with two decimal places Apply custom number formats to display Gross Prolit in cell F3 and Net Profit in cel 03 Copy the response rate substitution values from the one-variable data table, and then pasto the values starting in cell 14 Type 10000 in cell 3. Complete the series of substitution values from 10000 to 40000 5000 increments Enter the reference to net profit formula in the correct location for a two variable datatable Complete the two-variable data table and format the results with Accounting Number Format with two decimal places Apply a custom number format to make the formula reforence appear as Net Profit 4 11 3 12 4 13 7 14 3 15 1 Exp19_Excel_Choo_Cap. High West Fashions 15 Created On: 08/12/2020