Dale - Computer Science Illuminated 405

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

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
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
Background image of page 1
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.

Ask a homework question - tutors are online