Help for Charly

Thank you for helping fix this one again 🙂

Sept Data

85

2,000

105

101

105

162

Samuel Pickett &A &F

Week 1 Action & Adventure Animation Comedy Documentary Drama Family & Kids Foreign Horror Musicals Sci-Fi & Fantasy Weekly totals 1500 345 2000 101 2105 562 105 93 162 658 7631 Week 2 Action & Adventure Animation Comedy Documentary Drama Family & Kids Foreign Horror Musicals Sci-Fi & Fantasy Weekly totals 1625 421 2015 85 2000 461 125 105 143 745 7725 Week 3 Action & Adventure Animation Comedy Documentary Drama Family & Kids Foreign Horror Musicals Sci-Fi & Fantasy Weekly totals 1600 400 1975 116 1916 532 101 100 181 723 7644 Week 4 Action & Adventure Animation Comedy Documentary Drama Family & Kids Foreign Horror Musicals Sci-Fi & Fantasy Weekly totals 1585 367 1800 92 1945 488 132 115 162 699 7385 Category Totals Action & Adventure Animation Comedy Documentary Drama Family & Kids Foreign Horror Musicals Sci-Fi & Fantasy Weekly totals 6310 1533 7790 394 7966 2043 463 413 648 2825 30385

Office 2010 – myitlab:grader – Instructions Exploring Series! Excel Ch. 03 – EOC Project

Weekly Movie Rentals

Project Description:
You are an assistant manager at Premiere Movie Source, an online company that enables customers to download movies for a fee. You are required to track movie download sales by genre. You gathered the data for May 2012 and organized it in an Excel workbook. You are ready to create charts to help represent the data so that you can make a presentation to your manager later this week.

Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step Instructions Points Possible
1 Start Excel. Download and open the file named Exploring_e03_Grader_EOC.xlsx. 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
3 Add the chart title Sept 2012 by Genre above the chart and add the rotated value axis title Number of Downloads. 10
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
5 Format the horizontal axis labels with 12 point size. 3
6 Display major and minor horizontal gridlines. 6
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
8 Add a linear trendline to the Drama data series. 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
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
11 Change the chart type to a stacked bar chart. Add the chart title Sept 2012 Total by Genre above the chart. 7
12 Apply the Style 31 chart style to the bar chart. Apply the Layout 3 layout style to the chart. 6
13 Display the value axis in units of thousands. Display the category axis names in reverse order using the Format Axis dialog box. 8
14 Set the scaling option to print the Sept Data worksheet to only one page. Display Print Preview. 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
Total Points 100

Updated on: 6/4/2010 1 E_CH03_EXPV1_EOC _Instructions x