What-If Analysis, Charting, And Working With Large Worksheets Page 78
ADVERTISEMENT
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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87EX 214
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
In the Lab
Lab 2: Analysis of Indirect Expense Allocations
Problem: Your classmate works part time as an advisor for the ReachOut Neighbors not-for-profi t
group. She has asked you to assist her in creating an indirect expense allocation worksheet
(Figure 3– 89) that will help the not-for-profi t administration better evaluate the branch offi ces
described in Table 3 – 11.
Figure 3 – 89
Table 3 –11 ReachOut Neighbor Worksheet Data
Chicago
Dallas
Houston
Jacksonville
Los Angeles
New York
Reno
Branch
Branch
Branch
Branch Offi ce
Branch Offi ce
Branch
Branch
Offi ce
Offi ce
Offi ce
Offi ce
Offi ce
Total Donations
735356
98190
178435
212300
175350
752900
1845230
Distributed Goods
529750
60891
135589
150895
96050
589590
1629350
and Services
Direct Expenses
57550
22530
14750
25300
42670
58600
65000
Square Footage
15500
775
7550
8250
950
6275
8600
Instructions Part 1: Do the following to create the worksheet shown in Figure 3–89.
1. Apply the Foundry theme to the worksheet. Bold the entire worksheet by selecting the entire
worksheet and using the Bold (Home tab | Font group).
2. Change the following column widths: A = 30.00; B through I = 13.00; J = 20.00.
3. Enter the worksheet titles in cells A1 and A2 and the system date in cell I2. Format the date to the
14-Mar-01 style.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education