Chapter 3 Running Case Portfolio

Step

Instructions

Points Possible

1

Open e03r1NCCTS and save it as e03r1NCCTS_LastFirst

0

2

Create a pie chart using the range G4:H14 on the Summary Stats worksheet

5

3

Move the chart as an object in the Summary Charts worksheet. Move the chart so that it starts in cell A3. Set a 5.9" height and 8" width

6

4

Apply the Style 6 chart style

3

5

Change the chart title to Total Days Open by Service Type and apply Black, Text 1 font color

4

6

Filter out VoIP Service, Security Camera Maintenance, and Other.

6

7

Remove the legend, apply the Percentage and Category Name data labels, and position the data labels on the Outside End

10

8

Add Alt Text The pie chart displays each service type as a percentage of all service types, excluding VoIP Service, Security Camera Maintenance, and Other. (including the period).

3

9

Create a bar chart using the ranges A4:A21 and D4:D21 on the Summary Stats worksheet

4

10

Move the chart as an object in the Summary Charts worksheet. Move the chart so that it starts in cell N3. Set a 5.9" height and 7.3" width

4

11

Apply the Style 6 chart style.

3

12

Change the chart title to Total Amount Billed by Customer and apply Black, Text 1 font color

4

13

Select The Trophy Factory data point and format it with Dark Blue fill color to stand out

4

14

Format the value axis with zero decimal places

4

15

Add Alt Text The bar chart displays the amount billed to each customer for March. (including the period)

3

16

Create a Clustered Combo chart using the ranges G4:H14 and J4:J14 on the Summary Stats worksheet with Total Days Open as a Clustered Column chart on the Primary Axis, and Total Amount Billed as Line Chart on the Secondary Axis

10

17

Move the chart to a chart sheet named Billings vs. Days Open

4

18

Change the chart title to Days Open vs Amount Billed by Service Type

3

19

Apply the Style 5 Chart Style

3

20

Format the secondary value axis with zero decimal places

5

21

Add a Vertical Primary Value Axis Title “Days Open.”

5

22

Add Alt Text The combo chart displays the number of days open in columns and the amount billed by service type as a line. (including the period)

3

23

Insert a footer with your name on the left side, the sheet name in the center, and the file name code on the right side of Summary Charts and Billings vs Days Open worksheets. Return to Normal view.

4

24

Save and close the workbook. Based on your instructor’s directions, submit e03r1NCCTS_LastFirst.

0

Total Points

100