This preview shows page 1. Sign up to view the full content.
Spreadsheet function
A computation provided
by the spreadsheet soft
ware that can be incor
porated into formulas
378
Chapter 12
Information Systems
Figure 12.3
The formulas behind some of the cells
1
2
3
4
5
6
7
8
9
10
11
12
ABCDEFGH
Frank
Amy
Tutor
Hal
Total
Avg
13
10
12
35
11.67
16
16
14
46
15.33
13
18
10
41
13.67
18
21
8
47
15.67
12
18
15
45
15.00
72
83
59
214
71.33
14.40
16.60
11.80
1
2
3
Week
4
5
Total
Avg
42.80
14.27
=SUM(C4.
.C8)
=E9/COUNT(E4.
.E8)
=F9/COUNT(C4.
.E8)
=F7/COUNT(C7.
.E7)
=SUM(C4.
.E4)
Figure 12.3 shows the same spreadsheet as Figure 12.2, indicating the
formulas underlying some of the cells. Formulas in our examples (as in
many spreadsheet programs) begin with an equal sign (=). That’s how the
spreadsheet knows which cells contain formulas that must be evaluated.
The formulas in this example refer to particular cells (by their column
and row designation). When a formula is evaluated, the values stored in
This is the end of the preview. Sign up
to
access the rest of the document.
This note was uploaded on 01/13/2011 for the course CSE 1550 taught by Professor Marianakant during the Fall '10 term at York University.
 Fall '10
 MARIANAKANT

Click to edit the document details