Page 74 - 2422_C5_Flipbook
P. 74

Factopedia











                                                                                                       6

                                                                         7
                      The shortcut to
                    Repeat last action
                           is F4.
                                                   Let’s PraCtiCe                               Century   #Technology Literacy
                                                                                                  21 st
                                                                                                 Skills
                                                     Open a new workbook and use Auto Fill feature to:

                                                     1.  insert all the days of a week in column A.
                                                     2.  insert 1 to 20 numbers in column B.
                                                     3.  insert A to Z in column C.






                                                            Let’s BaCk-uP
                    The address of the
                     last cell in Excel is              A range is a rectangular section of cells which are next
                      ‘XFD1048576’.                   to each other and at least one side of their border is
                                                      common.
                                                        There are three different types of data that you can
                                                      enter in a spreadsheet, in Excel.
                                                        Type an apostrophe (‘) before a numeric value to make
                                                      it appear as text.

                                                        You can format the cells to display the date and time
                                                      format that you want.
                                                        The process of changing data either partially or
                                                      completely is known as editing.

                                                        Cell contents can be edited by replacing the cell
                                                      contents and using the formula bar.
                                                        You can easily copy and move the contents of a cell, a
                     An Excel cell can
                    contain upto 32,767               range of cells and an entire worksheet.
                    characters (letters,                The Auto Fill feature in Excel is used to automatically fill
                   numbers or symbols.                series of data in rows and columns based on the values
                                                      of other cells.



                  72    Premium Edition-V
   69   70   71   72   73   74   75   76   77   78   79