Ex1 Assignment - Class Copy

ADVERTISEMENT

EX1 ASSIGN1 – CLASS COPY
Attending college can be an expensive proposition and often times your resources are limited. In order to make the
necessary financial commitment to pursuing a four-year degree you have decided to organize your anticipated
resources and expenses in a worksheet. Open a blank Excel document to complete this assignment.
Part 1: Enter data and performing calculations
1. In cell A1 key in the title Projected College Cash Flow Analysis
2. In cell A2 key in For [Your First and Last Name] as the subtitle
3. In cell A3 key in the title Resources and A12 Expenses
4. Using the information below key in the following data for A4:F10 and A13:F21
1.
A
B
C
D
E
F
4
Freshman
Sophomore
Junior
Senior
Total
5
529 Plans
2700.00
6
Financial Aid
5250.00
7
Job
3100.00
8
Parents
3700.00
9
Savings
4250.00
10 Other
1100.00
11 Total
A
B
C
D
E
F
13
Freshman
Sophomore
Junior
Senior
Total
14 Activity Fees
500.00
15 Books
650.00
16 Clothes
750.00
17 Entertainment
1650.00
18 Room & Board
7200.00
19 Tuition
8250.00
20 Miscellaneous
1100.00
21 Total
5. Perform the following formatting options to your spreadsheet
a. Change the Theme to Essential
b. Merge and Center the title in A1 and A2 across columns A:F
c. Change the font in A1:A2 to Cooper Black
Hint: if you do not have Cooper Black font, select a different font face
d. Increase the title font size in cell A1 to 22 and the subtitle font size in cell A2 to 18.
e. In cell A3 and A12 increase the font size to 14, change the font to Bold and a dark Gold color
f.
Apply a Heading 2 style to A4:F4 and A13:F13
g. Format the range of A5:F10 and A14:F20 with a 40% - Accent 2 style
h. Apply a Total Style to A11:F11 and A21:F21
i.
Autofit column A and increase the width of columns B:F to 12.50
j.
Center the column titles in B4:F4 and B13:F13

ADVERTISEMENT

00 votes

Related Articles

Related forms

Related Categories

Parent category: Education
Go
Page of 2