Page 52 - TP_Prime_v2.2_Class_5
P. 52

The names of default worksheets are Sheet 1, Sheet 2, Sheet 3, etc. To add a
                    worksheet, click on the plus sign on the right of the sheet tab.

                  •   Rows and Columns: Columns are the vertical sections of the table, whereas Rows
                    are the horizontal sections of the table. A table in Word can have a maximum of

                    63 columns but the number of rows is unlimited.

                  •   Cells: Cells are the intersection of rows and columns. It is the smallest unit in a
           Prime (Ver. 2.2)-V  •   Worksheet:  The  worksheet  is  divided  into  Rows  and  Columns.  The  rows  are
                    worksheet and can hold numbers, text or formula.




                    numbered as 1, 2, 3, 4… as indicated by the Row Headers on the left side of the
                    workspace. The columns are labelled alphabetically as A, B, C, D…Z, AA…AZ,… as
                    indicated by the Column Headers at the top of the workspace. The total number

                    of columns in Excel is 16,384. The total number of rows is 1,048,576.

          50      •   Active Cell: As the name suggests, it is the cell that is currently active or selected.
                    It can be recognised by its green outline. You can type data into an active cell only.

                  •   Formula Bar: It displays the contents of the active cell. You can also type or edit

                    data and formulas in the formula bar.


                    Changing the Active Cell



                  To change the active cell in a worksheet, you can either use the keyboard or the mouse

                  pointer. When working with a mouse, just click on the cell you want to make active.
                  Given below are the keys and their functions to change the active cell in a worksheet:


                  Key                        Function
                  Enter key                  Moves the active cell down one row

                  Shift + Enter key          Moves the active cell one row up

                  Shift + Tab key            Moves the active cell one column to the left
                  Tab key                    Moves the active cell one column to the right

                  ß [left arrow key]         Moves the active cell one column to the left
                  à [right arrow key]        Moves the active cell one column to the right

                  á [up arrow key]           Moves the active cell one row up

                  â [down arrow key]         Moves the active cell one row down
                  Ctrl + Home key            Moves the active cell to the first cell i.e. A1

                  Ctrl + End key             Moves the active cell to the last used cell on the worksheet
   47   48   49   50   51   52   53   54   55   56   57