Shelly Cashman Excel 2013  Chapter 1: SAM Project 1a Flex Cab Company MODIFY A SERVICE REPORT AND CREATE A CHART 1

Subject:MS ExcelPrice:19.87 Bought3

Share With

Shelly Cashman Excel 2013  Chapter 1: SAM Project 1a

Flex Cab Company

MODIFY A SERVICE REPORT AND CREATE A CHART

1. 

Open the Pickup Analysis worksheet and use AutoFit to adjust the width

of Column A.

2. 

In cell A1, enter the text Flex Cab Company and then merge cells A1:E1

and center their content.

3. 

Apply the Heading 1 cell style to the merged cell A1:E1 and then change

the font to Verdana.

4. 

Enter the text Number of Pickups in cell A2 and merge and center the

contents of cell A2:E2.

5. 

Bold the content of merged cell A2:E2, change the font size to 12 pt., and

change the font color to Gold, Accent 4, Darker 50% (8th column, 6th row

in the Theme Colors Section of the Font Color Palette).

6. 

Clear the contents of cell F3.

7. 

Apply the Accent4 cell style to the range A3:E3.

8. 

Enter the data shown in Table 1 into the range B8:E8.

9. 

In cell B9, create a formula that uses the SUM function to calculate the

total of the range B4:B8.

10. 

Using the fill handle, fill cells C9:E9 with the formula from cell B9.

11. 

Bold the text in the merged cell A12:E12.

12. 

Apply the Accent4 cell style to the range A13:E13.

13. 

Change the tab color of the Pickup Analysis worksheet to Standard

Orange (3rd column, 1st row in the Standard Colors section of the Tab

14. 

Select the 3-D pie chart with the title On-Time Pickup Percentages in 2015

and move it to its own chart sheet. Use 2015 On-Time Percentages as the

name for the new chart sheet. Change the chart style of the 3-D pie chart

to Style 6.

15. 

Switch back to the Pickup Analysis worksheet. Create a 3-D pie chart

based on the range A13:B18 and then do the following:

a. Change the title of this chart to On-Time Pickup Percentages in 2012.

b. Move the 3-D pie chart you just created to its own chart sheet. Use

2012 On-Time Percentages as the name for the new chart sheet.

c. Change the chart style of the 3-D pie chart you just created to Style 6.