3. The Kenney Condo shareholders currently pay $1.50 per share for monthly
maintenance expenses. Use formulas to calculate maintenance expenses for each
apartment (in Column C). Enter only one formula in cell location C2. Copy the formula
to all the cells below.
A
B
C
1 Apartments shares Maintenance
2 A1
300
3 A2
310
4 B1
400
5 B2
450
6 C1
350
7 C2
370
26
4. Instead of including the number $1.50 directly in your formula, as in the above
exercise, using the cell location C1 to store the number $1.50. Use C1 in your formula as
the reference to calculate the maintenance per shareholder. Fill out the following table by
copying your formula in C4 to the cells below:
A
B
C
1 Maintenance per share
15
2
3 Apartments shares Maintenance
4 A1
300
5 A2
310
6 B1
400
7 B2
450
8 C1
350
9 C2
370