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

