81
iNPuT
DATA
Expense Report
34
19. Set the Print Area to include all cells containing data in the spreadsheet.
20. Print Preview and adjust the Page Setup so that each six month period's
expense report fi ts on its own page.
21. Print a copy of each spreadsheet if required by your instructor.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
A
B
C
D
E
F
G
H
MIKE'S BIKE RENTALS
Activity 34 Student Name
200 Thames Street
Newport, RI 02840
EXPENSE REPORT
2010
ACCOUNTANT:
Student Name
EXPENSE CATEGORY
JULY
AUGUST
SEPTEMBER OCTOBER
NOVEMBER DECEMBER TOTALS
Payroll
3257
3102
3109
2832
2732
3570
Payroll Taxes
825
758
752
690
598
945
Advertising (yellow pages)
125
125
125
125
125
125
Rent
1000
1000
1000
1000
1000
1000
Supplies
325
175
98
142
275
135
Insurance
825
825
825
825
825
825
Alarm System
150
150
150
150
150
150
Electricity
77
74
66
71
79
85
Telephone
61
59
45
57
63
70
TOTAL
MIKE'S BIKE RENTALS
Activity 34 Student Name
200 Thames Street
Newport, RI 02840
EXPENSE REPORT
2009
ACCOUNTANT:
Student Name
EXPENSE CATEGORY
JULY
AUGUST
SEPTEMBER OCTOBER
NOVEMBER DECEMBER TOTALS
Payroll
3247
3230
3200
2627
2645
3024
Payroll Taxes
830
802
795
645
584
750
Advertising (yellow pages)
115
115
115
115
115
115
Rent
900
900
900
900
900
900
Supplies
210
175
432
315
207
88
Insurance
760
760
760
760
760
760
Alarm System
125
125
125
125
125
125
Electricity
65
59
71
80
75
65
Telephone
54
49
77
112
88
61
TOTAL
ACTIVITY
For Evaluation Purposes Only