Page 61 - iPlus_Ver_2.0_class_7
P. 61
Cell Range
A cell range is a collection of two or more cells. It is of two types: Contiguous Cell Range
and Non-Contiguous Cell Range. Contiguous Cell Range is a collection of cells that are
adjacent to or next to one another. A colon (:) is used for specifying this cell range, e.g., A1:A6.
Non-contiguous Cell Range is a collection of cells that are not adjacent to one another. A
comma (,) is used for specifying this cell range, e.g., (A1, B1, C3).
Workbook
An Excel file is called a workbook. It is a collection of different worksheets. By default, a workbook
contains only one worksheet, Sheet1. The number of worksheets can be increased as per the
requirement.
Block
A group of cells when selected forms a rectangle, which is called a block.
#Digital Literacy
Let’s CatCh Up
Match the following:
1. Row header a. Address of the active cell
2. Column header b. Displays content of active cell
3. Sheet tab c. Row numbers
4. Name box d. Column letters
5. Formula bar e. Displays number sheets in worksheet
i + TYPES OF DATA
While working in Excel, the following types of data can be entered:
Numeric Data
Numeric data consist of digits (0-9), ‘e’ (Exponential), decimal (.) and numeric operators like +,
-, /, *, %, $. Numeric data or values are aligned towards the right side in a cell. Numeric Data are
the operands on which formula is applied to perform arithmetic calculation. Operands refer to
data on which formula is applied.
Alphanumeric or Text Data
Alphanumeric data are the data which are textual in nature. It refers to the data which is a
combination of letters, spaces, digits and/or other characters. In Excel, alphanumeric data are
aligned (by default) towards the left side of the cell and are generally not meant for calculation.
Date and Time
Excel displays date as sequential numbers known as Serial Values. The time is displayed as
fractional part. Date and Time are values and therefore can be added or subtracted and can be
included for other calculations. They are aligned (by default) towards the right side of the cell.
59
Spreadsheets—An Introduction

