D5 that adds the contents of cells b5 c5 and d5 this

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

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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). Cell Contents 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.

Ask a homework question - tutors are online