Page 281 - TP_IT_V1.0_C10_flipbpookl
P. 281

Exercise




                                                                   Solved


                                                   SECTION A (Objective Type Questions)

                 A.  Choose the correct option.

                    1.  Data available in other sheets in a workbook, can be consolidate by    .
                       a. Row label                                      b. Column Label
                       c. Both a & b                                     d. None of the mentioned

                    2.  What all operations can we perform using data consolidation?
                       a. Max                                            b. Min
                       c. Average                                        d. All of these
                    3.               analysis tool works in reverse order, finding input based on the output.
                       a. Consolidate function                           b. Goal seek
                       c. What-if analysis                               d. Scenario
                    4.  Goal seek is a           Tool.
                       a. Comparison                                     b. What-if analysis
                       c. consolidate                                    d. Additional
                    5.  What is the purpose of using macros in a computer?
                       a. To manually enter data                         b. To automate repetitive tasks
                       c. To increase the speed of internet browsing     d. To create complex formulas
                    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 → Track Changes → Record                  b. File → Track Changes → Record Changes
                       c. Tools → Track Changes → Record Changes         d. Data → Track Changes → Record Changes
                   12.  Which of the following menu contains the Subtotal option?
                       a. File                                           b. Data
                       c. Tools                                          d. Insert

                                                                      Electronic Spreadsheet (Advanced) using LibreOffice Calc  279
   276   277   278   279   280   281   282   283   284   285   286