Page 290 - TP_IT_V1.0_C10_flipbpookl
P. 290

12.  How many sheets are provided by default in spreadsheets in a workbook?                      [2023]
                13.  Record changes feature of Calc marks a deleted column or row in a worksheet by a   .        [2023]
                    a. red border over the cell                        b. green border over the cell
                    c. red shade in the cell                           d. heavy colored bar
                14.  Give an example of statistical function in Calc.                                            [2023]
                15.  Explain the following w.r.t. spreadsheets :
                     a. Scenario
                     b. Goalseek
                16.                function takes data from a series of worksheets or workbooks and summaries it into a single worksheet
                    that you can update easily.                                                                  [2022]
                    a. Summation                                       b. Data Consolidation
                    c. Data Format                                     d. Data Chart

                17.  If you are continually working with the same range, then you may give a name to the range using    option
                    under Data Menu.                                                                             [2022]
                    a. Define data                                     b. Define range
                    c. Define reference                                d. Define address
                18.  In Calc, using the Subtotals dialog, you can select arrays and then choose a statistical function to apply to them. For
                    efficiency, you can choose up to         groups of array to which to apply a function.       [2022]
                    a. two                                             b. three
                    c. four                                            d. five
                19.  Solver option under Tools menu amounts to a more elaborate form of     . The difference is that the Solver
                    deals with equations with multiple          .                                                [2022]
                    a. Unknown variables, Goals Seek                   b. Variables, Equation
                    c. Goal Seek, Unknown variables                    d. Subtotal, Goal seek
                20.  Usually, you run a formula to calculate a result based upon existing values. By contrast, using   , youcan
                    discover what values will produce the result that you want.                                  [2022]
                    a. Subtotal                                        b. Scenario
                    c. Sort Lists                                      d. Goal Seek
                21.  Rama and two of her friends are doing survey of gender wise employment rates of their locality as a school project using
                    Spreadsheet. They all want to work simultaneously to complete it on time. What option they should use to access the
                    same Spreadsheet to speed up their work.                                                     [2022]
                    a. Consolidate Worksheet                           b. Shared Worksheet
                    c. Link Worksheet                                  d. Lock Worksheet
                22.  In Calc, you can use a cell reference in one or several formulas to refer to:               [2022]
                    a. Data from one or more contiguous cells on the worksheet  b. Data contained in any Software
                    c. Data contained in any format in databases       d. Images in picture gallery
                23.  In Calc, to create the reference with the mouse:                                            [2022]
                    a. Both Spreadsheets need not be open              b. Select the cell in which the formula is going to be entered
                    c. There is no need of symbol                      d. Cell reference is not required
                24.                can be used in Calc to jump to a different location from within a spreadsheet and can lead to other parts
                    of the current file, to different files or even to websites.                                 [2022]
                    a. Tables                                          b. Goal Seek
                    c. Auto Sum                                        d. Hyperlinks

                25.  Arguments passed to a macro from Calc are always        .                                   [2022]
                    a. Strings                                         b. References
                    c. Numbers                                         d. Values




                288   Trackpad Information Technology (Ver. 1.0)-X
   285   286   287   288   289   290   291   292   293   294   295