This preview shows page 1. Sign up to view the full content.
Unformatted text preview: in the same
column. For example, the range C5..C9 refers to the cells C5. C6. C7. C8 and C9.
3. Block Range. It is used to include a set of adjacent cells in a rectangular group
of cells. For example, the range B5..D9 refers to the cells B5, B6, B7, B8, B9, C5,
C6, C7, C8, C9, D5, D6, D7, D8 and D9.
Notice that a particular range is indicated by the addresses of the endpoint cells
separated by two periods (B5..D9) oracolon(B5:D9).
Different types of data can be entered into a cell. The four commonly used types
of cell data are:
1. Label. A label is any string of alphanumeric text. Labels are used either to
enter alphanumeric values in cells (such as in cells A5 to A9 of Figure 15.9) or to
enter descriptive data or titles to make the contents easier to understand (such as in
the cells in rows 1 and 3 of Figure 15.9). Notice from the figure that the label in
cell Bl extends across columns C, D, E and F. This is possible when the adjacent
cells are blank, otherwise the text gets truncated after the column width. 2. Numeric Value. A numeric value is a number on which the spreadsheet can
perform calculations. For example, in the spreadsheet of Figure 15.9, cells B5..D9
contain numeric values.
3. Formula. A formula may include numbers, mathematical operators (such as
+, -, *, /, etc.), mathematical functions supported by the spreadsheet (such as
SUM, AVG, MIN, MAX, etc.), and cell addresses. For example, cell E9 contains
the formula @SUM(B9..D9) which means that the sum of the numeric values of
cells B9, C9 and D9 should be displayed in cell E9. The same result could have
also been obtained by entering the formula B9+C9+D9 in cell E9. Cell F9 of the
spreadsheet of Figure 15.9 also contains a formula, which is E9/3 and calculates
the percentage marks obtained by the student named J. Smith. Notice that in case
of formula entry, the contents displayed in the cell is not the formula itself but the
result of formula calculation.
4. Date and Time. Although not used in the spreadsheet of Figure 15.9...
View Full Document
This document was uploaded on 04/07/2014.
- Spring '14