Page 205 - CA_165_V2.0_C9_Flipbook
P. 205

Solved Exercise


                                                              SECTION A
                                                      (Objective Type Questions)

                 A.  Multiple choice questions.
                     1.   What is a spreadsheet package primarily used for?
                         i.  Writing essays                                  ii.  Analysing data and performing calculations
                         iii.  Playing games                                 iv.  Sending emails
                     2.   Which of the following is NOT a feature of a spreadsheet package?
                         i.  Handling bulk data                              ii.  Performing long calculations
                         iii.  Writing programming code                      iv.  Creating charts and graphs
                     3.   What is the default number of worksheets in a new OpenOffice Calc spreadsheet?

                         i.  1                                               ii.  2
                         iii.  3                                             iv.  5
                     4.   How are rows numbered in OpenOffice Calc?
                         i.  A to Z                                          ii.  1, 2, 3, …
                         iii.  Roman numerals                                iv.  Random numbers
                     5.   Which key combination is used to save an OpenOffice Calc spreadsheet for the first time?
                         i.  Ctrl + N                                        ii.  Ctrl + S
                         iii.  Ctrl + Shift + S                              iv.  Ctrl + O

                     Ans. 1. ii.    2. iii.    3. iii.    4. ii.    5. iii.


                 B.   Fill in the blanks.
                     1.   OpenOffice Calc is a .................................... software.
                     2.   A spreadsheet  is a .................................... of multiple sheets.
                     3.   A .................................... is an intersection of a row and a column.
                     4.  .................................... displays the content of the active cell.
                     5.  .................................... displays the address of the active cell.

                     6.   To view the current status of an active sheet we can refer to the .....................................
                     7.   There are .................................... columns in a OpenOffice Calc spreadsheet.
                     Ans. 1. spreadsheet    2. combination    3. cell    4. Formula bar    5. Name box    6. Status bar

                         7. 1024

                 C.  Assertion and Reasoning question:
                       The following questions consist of two statements – Assertion (A) and Reasoning (R). Answer these
                     questions by selecting the appropriate option given below:
                     i.   Both Assertion (A) and Reason (R) are true and Reason (R) is the correct explanation of Assertion (A).

                     ii.   Both Assertion (A) and Reason (R) are true but Reason (R) is not the correct explanation of Assertion (A).
                     iii.  Assertion (A) is true, but Reason (R) is false.



                                                                                    Working with Spreadsheet     203
   200   201   202   203   204   205   206   207   208   209   210