Page 271 - open office
P. 271

6.  Write short notes on the following:
                        i.  Formulae Bar                               ii.  Sheet Tabs
                        iii. Operands                                  iv.  Cell
                    Ans.  i.  Formulae Bar: One of the most important features of the spreadsheet package is doing calculations. For
                           calculation, formulae are used. The formula applied in a particular cell can be viewed in the formula bar when
                           a specific cell is selected.
                        ii.  Sheet Tabs: It lies below the active sheet of the screen. The names of the worksheets appear in the sheet
                           tabs at the bottom of the workbook. Click on the specific sheet tab to open it.
                        iii.  Operands: Numeric data are the operands on which the formula is applied to perform arithmetical calculation.
                           Operands refer to data on which the formula is applied.
                        iv.  Cell: 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.) is entered.
                       .  What are the different types of data that can be entered in the cells

                    Ans.  Numeric Data:  umeric data consists of digits ( – ),  e  (Exponential), decimal (.) and numeric operators like  , -, /,
                         ,  ,  .  umeric data or values are aligned towards the right side of a cell.  umeric data are the operands on which
                        the formula is applied to perform arithmetical calculations. Operands refer to data on which the formula is applied.
                        Alphanumeric or Text Data: Alphanumeric data are the data that are textual in nature. It refers to the data that
                        is a combination of alphabets, spaces, digits and/or other characters. Alphanumeric data are mentioned within
                        double quotes “ ”. In Calc, alphanumeric data are aligned (by default) towards the left side of the cell and are
                        generally not meant for calculation.
                        Date and Time: ‘Calc’ displays date as sequential numbers known as Serial Values. The time is displayed as a
                        fractional part. Date and Time are values and therefore can be added or subtracted and can be included for
                        other calculations. They are aligned (by default) towards the right side of the cell.
                        Formula: A formula is an expression that helps to perform arithmetical calculation and also executes non-
                        arithmetical tasks. It consists of the operands and operators which operate upon the data. Formula has to be
                        expressed with prefix     before the operator/data.
                       .  What is a Spreadsheet Package  What are its features
                    Ans.  A spreadsheet package enables to accomplish such tasks quickly and efficiently. A spreadsheet package is an
                        application software that does analysis, calculations, comparisons and displays information in the required format
                        and in charts and graphs. By using a spreadsheet application, a user can arrange and store data in a systematic
                        manner and can also make use of logical functions to compute and analyze the data in different ways.
                        Spreadsheet packages are commonly used for keeping data, displaying organized data, generating results,
                        planning budgets, making annual reports of business organisations, generating salary statements, doing tax
                        calculations, etc.
                        Features of a Spreadsheet Package:
                        With the help of a spreadsheet package:
                          Bulk volume of data can be kept and handled in an easier way.
                          Complex and long calculations can be solved accurately.
                          Data can be exported to or imported from other packages.
                          Data can be expressed in tabular or pictorial forms, i.e. in the form of charts and graphs.
                          The formulae for calculation can be automatically applied to any data even when the data value changes.
                       .  What is a formatting toolbar
                    Ans.  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.





                                                                                     Working with Spreadsheet       2 1
   266   267   268   269   270   271   272   273   274   275   276