Spreadsheet functionA computation providedby the spreadsheet soft-ware that can be incor-porated into formulas378Chapter 12Information SystemsFigure 12.3The formulas behind some of the cells123456789101112ABCDEFGHFrankAmyTutorHalTotalAvg1310123511.671616144615.331318104113.67182184715.671218154515.0072835921471.3314.4016.6011.80123Week45TotalAvg42.8014.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 theformulas underlying some of the cells. Formulas in our examples (as inmany spreadsheet programs) begin with an equal sign (=). That’s how thespreadsheet knows which cells contain formulas that must be evaluated.The formulas in this example refer to particular cells (by their columnand row designation). When a formula is evaluated, the values stored in
This is the end of the preview.
access the rest of the document.