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
   56   57   58   59   60   61   62   63   64   65   66