Page 260 - Trackpad 402_Class-X_Final
P. 260

3.  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
            4.  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
            5.  Usually, you run a formula to calculate a result based upon existing values. By contrast, using, you can discover what values
              will produce the result that you want.                                                       [2022]
              a. Subtotal                                        b. Scenario
              c. Sort Lists                                      d. Goal Seek
            6.  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
            7.  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
            8.  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

            9.               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
          10.  In Spreadsheets,
               Statement I: To consolidate by row labels or column labels, the label must be contained in the selected source ranges.
               Statement II: The text in the labels must be identical, so that rows or columns can be accurately matched.
               Statement III: If the row or column label does not match any that exist in the target range, it will be appended as a new row
              or column.
               Consider the above three statements, identify the correct one.                              [2022]
              a. Only Statements I and II are correct            b. Only Statements II and III are correct
              c. Only Statement II is correct                    d. All the Statements are correct
          11.   Statement I: The data from the consolidation ranges and target range are saved when you save the worksheet.
              Statement II:  If you later open a worksheet in which consolidation has been defined, this data will not be available again.
               Consider above two statements, identify the correct one.                                    [2022]
              a. Statement I is wrong                            b. Statement II is wrong
              c. Both the Statements I and II are wrong          d. Both the Statements I and II are correct
          12.  Rohan has 50,000 that he wants to invest in two mutual funds for one year. Fund A is a low risk fund with 18% interest rate
              and Fund B is a higher risk fund with 21% interest rate. Which feature of spreadsheets (Calc) will be help him to decide
                                                                                                           [2022]
              a. Solver                                          b. Subtotal
              c. Linking sheets                                  d. Macros
          13.                is one of the functions available in the spreadsheet to perform addition of selected numbers in the sheet.
                                                                                                           [2020]


          260   Trackpad Information Technology-X
   255   256   257   258   259   260   261   262   263   264   265