Page 252 - Trackpad 402_Class-X_Final
P. 252

REVISIT



              ▶ Data Consolidation means to collect data from different sources into a common place by using different built
             in functions like sum(), max(),min(),average() etc.
              ▶ Groupwise calculation of sum, average, max, min, count etc. can be done by using the Subtotal option of
             OpenOffice calc.
              ▶ Scenario helps you set multiple values for the same cell that can be used for calculations or data analysis.
              ▶ Goal Seek is a tool that helps you do backward calculation of the input to obtain the desired output.
              ▶ In case of Goal Seek you get the desired result by changing one variable whereas in case of Solver you get the
             desired result by changing the multiple variables.
              ▶ Linking the worksheets is done to access data present in the different sheets of the same worksheet or in
             different worksheets.
              ▶ A cell reference is the method used to refer to a cell or a range of cells in a worksheet.
              ▶ Hyperlink means a content when clicked will open another linked file.
              ▶ OpenOffice Calc allows you to keep a track of the changes made in a document using the Record Changes
             option.
              ▶ Merging Worksheets option helps you merge two or more different versions into one document.







       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 the above
            3.  To edit a Scenario, Right-click the name in the Navigator and select    .
              a. Properties                                      b. Scenario
              c. Windows                                         d. Edit
            4.  Goal seek is a          Tool.
              a. Comparison                                      b. What-if analysis
              c. consolidate                                     d. Additional
            5.  To refer a cell from another worksheet, use worksheet number followed by    sign and cell address.
              a. colon                                           b. comma
              c. period                                          d. hash




          252   Trackpad Information Technology-X
   247   248   249   250   251   252   253   254   255   256   257