Gulf Asian English School, Sharjah
Unit-2
ELECTRONIC SPREADSHEET(ADVANCED) USING LIBREOFFICE CALC
Chapter-4 Analyze Data Using Scenarios and Goal Seek
SUBJECT: IT GRADE-10
Short answer questions.
1. Define the terms
Answer:
(a) Consolidate function: Consolidate is a function in LibreOffice Calc used to combine
information from multiple sheets into one place — to summarize, view and
compare data in a single spreadsheet for identifying trends and relationships.
(b) What-if analysis: What-if analysis tool is a planning tool for what-if questions. In
this, the output is not shown in the same cells, whereas it uses a drop-down list to
display the output depending upon the input.
(c ) Goal seek: Goal Seek is a tool used to find the required input value when the desired
output is already known. It automatically changes one value to achieve a specific result.
2. Give one point of difference between
Answer:
(a) Subtotal and What-if:
Subtotal What-if
Subtotal tool in calc creates the group Process of changing values in cells to
automatically and applies common see how those changes will affect the
functions like sum, average on the outcome of formulas on spreadsheet.
grouped data.
(b) What-if scenario and What-if tool
What-if scenario What-if tool
It is a set of values that can be used What if tool is a planning tool for what
within the calculations in the if questions. It uses Data>multiple
spreadsheet. Name is given to each operations. In this data is not shown in
scenario and several scenarios can be same cells, instead it uses drop down
created on same sheet. list to display the output based on
input.
3. Give any two advantages of data analysis tools. Answer:
Answer:
Advantages of data analysis tools are:
• Data analysis is very useful in the beginning of any project to optimize the output.
• Data analysis is used to predict the output while changing the input which reflects the
output and thus one can choose the best plan of action based on it.
• For identifying the patterns, trends and relationships within the data.
4. Name any two tools for data analysis.
Answer:
Tools used for data analysis are:
• Goal Seek
• Scenarios
• Multiple operations
5. List the prerequisites required before consolidating data in Calc.
Answer:
Criteria for consolidating sheets are:
• Open each sheet in the spreadsheet and check that the data types must match which
you want to consolidate.
• Match the labels from all the sheets which are used for consolidating.
• Enter the first column as the primary column based on which the data is to be
consolidated.
6. Which tool is used to create an outline for the selected data?
Group and Outline Tool in Calc is used to create an outline of selected data. It allows
grouping of rows or columns and enables collapsing (−) to hide data or expanding (+) to show
it with a single click.