{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Dale - Computer Science Illuminated 405

# Dale - Computer Science Illuminated 405 - 378 Chapter 12...

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.

{[ snackBarMessage ]}

Ask a homework question - tutors are online