Page 245 - open office
P. 245

N ot e s
                                                   labelled
                                                 is
                                                           as

                                                             A
                                          column
                              Calc,
                            In Calc, the first column is labelled as  A  and the last column i.e. 1 24th column is labelled as  AM  . In
                                   the
                                        st
                                      fir
                                                                and
                                                                                                            as
                                                                                                    labelled
                                                                                                  is
                                                                                                                   In
                                                                                                                  .
                                                                                                              AM
                                                                          column
                                                                       last
                                                                   the
                                                                                           column
                                                                                    1 24th
                                                                                 i.e.
                            In  Calc,  the  fir st  column  is  labelled  as      A    and  the  last  column  i.e.  1 24th  column  is  labelled  as      AM   .  In
                            In

                                                                     A
                                                                     A
                                                                       and
                                                                           the

                                                                       and

                                                           labelled
                                                         is
                                                         is
                                                           labelled

                                                                  as
                                                                  as
                                                                                                     column
                                                                                                     column
                                                                                             16,3 4th
                                                                                                            is
                                                                                                              labelled
                                                                                                              labelled
                                                                                                            is
                                                                                             16,3 4th
                                                                               last
                                                                               last
                                                                           the
                                                                                  column
                                                                                          i.e.
                                                                                          i.e.
                                                                                  column
                                          the
                                          the
                                     2 1 ,
                                                st
                                              fir
                                              fir
                            MS-Ex
                            MS-Ex
                            MS-Excel 2 1 , the first column is labelled as  A  and the last column i.e. 16,3 4th column is labelled
                                     2 1 ,
                                  cel
                                  cel
                                                st
                                                  column
                                                  column
                            as ‘XFD’.
                            as ‘XFD’ .
                 Cells
                 A rectangular box formed by the intersection of a row and column is called a cell. Cell is the basic unit of a
                 worksheet where data (numbers, text, formulas, etc.) are entered.
                 Title Bar
                 It lies at the top of the window screen. It displays the name of the active workbook. When the spreadsheet is
                 newly created, by default it is named as Untitled1, second is Untitled2 and so on.
                 Menu Bar
                 It lies below the title bar in the active window screen. It contains different menus which have many options
                 to perform various operations. If you click on them or press ‘Alt’ along with the underlined character of the
                 menu name, the specific menu opens with its relevant options.
                 Standard Toolbar
                 It generally lies below the menu bar. It contains shortcut buttons of frequently used options. By clicking any
                 of them, the option is directly executed.
                                                                                           Show Draw
                                                                                           Functions
                                                                                                         Sources
                        Open      Edit File  Print       Cut   Paste          Hyperlink  Sort    Navigator  Data
                                              Page   AutoSpell
                    New       Save           Preview Check  Copy     Undo Redo     Descending         Gallery Zoom
                              Document   Export   Spelling        Format           Sort    Chart  Find &          Help
                               as e-mail                                                        Replace
                                       Directly                  Paintbrush      Ascending
                                       as PDF
                 Formatting Toolbar
                 It lies below the standard toolbar. It contains shortcut buttons that provide quick access to frequently used
                 formatting options that help to change the appearance of the text or data inside the sheet.
                                                                                      NF: Add      Increase
                                                                   Align Right      Decimal Places  Indent
                    Style and                                               Merge              Decrease   Background
                   Formatting   Font Name      Font Size  Italic  Align Le   Cells  NF: Percent  Indent     Color
                                                     Bold  Underline   Justi ed     NF: Standard       Borders  Font Color
                                                                 Align Center  NF: Currency  Delete Decimal
                                                                                          Places
                 Formula Bar
                 Formula bar lies below the formatting toolbar. Formula that performs different calculations in cells is entered
                 and displayed here. It is denoted by ‘fx’.
                                                                                     Working with Spreadsheet       245
   240   241   242   243   244   245   246   247   248   249   250