CLASS 10:UNIT-2:NOTES- Electronic Spreadsheet(Advanced) CHAPTER 4- IMPORTANT - aiitlearning.com-AI/IT notes and important questions

CHAPTER-4 ANALYSE DATA USING SCENARIOS AND GOAL SEEK

1. Which of the following feature is not used for data analysis in spreadsheet?

(a) Consolidating data

(b) Goal Seek

(d) Page layout

Answer: Page layout

2. Which of the following office tool is known for data analysis?

(a) Writer

(b) Calc

(d) Draw

Answer: Calc

3. Which of the following operations cannot be performed using LibreOffice Calc?

(a) Store and manipulate data

(b) Create graphical representation of data

(d) Mail merge

Answer: Mail merge

4. What is the extension of spreadsheet file in Calc?

(a) .odb

(b) .odt

(d) .ods

Answer: .ods

5. The default function while using Consolidate is:

(a) Average

(b) Sum

(d) Count

Answer: Sum

6. Group by is used in __________ tool to apply summary functions on columns.

(a) Consolidate function

(b) Group and Outline

(d) Subtotal tool

Answer: Subtotal tool

7. Which tool is used to predict the output while changing the input?

(a) Consolidate function

(b) What-if scenario

(d) Find and Replace

Answer: What-if scenario

8. Which of the following is an example for absolute cell referencing?

(a) C5

(b) $C$5

(d) #C

Answer: $C$5

9. __________ analysis tool works in reverse order, finding input based on the output.

(a) Consolidate function

(b) Goal seek

(d) Scenario

Answer: Goal seek

B. State whether the following statements are True or False

1. Consolidate function is used to combine information from two or more sheets into one.
True

2. Consolidate function cannot be used to view and compare data.
False

3. Link to source data is checked updates the target sheet if any changes made in the source data.
True

4. Using subtotal in Calc needs to use filter data for sorting.
False

5. Subtotal tool can use only one type of summary function for all columns.
False

6. Only one scenario can be created for one sheet.
False

7. What-if analysis tool uses one array of cells.
False

8. Goal seek analysis tool is used while calculating the output depending on the input.
False
(Goal Seek works reverse: it finds the input needed to reach a desired output.)

9. The output of What-if tool is displayed in the same cell.
False

C. Fill in the Blanks:

1. Consolidate function is used to combine information from multiple sheets to summarize the information.

2. Data can be viewed and compared in a single sheet for identifying trends and relationships using Consolidate function.

3. Consolidate under Data menu can be used to combine information from multiple sheets into one sheet to compare data.

4. The Subtotal tool in Calc creates the group automatically and applies functions on the grouped data.

5. What-if scenario is used to explore and compare various alternatives depending on changing conditions.

6. Scenario is a planning tool for what-if questions.

7. What-if analysis tool uses two arrays of cells, one array contains input values and the second uses the formula/output.

8. Goal Seek helps in finding out the input for the specific output.

D. Answer the following Questions:

Define the terms:

(a) Consolidate Function:

It is used to combine and summarise similar data from multiple sheets into a single sheet. It helps in creating totals, averages, and other summary results from different sheets.

(b) What-if Analysis:

What-if analysis is used to see how changing input values affects the output of a formula. It is mainly used for planning and forecasting.

Goal Seek works backwards. Instead of entering input to get an output, it finds the input required to reach a specific output.

2. Give one point of difference between

(a) Subtotal and What-if:

Subtotal summarises grouped data. What-if checks the effect of changing inputs.

(b) What-if scenario and What-if tool:

Scenario creates different versions for comparison. What-if tool changes inputs to calculate outputs.

3. Give any two advantages of date analysis tools.

Advantages of data analysis tools:

1. Helps summarise large data easily.

2. Helps compare and understand trends.

4. Name any two tools of data analysis.

4. Two tools for data analysis:

1. Consolidate

2. Subtotal

5. What are the criteria for consolidating sheets?

Open each sheet and make sure the data types (numbers, text) are the same in all sheets.
Check that the headings/labels in every sheet match.
Keep the first column the same in all sheets, as it will be used to combine the data.

6. Which tool is used to create an outline for the selected data?

Ans: Group and Outline in Calc is used to create an outline for the selected data.

CLASS 10:UNIT-2: Electronic Spreadsheet (Advanced) using LibreOffice Calc