Details of this Paper

Steps:)

Description

solution


Question

Obtained Points;Total Score;100.00;85.00;1;Start Excel. Download and open the file named Exploring_e03_Grader_EOC.xlsx.;0;0;2;In 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.0;12.0;3;Add the chart title Sept 2012 by Genre above the chart and add the rotated value axis title Number of Downloads.;10.0;10.0;4;Move 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.0;6.0;5;Format the horizontal axis labels with 12 point size.;3;3;6;Display major and minor horizontal gridlines.;6.0;6.0;7;Add 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.0;6.0;8;Add a linear trendline to the Drama data series.;6;6;9;In 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.0;13.0;10;Create 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.00;12.00;11;Change the chart type to a stacked bar chart. Add the chart title Sept 2012 Total by Genre above the chart.;7.0;5.0;12;Apply the Style 31 chart style to the bar chart. Apply the Layout 3 layout style to the chart.;6.0;3.0;13;Display the value axis in units of thousands. Display the category axis names in reverse order using the Format Axis dialog box.;8.0;0.0;14;Set the scaling option to print the Sept Data worksheet to only one page. Display Print Preview.;3;3;15;Ensure 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.;0;0

 

Paper#72679 | Written in 18-Jul-2015

Price : $22
SiteLock