Page 195 - CA 165 ver 1.0 Class 9
P. 195

●   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 workbook screen.
                     Ans. Following are some of the parts of a workbook screen:
                         ●  Title Bar: It lies at the top of the window screen. It displays the name of the active workbook.
                         ●   Minimize/Maximize/Restore/Close Buttons: They are located at the upper  right corner  of the
                             screen. They are used to minimize, maximize/restore and to close the active document respectively.
                         ●   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 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
                         customized 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 Auto Fill feature drag the mouse, the predefined series will be displayed.
                 C.  Application based questions.
                     1.     A student was making mischief in his computer lab. Annoyed with his behavior, 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?

                     Ans. 1. AutoFill    2. Custom List

                Unsolved Exercise


                                                                PART A
                 A.  Very short answer type questions.
                     1.   How many rows are there in a worksheet of Calc?
                     2.   What is active cell?
                     3.   Write the shortcut to save a new workbook.

                     4.   Which feature of Calc is used to place the cursor anywhere in a sheet directly?
                     5.   What is the shortcut key for Redo?
                     6.   Which feature of Calc can be used to print series of months of the year?

                                                                                    Working with Spreadsheet     193
   190   191   192   193   194   195   196   197   198   199   200