Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Could use some help on the non-crossed out Excel steps. Thanks for your time, i'll upvote. 3 Pane Steps to Perform: Step Instructions Points Possible

Could use some help on the non-crossed out Excel steps. Thanks for your time, i'll upvote.

image text in transcribed

image text in transcribed

3 Pane Steps to Perform: Step Instructions Points Possible 0 Start Excel. Download and open the file named Exp19 Excel Ch06_Cap Direct Marketing xlsx Grader has automatically added your last Aame to the beginning of the filename. on 2 On the Direct Marketing worksheet, create appropriate range names for Design Fee (call B8) Cost.Pet. Ad (cell 39). Tatal.Clicks.(cell B10). Profit. Per. Slick (B11), and G1966. Profit feel B127. ) Edit the existing name range Design Fee te Design Fee2021 te reflect the current rear Use the newly created range names to create a formula to calculate Grote Profit (cell B12) and Alet Profit feell B13 4 6 4 vo 5 Create a new worksheet named Range Names, paste the newly created range name information in cell A1, and resize the columns as needed for proper display. AN Mac users, use the Insert menu to insert a new worksheet and paste the range names. I on the Direct Marketing worksheet, use Goal Seek to determine the optimal click rate in order to sam a $5,000 net profit 6 6 7 5 Starting in cell E4. Complete the series of substitution values ranging from 2% to 6.5% at increments of 50% vertically down column E Enter references to the Gross Profit and Net Profit in the correct location for a one-variable data table aulu 8 3 9 6 Complete the one-variable data table, and then format the results with Accounting Number Format with two decimal places. 10 Apply custom number formats to display Gross Profit in coll F3 and Net Profit in cell G3. 4 11 4 Copy the response rate substitution values from the one-variable data table, and then paste the values starting in cell 14. 12 Type 10000 in cell 13. Complete the series of substitution values from 10000 to 40000 at 5000 increments 3 13 Enter the reference to net profit formula in the correct location for a two-variable data table. 4 14 7 Complete the two-variable data table and format the results with Accounting Number Format with two decimal places 15 Apply a custom number format to make the formula reference appear as Net Profit 3 Created On: 08/12/2020 Exp19_Excel Ch06 Cap - High West Fashions 1,5 Krause_Exp19_Excel_Ch06_Cap Direct Marketing Home Insert Page Layout Formulas Data View Review Connections Properties 2t Az ? Pe Clear A+ Filter Advanced Sort Group Ungroup Subtotal From New Database Text Query From HTML Refresh All Text to Flash Columns FRI What I Analysis Remove Data Consolidate Duplicates Validation Edit Links F4 N M P Q K 0 PC 1 B D E F G 1 H Direct Marketing 1 30000 40000 20000 35000 Net Profit 1000 15000 25000 Gross Profit 10000 2.40% 2.00% 2.50% 3.00% 3.50X 2.00% 2.50% 3.00% 2 3 Inputs 4 Number of Ads 5 Click Rate 6 7 Parameters 8 Design Fee 9 Cost Per Ad 10 Total Clicks 11 Profit Per Click 12 Gross Profit 13 Net Profit 14 15 16 17 18 $ 2,000.00 S 2.25 240 $ 12.50 $ 3,000.00 $ 5,000.00 4,00% 4.50% 5.00% 5.50% 6.00% % 6.50% 3.50% 4 OON 4 50N 5.00 5.50% 6.00% 6.50% e 19 20 21 22 2 23 24 clit 25 26 27 28 29 30 31 32 unt 33 34 35 36 27 A 38 39 40 42 43 able 44 45 Nu 46 47 et P 48 SO 51 52 Range Names Direct Marketing + Direct Marketing 2 Ready 3 Pane Steps to Perform: Step Instructions Points Possible 0 Start Excel. Download and open the file named Exp19 Excel Ch06_Cap Direct Marketing xlsx Grader has automatically added your last Aame to the beginning of the filename. on 2 On the Direct Marketing worksheet, create appropriate range names for Design Fee (call B8) Cost.Pet. Ad (cell 39). Tatal.Clicks.(cell B10). Profit. Per. Slick (B11), and G1966. Profit feel B127. ) Edit the existing name range Design Fee te Design Fee2021 te reflect the current rear Use the newly created range names to create a formula to calculate Grote Profit (cell B12) and Alet Profit feell B13 4 6 4 vo 5 Create a new worksheet named Range Names, paste the newly created range name information in cell A1, and resize the columns as needed for proper display. AN Mac users, use the Insert menu to insert a new worksheet and paste the range names. I on the Direct Marketing worksheet, use Goal Seek to determine the optimal click rate in order to sam a $5,000 net profit 6 6 7 5 Starting in cell E4. Complete the series of substitution values ranging from 2% to 6.5% at increments of 50% vertically down column E Enter references to the Gross Profit and Net Profit in the correct location for a one-variable data table aulu 8 3 9 6 Complete the one-variable data table, and then format the results with Accounting Number Format with two decimal places. 10 Apply custom number formats to display Gross Profit in coll F3 and Net Profit in cell G3. 4 11 4 Copy the response rate substitution values from the one-variable data table, and then paste the values starting in cell 14. 12 Type 10000 in cell 13. Complete the series of substitution values from 10000 to 40000 at 5000 increments 3 13 Enter the reference to net profit formula in the correct location for a two-variable data table. 4 14 7 Complete the two-variable data table and format the results with Accounting Number Format with two decimal places 15 Apply a custom number format to make the formula reference appear as Net Profit 3 Created On: 08/12/2020 Exp19_Excel Ch06 Cap - High West Fashions 1,5 Krause_Exp19_Excel_Ch06_Cap Direct Marketing Home Insert Page Layout Formulas Data View Review Connections Properties 2t Az ? Pe Clear A+ Filter Advanced Sort Group Ungroup Subtotal From New Database Text Query From HTML Refresh All Text to Flash Columns FRI What I Analysis Remove Data Consolidate Duplicates Validation Edit Links F4 N M P Q K 0 PC 1 B D E F G 1 H Direct Marketing 1 30000 40000 20000 35000 Net Profit 1000 15000 25000 Gross Profit 10000 2.40% 2.00% 2.50% 3.00% 3.50X 2.00% 2.50% 3.00% 2 3 Inputs 4 Number of Ads 5 Click Rate 6 7 Parameters 8 Design Fee 9 Cost Per Ad 10 Total Clicks 11 Profit Per Click 12 Gross Profit 13 Net Profit 14 15 16 17 18 $ 2,000.00 S 2.25 240 $ 12.50 $ 3,000.00 $ 5,000.00 4,00% 4.50% 5.00% 5.50% 6.00% % 6.50% 3.50% 4 OON 4 50N 5.00 5.50% 6.00% 6.50% e 19 20 21 22 2 23 24 clit 25 26 27 28 29 30 31 32 unt 33 34 35 36 27 A 38 39 40 42 43 able 44 45 Nu 46 47 et P 48 SO 51 52 Range Names Direct Marketing + Direct Marketing 2 Ready

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing and Assurance Services A Systematic Approach

Authors: William Messier, Steven Glover, Douglas Prawitt

9th edition

1308361491, 77862333, 978-1259248290, 9780077862336, 1259162346, 978-1259162343

More Books

Students also viewed these Accounting questions

Question

9. Why do many firms strive to maintain stable prices? LO26.5

Answered: 1 week ago