Page 21 - Dig_CodeAI_V2.1_Class_5
P. 21

Cell

                 The intersection of a row and a column is called a cell. A cell in an Excel worksheet looks like
                 a rectangular box. Every cell in the worksheet has an address, which is called a cell address.
                 A cell address is a combination of a column heading and a row heading. For example, a cell
                 in the second row of column A has the cell address A2.

                 Active Cell

                 The currently selected cell that appears highlighted with the green border is active cell.
                 The data is entered in an active cell.

                 Mouse Pointer

                 The mouse pointer is displayed as a block plus sign ( ), whenever we move over a cell in a
                 worksheet. Another common shape of the mouse pointer is the block arrow.

                 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,  for  example,  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,
                 for example, A1, B2, 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 requirements.

                 Worksheet Tab

                 There can be more than one worksheet in Excel, and each has a specific name. Any worksheet
                 can be activated by clicking on its tab in the worksheet tab. These tabs are located at the
                 bottom-left of the Excel window as Sheet1, Sheet2, Sheet3 and so on.

                 Worksheet Tab Navigation Buttons

                 Worksheet  tab  navigation  buttons  are  located  on  the  left  side  of  the  worksheet  tabs.
                 These are used to move from one worksheet to another in a workbook.
                 Status Bar

                 The horizontal bar at the bottom, which shows various information about the file on which

                 you are working, is called the Status bar. The right section of the status bar has view control
                 buttons such as Normal and Page Layout for the spreadsheet.







                                                                                   Introduction to Excel 2016  19
   16   17   18   19   20   21   22   23   24   25   26