I am unsure on how to solve steps 6-16 on this microsoft excel assignment
File Home out Insert Page Layout Calberi BTW - Formulas AA - -A == Copy Format Painter Wap Wet Merge & Center - Custom S - % E 23 Insert Delete Format Conditional Format Formatting - - Cell Styles C D M N OR Direct Marketing Net Profit 3 Inputs 4 Numbero 5 Click Rate 2.00% 10000 5.00% 20 7. 1.00 2.5 7 Parameters 8 Design Fe $ 2,000.00 9 Cost Per AS 2.25 10 Total Click 500 11 Profit Per $ 12.50 12 Gross Pro $ 6,250.00 1 Net Profit $ 3,125.00 3.50X 4.00% 4.50X 5.00K Gross Profit Net Profit $7,666 $4,286 $9,582 $5,857 $11.49 $7,429 $13,415 $9,000 $15,331 $10,571 $17,247 $12,143 $19,164 $13,714 $21.000 $15,286 $22.997 $16,857 $24.913 $18,429 10000 $50 $563 $1,075 $1.588 $2,100 $2.613 $3,125 $3,638 54,150 $4,663 15000 $1,075 $1,844 $2,613 $1,381 $4,150 1919 $5,688 $6,456 $7.225 57.94 20000 $2,100 $8,125 S4,150 $5,175 $6,200 $7.25 $250 $9,275 $10,100 $11,525 2000 $3,125 94406 $5,688 $6.969 $250 9 ,531 $10,813 $12,01 $13,375 $14,656 30000 $4,150 $5,688 $7.225 $8.763 $10,300 $11,838 $13,375 $14,913 $16,450 $17,98 3000 $8,175 $6,969 $8,763 $10.556 $12,350 $14,144 $15,938 $17,731 $19,525 $21,319 40000 $6,200 $8,250 $10,300 $12.350 $14,400 $16,450 $18.500 $20,550 $22,600 524,650 4.50% 5.00 6.00% 6.50 6.00% 6.5096 Owed Marting Direct Marketing 2 raragraph Format with no decimal places Apply custom number formats to display Gross Profit in cell F3 and Net Profit in cell 63. Copy the response rate substitution values from the one-variable datatable, and then paste the values starting in cell 14 Type 10000 in cell 3. Complete the series of substitution values from 10000 to 40000 at 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 no decimal places. Apply a custom number format to make the formula reference appear as Net Profit Create a footer on all worksheets with your name on the left side, the sheet name code in the center, and the file name code on the right side 15 Project 1 Data Analysis Created On 11/062019 Points Possible Step x Et Excel Submit the file as 17 S ave and close Exp 19 Excel Cho6_CAP directed Total Points Home Insert Page Layout Formulas Data Review View Help BIU - - -A- Merge Center e Conditional Format Formatting - Table Cel Styles 1 X Direct Marketing D E Direct Marketing C F G H I MNO Inputs 4 Number of Ads 5 click Rate 10000 5.00 $ $ 2,000.00 2.25 7 Parameters 8 Design Fee 9 Cost Per Ad 10 Total Clicks 11 Profit Per Click 12 Gross Profit Netec 500 $ 12.50 Direct Marketingowe Mang2 Type here to search File Home out Insert Page Layout Calberi BTW - Formulas AA - -A == Copy Format Painter Wap Wet Merge & Center - Custom S - % E 23 Insert Delete Format Conditional Format Formatting - - Cell Styles C D M N OR Direct Marketing Net Profit 3 Inputs 4 Numbero 5 Click Rate 2.00% 10000 5.00% 20 7. 1.00 2.5 7 Parameters 8 Design Fe $ 2,000.00 9 Cost Per AS 2.25 10 Total Click 500 11 Profit Per $ 12.50 12 Gross Pro $ 6,250.00 1 Net Profit $ 3,125.00 3.50X 4.00% 4.50X 5.00K Gross Profit Net Profit $7,666 $4,286 $9,582 $5,857 $11.49 $7,429 $13,415 $9,000 $15,331 $10,571 $17,247 $12,143 $19,164 $13,714 $21.000 $15,286 $22.997 $16,857 $24.913 $18,429 10000 $50 $563 $1,075 $1.588 $2,100 $2.613 $3,125 $3,638 54,150 $4,663 15000 $1,075 $1,844 $2,613 $1,381 $4,150 1919 $5,688 $6,456 $7.225 57.94 20000 $2,100 $8,125 S4,150 $5,175 $6,200 $7.25 $250 $9,275 $10,100 $11,525 2000 $3,125 94406 $5,688 $6.969 $250 9 ,531 $10,813 $12,01 $13,375 $14,656 30000 $4,150 $5,688 $7.225 $8.763 $10,300 $11,838 $13,375 $14,913 $16,450 $17,98 3000 $8,175 $6,969 $8,763 $10.556 $12,350 $14,144 $15,938 $17,731 $19,525 $21,319 40000 $6,200 $8,250 $10,300 $12.350 $14,400 $16,450 $18.500 $20,550 $22,600 524,650 4.50% 5.00 6.00% 6.50 6.00% 6.5096 Owed Marting Direct Marketing 2 raragraph Format with no decimal places Apply custom number formats to display Gross Profit in cell F3 and Net Profit in cell 63. Copy the response rate substitution values from the one-variable datatable, and then paste the values starting in cell 14 Type 10000 in cell 3. Complete the series of substitution values from 10000 to 40000 at 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 no decimal places. Apply a custom number format to make the formula reference appear as Net Profit Create a footer on all worksheets with your name on the left side, the sheet name code in the center, and the file name code on the right side 15 Project 1 Data Analysis Created On 11/062019 Points Possible Step x Et Excel Submit the file as 17 S ave and close Exp 19 Excel Cho6_CAP directed Total Points Home Insert Page Layout Formulas Data Review View Help BIU - - -A- Merge Center e Conditional Format Formatting - Table Cel Styles 1 X Direct Marketing D E Direct Marketing C F G H I MNO Inputs 4 Number of Ads 5 click Rate 10000 5.00 $ $ 2,000.00 2.25 7 Parameters 8 Design Fee 9 Cost Per Ad 10 Total Clicks 11 Profit Per Click 12 Gross Profit Netec 500 $ 12.50 Direct Marketingowe Mang2 Type here to search
