Page 207 - CA_165_V2.0_C9_Flipbook
P. 207

●  Complex and long calculations can be solved accurately in a short span of time.
                         ●  Data can be exported to or imported from other packages.
                         ●  Data can be expressed in tabular or pictorial form, i.e. in the form of charts and graphs.
                         ●  Non-numeric data can also be processed.
                     2.   Discuss the various Cell Alignment options available in Calc.
                     Ans. Various horizontal alignment options are:
                         ●   Default: The contents will be aligned according to the default settings of the type of data being entered.
                         ●  Left: The contents will be aligned towards the left side of the cell.
                         ●  Right: The contents will be aligned towards the right side of the cell.
                         ●  Center: The contents will be aligned towards the center of the cell.
                         ●   Filled: The contents will be displayed within the column width only. The data which does not get
                             accommodated in the cell width will be hidden in the sheet.
                         ●   Justified: The contents will be displayed completely within the column width by increasing the column
                             width.
                         Various vertical alignment options are:
                         ●  Bottom: The contents will be aligned towards the bottom of the row.
                         ●  Top: The contents will be aligned towards the top of the row.
                         ●  Middle: The contents will be aligned in vertically centered position.
                         ●   Default: The contents will be aligned according to the default settings type of data being entered.
                     3.   Define any four parts of a spreadsheet screen.
                     Ans. Following are some of the parts of a spreadsheet screen:
                         ●  Title Bar: It lies at the top of the window screen. It displays the name of the active spreadsheet.
                         ●   Minimize/Maximize/Restore/Close Buttons: They are located at the upper  right corner  of the
                             window. They are used to minimize, maximize/restore and close the active document, respectively.
                         ●   Menu Bar: It lies below the title bar in the active window. It contains different menus which have
                             many options to perform various operations. If you click on them, then 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 on any of them, the option is directly executed.
                     4.   Differentiate between AutoFill and Custom List.
                     Ans.  AutoFill is an additional feature in spreadsheet package like Calc in which a certain kind of predefined
                         series of data such as name of months of a year, serial numbers, etc. are automatically generated once
                         the user feeds the initial data. We can print series of months of the year using AutoFill. Arithmetic and
                         Geometric progression can also be created and inserted automatically using this feature.
                           Whereas, Calc also provides a feature to create a custom list where some series of names or text that can
                         be predefined and then it can be displayed when the initial data is entered and AutoFill is applied. A user
                         can create his own list as per his needs, such as a list o f a company’s branch offices. After creation of the
                         customised list, it can be used to fill in a range of cells. In such a case just enter the first name in the list
                         and with the help of AutoFill feature drag the mouse, the predefined series will be displayed.
                 D.  Application based questions.
                     1.     A student was making mischief in his computer lab. Annoyed with his behaviour, his computer teacher
                         gave him a punishment of writing the table of 13 up to 13 multiples within 5 minutes. He was allowed
                         to use spreadsheet package, can you guess which feature will help him to complete this task easily and
                         quickly?
                     2.     Suppose the class teacher of Std IX ‘B’ told the monitor to prepare marks list of 10 students in the printed
                         form with their names and roll no. Which feature of spreadsheet will help him if he does not want to type
                         the names again and again?


                                                                                    Working with Spreadsheet     205
   202   203   204   205   206   207   208   209   210   211   212