ug out Heferences Review 12 A he LICH W View To A. O Page we A Bee Bedroom BB TOTALS . . 10 15 Fryser Dhan TOTALE $110.000 14000 141 14 11240000 100011 100 100 000 20.00 H100011 101 344448.000 12.00 12.00 13 14 ts 18 QUESTION 1 (25 POINTS) A Open the worksheet Charts Template 8. Using the data shown on the worksheet, create the following chart a Create a stacked column chart as iustrated below. Each column represents home sales by number of bedrooms. Each segment of the column is a salesperson's sales 16 Points) b. Entitle the chart Sales by Bedrooms and Salesperson (1 Point c. Format the title Rockwell, 20 Point Bold, Blue Gradient Text Fa, Dark Variations (2 Points) d. Format the Y-axis so that the major gridine increments in units of $5.000.000 12 Points) Format the Y-axis so the maximum value is $50,000,000 (3 Points) f. Format the Y-axis so that it displays units in millions as shown in the solution chart below 12 Points) Fill Chart Area Light Gray with Major Horizontal Grdines Black 2 Point) h. Label the Y-adis ttle Sales in Millions 10 Point, Arial, Boid, Black (1 Point) Label the X-as te Bedrooms, 10 Point, Arial, Bold, Black (2 points) Place the legend at the top of the chart 11 Point) k Create a solid Blue border around the chart (1 Point Filcolor the column segment denoting Davidson Yellow (2 points) 20 24 Charter ug out Heferences Review 12 A he LICH W View To A. O Page we A Bee Bedroom BB TOTALS . . 10 15 Fryser Dhan TOTALE $110.000 14000 141 14 11240000 100011 100 100 000 20.00 H100011 101 344448.000 12.00 12.00 13 14 ts 18 QUESTION 1 (25 POINTS) A Open the worksheet Charts Template 8. Using the data shown on the worksheet, create the following chart a Create a stacked column chart as iustrated below. Each column represents home sales by number of bedrooms. Each segment of the column is a salesperson's sales 16 Points) b. Entitle the chart Sales by Bedrooms and Salesperson (1 Point c. Format the title Rockwell, 20 Point Bold, Blue Gradient Text Fa, Dark Variations (2 Points) d. Format the Y-axis so that the major gridine increments in units of $5.000.000 12 Points) Format the Y-axis so the maximum value is $50,000,000 (3 Points) f. Format the Y-axis so that it displays units in millions as shown in the solution chart below 12 Points) Fill Chart Area Light Gray with Major Horizontal Grdines Black 2 Point) h. Label the Y-adis ttle Sales in Millions 10 Point, Arial, Boid, Black (1 Point) Label the X-as te Bedrooms, 10 Point, Arial, Bold, Black (2 points) Place the legend at the top of the chart 11 Point) k Create a solid Blue border around the chart (1 Point Filcolor the column segment denoting Davidson Yellow (2 points) 20 24 Charter