Answered step by step
Verified Expert Solution
Question
1 Approved Answer
how do i load an excel file? 1. Switch to the Earphones worksheet. Create a Scatter with Straight Lines chart based on range D6:114 in
how do i load an excel file?
1. Switch to the Earphones worksheet. Create a Scatter with Straight Lines chart based on range D6:114 in the data table Personalized Earphones - Net Income Analysis. Modify the new chart as follows: a. Resize and reposition the chart so that it covers the range D15:132. b. Remove the chart title from the chart. C. Reposition the chart legend to the Right of the chart. Add Net Income as the vertical axis title and Units Sold as the horizontal axis title. Change the colors of the chart to Color 5 (1st row in the Monochromatic palette). (Hint: Depending on your version of Office, the name of the color may be different.) Hurdy Headphones - Personalized Earphones Sales 4 5 6 Units Sold Price Per Unit Total Sales 12.500 99.00 1.237.500.00 Units Sold $ $ 8 Expenser 9 Variable Expenses 10 Units Manufactured 11 Variable Cost per Unit 12 Total Variable Costs 13 Fixed Costs 14 Total Fixed Cost 15 Expenses. Total 16 Total Experne Per Unit Sold Personalized Earphones - Net Income Analysis Average Prke per Unit 79.00 $ 89.00 $ 99.00 $ 109.00 155,250) 49.750 154,750 259,750 (45,500) 64,500 174,500 284,500 (35.750) 79.250 194.250 309,250 126.0001 94,000 214.000 334.000 (16,250) 108.750 233.750 358,750 16.5001 123.500 253.500 383.500 3,250 138,250 273,250 408.250 13,000 153,000 293,000 433,000 22.750 167,790 312,750 457,750 11,000 11.500 12.000 12.500 13.000 13.500 14,000 14,500 119.00 364,750 394,500 424.250 454,000 483.750 513.500 543.250 573.000 602.750 12.500 59,50 743.750,00 $ $ S 260.000,00 1,003,750.00 80.30 18 Profit 19 Total Sales 20 Total Expenses 21 Gross Profit 1,237,500.00 1,003,750.00 233,750,00 23 Break-even Analysis 24 Price per Unit 25 Cost Per Unit 26 Units Sold 27 Gross Profit 99.00 80,30 12.500 233,750.00 Please show how to solve it in Excel 2016! 1. Switch to the Earphones worksheet. Create a Scatter with Straight Lines chart based on range D6:114 in the data table Personalized Earphones - Net Income Analysis. Modify the new chart as follows: a. Resize and reposition the chart so that it covers the range D15:132. b. Remove the chart title from the chart. C. Reposition the chart legend to the Right of the chart. Add Net Income as the vertical axis title and Units Sold as the horizontal axis title. Change the colors of the chart to Color 5 (1st row in the Monochromatic palette). (Hint: Depending on your version of Office, the name of the color may be different.) Hurdy Headphones - Personalized Earphones Sales 4 5 6 Units Sold Price Per Unit Total Sales 12.500 99.00 1.237.500.00 Units Sold $ $ 8 Expenser 9 Variable Expenses 10 Units Manufactured 11 Variable Cost per Unit 12 Total Variable Costs 13 Fixed Costs 14 Total Fixed Cost 15 Expenses. Total 16 Total Experne Per Unit Sold Personalized Earphones - Net Income Analysis Average Prke per Unit 79.00 $ 89.00 $ 99.00 $ 109.00 155,250) 49.750 154,750 259,750 (45,500) 64,500 174,500 284,500 (35.750) 79.250 194.250 309,250 126.0001 94,000 214.000 334.000 (16,250) 108.750 233.750 358,750 16.5001 123.500 253.500 383.500 3,250 138,250 273,250 408.250 13,000 153,000 293,000 433,000 22.750 167,790 312,750 457,750 11,000 11.500 12.000 12.500 13.000 13.500 14,000 14,500 119.00 364,750 394,500 424.250 454,000 483.750 513.500 543.250 573.000 602.750 12.500 59,50 743.750,00 $ $ S 260.000,00 1,003,750.00 80.30 18 Profit 19 Total Sales 20 Total Expenses 21 Gross Profit 1,237,500.00 1,003,750.00 233,750,00 23 Break-even Analysis 24 Price per Unit 25 Cost Per Unit 26 Units Sold 27 Gross Profit 99.00 80,30 12.500 233,750.00 Please show how to solve it in Excel 2016 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started