{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Dale - Computer Science Illuminated 406

Dale - Computer Science Illuminated 406 - 12.2 Spreadsheets...

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

View Full Document Right Arrow Icon
Range A set of contiguous cells specified by the endpoints 12.2 Spreadsheets 379 Because functions often operate on a set of contiguous cells, spread- sheets provide a convenient way to specify a range of cells. Syntactically, a range 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 can specify a set of cells down a column, such as C4..C8. A range can also specify a rectangular block of cells, ranging from the top left to the bottom right. For example, the range C4..E8 includes the cells C4 to C8, D4 to D8, 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. For example, the formula in cell G7 divides the value in cell F7 by the count of cells in the range C7..E7, which is 3. The formula in cell G7 could have been written as follows: =SUM(C7..E7)/3 Given the current status of the spreadsheet, this formula would compute the same result. However, there are two reasons why this formula is not as
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}