Steps :)

profileMrsCook
Obtained Points
1Start Excel. Download and open the file named Exploring_e03_Grader_EOC.xlsx.00
2In the chart, remove the Category Totals from the legend, and adjust the data range to exclude the weekly and category totals. Change the row and column orientation so that the weeks appear in the category axis, and the genres appear in the legend.12.012.0
3Add the chart title Sept 2012 by Genre above the chart and add the rotated value axis title Number of Downloads.10.010.0
4Move the legend to the top of the chart and then drag the bottom of the chart so that the bottom edge aligns with the bottom of row 40.6.06.0
5Format the horizontal axis labels with 12 point size.33
6Display major and minor horizontal gridlines.6.06.0
7Add data labels in the Outside End position of the Drama data series. Add a Yellow fill color (under Standard Colors) to the data labels.6.06.0
8Add a linear trendline to the Drama data series.66
9In cell G5, insert a line sparkline for the weekly data for Action & Adventure (B5:E5). Do not include the category total. Copy the sparkline down to the range G6:G15. Format the sparklines by applying Sparkline Style Dark #6, display the high point, and format the high point marker color as Red (under Standard Colors).15.013.0
10Create a clustered bar chart on the worksheet using the genre name and weekly totals (A4:E14). Move the chart to its own sheet and name the sheet Bar Chart.12.0012.00
11Change the chart type to a stacked bar chart. Add the chart title Sept 2012 Total by Genre above the chart.7.05.0
12Apply the Style 31 chart style to the bar chart. Apply the Layout 3 layout style to the chart.6.03.0
13Display the value axis in units of thousands. Display the category axis names in reverse order using the Format Axis dialog box.8.00.0
14Set the scaling option to print the Sept Data worksheet to only one page. Display Print Preview.33
15Ensure that the worksheets are correctly named and placed in the following order in the workbook: Bar Chart, Sept Data. Save and close the workbook, and submit based on your instructor's directions.00
Total Score100.0085.00
    • 11 years ago
    • 3
    Answer(0)
    Bids(0)