Page 253 - Trackpad 402_Class-X_Final
P. 253

6.  Which function cannot be performed through Subtotal in a Spreadsheet?       [CBSE Sample Paper 2022]
                  a. Sum                                            b. Product
                  c. Average                                        d. Percentage
               7.  Which type of questions are tested by using the Scenarios?
                  a. Auto                                           b. Short
                  c. What-if                                        d. Long

               8.  It refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to
                  calculate.                                                                   [CBSE Sample Paper 2022]
                  a. Row                                            b. Column
                  c. Autosum                                        d. Cell Reference
               9.  Which of the following is more elaborate form of Goal Seek?                 [CBSE Sample Paper 2022]
                  a. Subtotal                                       b. Scenario
                  c. Solver                                         d. Consolidate
              10                 means combining data in a spreadsheet from different worksheets into master worksheet.
                                                                                               [CBSE Sample Paper 2022]
                  a. Hyperlinks                                     b. Consolidating
                  c. Linking                                        d. Filter
              11.  Which of the following is the correct step to record changes?
                  a. Edit → Changes → Record                        b. File → Changes → Record Changes
                  c. Tools → Changes → Record Changes               d. Data → Changes → Record Changes
              12.  Which of the following menu contains the Subtotal option?
                  a. File                                           b. Data
                  c. Tools                                          d. Insert
              13.  Which of the following is not an example of cell referencing?
                  a. A1:B6                                          b. G6
                  c. C10:C20                                        d. 7Q

              14.  Which of the following is not present in the Insert Sheet dialog box?
                  a. Before current sheet                           b. After current sheet
                  c. New Sheet                                      d. Create
              15.  Which of the following options is used to share a worksheet?
                  a. Share Document                                 b. Share Worksheet
                  c. Share                                          d. None of these
             Ans.  1. c   2. d   3. b   4. b   5. c   6. d   7. c   8. d   9. c   10. b   11. a   12. b   13. d   14. d   15. a

            B.  Fill in the blanks.

               1.                and              are some of the important data analysis tools available in OpenOffice spreadsheet.
               2.  Groupwise calculation of sum, average, max, min, count etc. can be done by using the    option of OpenOffice
                  calc.
               3.                are what-if analysis tools of OpenOffice Calc that helps you set multiple values for the same cell.
               4.                tool helps you do backward calculation of the input to obtain the desired output.
               5.  Macros are present in           menu.
               6.  Comments option is present under the         menu.
               7.                option is used to combine two worksheets.
               8.  A              saves you from the tedious repetitive tasks.
               9.  The Run Macro option under the           menu is used to run a macro.




                                                                                 Electronic Spreadsheet (Advanced)  253
   248   249   250   251   252   253   254   255   256   257   258