Shelly Cashman Excel 2013 Chapter 1: SAM Project 1b Blakeston University 1

Subject:MS ExcelPrice:19.87 Bought3

Share With

Shelly Cashman Excel 2013 Chapter 1: SAM Project 1b

Blakeston University

1. 

Open the Enrollment Analysis worksheet and use AutoFit to adjust the width of column A.

2. 

In cell A1, enter the text Blakeston University and then merge and center the range A1:E1.

3. 

Apply the Heading 1 Cell Style to the range A1:E1 and then change the font to Arial.

4. 

In cell A2, enter the text School of Business and then merge and center the range A2:E2.

5. 

Bold the contents of the range A2:E2 and then change the font size to 14 pt., and change

the font color to Blue-Gray, Accent 3, Darker 50% (7th column, 6th row in the Theme Colors

Section of the Font Color Palette).

6. 

Clear the contents of cell F4.

7. 

Apply the Heading 3 Cell Style to the merged range A3:E3.

8. 

Enter the data in bold shown in Table 1 below into the range B10:E10.

9. 

In cell B11, create a formula that uses the SUM function to calculate the total of the range

B5:B10.

10. 

Using the fill handle, fill the range C11:E11 with the formula from cell B11.

11. 

Bold the contents of cell A11.

12. 

Apply the Heading 3 Cell Style to the merged range A14:E14.

13. 

Change the tab color of the Enrollment Analysis worksheet to Standard Blue (8th column

from the left in the Standard Colors section of the Tab Color Palette).

14. Select the 3-D pie chart with the title Job Placement Rates in 2016 and move it to its own

chart sheet. Use Job Placement Rates in 2016 as the name for the new chart sheet. Change

the chart style of the 3-D pie chart to Style 6 (6th from the left in the top row of the Chart

Styles palette).

15. Switch back to the Enrollment Analysis worksheet. Create a 3-D Pie chart based on the data

in the range A4:B10 and then do the following:

a. Change the title of this chart to Student Enrollment in 2013.

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

Breakdown as the name for the new chart sheet.

c. Change the chart style of the 3-D pie chart to Style 6 (6th from the left in the top row of

the Chart Styles palette).