Grader project 3
Data
| Premiere Movie Source | |||||||
| November 2018 Data | |||||||
| Genre | Week 1 | Week 2 | Week 3 | Week 4 | Category Totals | % of Month | Summary |
| Action & Adventure | 1,795 | 1,625 | 1,826 | 1,902 | 7,148 | 19.4% | |
| Comedy | 1,800 | 1,923 | 2,045 | 2,100 | 7,868 | 21.3% | |
| Drama | 2,105 | 2,000 | 2,145 | 2,305 | 8,555 | 23.2% | |
| Horror | 1,206 | 1,372 | 945 | 917 | 4,440 | 12.0% | |
| Sci-Fi & Fantasy | 1,345 | 1,044 | 1,145 | 1,245 | 4,779 | 13.0% | |
| Other Genres | 1,011 | 1,123 | 948 | 989 | 4,071 | 11.0% | |
| Weekly Totals | 9,262 | 9,087 | 9,054 | 9,458 | 36,861 | 100.0% |
Grader – Instructions Excel
2
0
1
6
Project
EX
16
_XL_CH0
3
_GRADER_CAP_AS – Movie Source 1.
13
Project Description:
Steps to Perform:
|
Step |
Instructions |
Points Possible |
|||||
| 1 |
Start Excel. Download and open the file named exploring_e03_grader_a1.xlsx. |
0 | |||||
| 2 |
Select the ranges A 4 :A 10 , F4:G10 and create a Clustered Column – Line on Secondary Axis combo chart. |
10 | |||||
| 3 |
Position the chart to start in cell A13. Change the height to 3. 5 inches and the width to 6 inches. |
6 | |||||
| 4 |
Change the chart title to November 201 8 Downloads by Genre. Apply Black, Text 1 font color to the chart title. |
||||||
| 5 |
Add a primary value axis title and type Number of Downloads. Add a secondary value axis title and type Percentage of Monthly Downloads. Apply Black, Text 1 font color to both value axis titles. |
||||||
|
Remove the legend. |
|||||||
|
7 |
Add data labels for the % of Month line. Position the data labels Above. |
||||||
| 8 |
Select the range B5:E 11 . Insert Line Sparklines in the range H5:H11. |
9 |
|||||
|
Apply the Sparkline Style Accent 2, Darker 50% sparkline style. |
|||||||
|
Show the high point and markers for the sparklines. Change the high point marker color to Red. Change the low point marker to Blue. |
|||||||
| 11 |
Select the range A4:E10. Create a stacked bar chart. Move the chart to new sheet. Type Bar Chart for the sheet name. |
||||||
|
12 |
Add a chart title above the bar chart and type November 20 18 Weekly Downloads by Genre. Apply bold and Blue font color to the bar chart title. |
||||||
| 13 |
Apply 11 pt font size to the category axis, value axis, and the legend for the bar chart. |
||||||
|
14 |
Use the Axis Options to display the value axis in units of Thousands, set the Major Units to 500, apply the Number format with 1 decimal place for the bar chart. Click the vertical axis, and under Axis Options, click the Categories in reverse order check box. |
||||||
|
15 |
Change colors and apply Monochromatic Palette 8 to the bar chart (Blue gradient, light to dark). |
||||||
| 16 |
Apply a gradient fill, using any preset or color, to the plot area in the bar chart. |
||||||
|
17 |
Apply landscape orientation for the Data worksheet. |
||||||
| 18 |
Apply horizontal and vertical centering on the page options for the Data worksheet. |
||||||
|
19 |
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Bar Chart, Data. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. |
|
Total Points |
100 |
Created On: 10/11/2019 1 EX16_XL_CH03_GRADER_CAP_AS – Movie Source 1.13