Page 52 - ConceptGP_C5_Fb
P. 52

A2 is the
                  NAME BOX                                                           address of

                  A Name Box displays the address of an active cell or               the active
                                                                                        cell.
                  a range of selected cells. A cell’s address consists of its
                  column letter and row number.


                  CELLS
                  The intersection of a row and a column is called a cell. A cell is the
                  basic unit of a worksheet in which you enter data in the form of text,
                  numeric values, formulas or functions. A cell in your worksheet is

                  activated or selected for entering data into it. Each cell has a unique address. It is named
                  after combining the name of a column and row.
                  Address of cell: <Column letter><Row number>

                  The address of the selected cell is B9 which is made after
                  combining the column’s letter i.e. B and the row’s number i.e. 9.



                  Active Cells
                  A selected cell is known as the active cell. It has a dark border around it.


                  FORMULA BAR

                  The content  of the active  cell appears  in the
                  formula bar. When  the  cell contains  text  or a
                  fixed number, the content of the formula bar is
                  the same as what you see in the cell.




                  WORKSHEET TABS

                  Excel files are called workbooks and a workbook
                  can have multiple worksheets. Each worksheet has
                  a tab at the bottom of the screen. We can add a

                  new worksheet by left-clicking on the + sign.

                  STATUS BAR

                  The status bar is located at the bottom of the workbook window. It displays the status and
                  results of the common functions used in Excel 2010.





                  VIEW OPTIONS
                  These options help us to view the worksheets in different modes—Normal View, Page
                  Layout View and Page Break Preview.



                   50   Premium Edition-V
   47   48   49   50   51   52   53   54   55   56   57