This preview shows page 1. Sign up to view the full content.
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 nonblank 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
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.
 Fall '10
 MARIANAKANT

Click to edit the document details