+
Exploring ­ Excel Chapter 3: Homework Project 1 Premiere Movie Source

Exploring ­ Excel Chapter 3: Homework Project 1 Premiere Movie Source

Rating:
Rating
(0)
Author: matthew stock
Description:

http://homework.plus/exploring-excel-chapter-3-homework-project-1-premiere-movie-source/

Premiere Movie Source
 
Project Description:
You are an assistant manager at Premiere Movie Source, an online company that enables customers to download movies for a fee. You need to track movie download sales by genre. You gathered the data for November 2016 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. Open the downloaded Excel file namedexploring_e03_grader_h1.xlsx.

0

2

Set chart filters to remove the Category Totals and the Weekly Totals.

6

3

Position and size the chart to fill the range A18:K37.

6

4

Change the row and column orientation so that the weeks appear in the category axis and the genres appear in the legend.

5

5

Add a value axis title and type Number of Downloads. Apply Black, Text 1 font color to the value axis title.

6

6

Move the legend to the right side of the chart and drag the bottom of the chart area down to cover row 37, if necessary.

5

7

Select the Drama data series and add data labels in the Outside End position. Add a default Gradient fill to the data labels.

6

8

Click cell G5 and insert Line Sparklines for the weekly data for each category and the weekly totals, but do not include the category totals for the data range. The location range should be G5:G15.

8


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial