RangeA set ofcontiguous cells specifiedby the endpoints12.2Spreadsheets379Because functions often operate on a set of contiguous cells, spread-sheets provide a convenient way to specify a rangeof cells. Syntactically, arange is specified with two dots (periods) between the two cell endpoints.A range can specify a set of cells along a row, such as C4..E4, or it canspecify a set of cells down a column, such as C4..C8. A range can alsospecify a rectangular block of cells, ranging from the top left to the bottomright. For example, the range C4..E8 includes the cells C4 to C8, D4 toD8, and E4 to E8.Several of the formulas shown in Figure 12.3 use the COUNT function,which computes the number of non-blank cells in the specified range. Forexample, the formula in cell G7 divides the value in cell F7 by the count ofcells in the range C7..E7, which is 3.The formula in cell G7 could have been written as follows:=SUM(C7..E7)/3Given the current status of the spreadsheet, this formula would computethe same result. However, there are two reasons why this formula is not as
This is the end of the preview.
access the rest of the document.