Chapter 4 Analyse Data using Scenarios and Goal Seek Question Answer Class 10 IT

A. Multiple choice questions

1. Which of the following feature is not used for data analysis in spreadsheet?
(b) Consolidating data
(b) Goal Seek
(c) Subtotal
(d) Page layout

Answer:(d) Page layout

 

2. Which of the following office tool is known for data analysis?
(a) Writer
(b) Calc
(c) Impress
(d) Draw

Answer:(b) Calc

3. Which of the following operations cannot be performed using LibreOffice Calc?
(a) Store and manipulate data
(b) Create graphical representation of data
(c) Analysis of data
(d) Mail merge

Answer:(d) Mail merge

4. What is the extension of spreadsheet file in Calc?
(a) .odb
(b) .odt
(c) .odg
(d) .ods

Answer:(d) .ods

5. The default function while using Consolidate is ____________.
(a) Average
(b) Sum
(c) Max
(d) Count

Answer:(b) Sum

 

Analyse Data using Scenarios and Goal Seek Question Answer Class 10 IT

6. Group by is used in _____________ tool to apply summary functions on columns.
(a) Consolidate function
(b) Group and Outline
(c) What-if scenario
(d) Subtotal tool

Answer:(d) Subtotal tool

7. Which tool is used to predict the output while changing the input?
(a) Consolidate function
(b) What-if scenario
(c) Goal seek
(d) Fine and Replace

Answer:(b) What-if scenario

8. Which of the following is an example for absolute cell referencing?
(a) C5
(b) $C$5
(c) $C
(d) #C

Answer:(b) $C$5

9. _____________ analysis tool works in reverse order, finding input based on the output.
(a) Consolidate function
(b) Goal seek
(c) What-if analysis
(d) Scenario

Answer:(b) Goal seek

Analyse Data using Scenarios and Goal Seek Question Answer Class 10 IT

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]

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

Analyse Data using Scenarios and Goal Seek Question Answer Class 10 IT

C. Fill in the blanks

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

summarize

 

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

consolidate

 

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

Subtotal

 

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

Subtotal

 

5. ___________ scenario is used to explore and compare various alternatives depending on changing conditions.

What-if

 

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

What-if tool

 

7. What-if analysis tool uses ______ array of cells, one array contains input values and the second uses the ________.

two, formula,display output

 

8. _____________ helps in finding out the input for the specific output.

Goal seek

Analyse Data using Scenarios and Goal Seek Question Answer Class 10 IT

D. Answer the following questions

1. Define the terms

(a) Consolidate function

Answer:  The Consolidate function in LibreOffice combines data from multiple ranges or sheets into a single sheet, aggregating values using functions like SUM, AVERAGE, COUNT, etc.

(b) What-if analysis

Answer: What-if analysis in LibreOffice involves changing the values in cells to see how those changes will affect the outcome of formulas in the spreadsheet, helping users explore different scenarios and their potential impacts.

 

(c) Goal seek

Answer: Goal seek in LibreOffice is a tool that finds the input value needed to achieve a specific goal in a formula. It adjusts a single variable value to reach a desired outcome in another cell.

Analyse Data using Scenarios and Goal Seek Question Answer Class 10 IT

2. Give one point of difference between

(a) Subtotal and What-if

Answer:

Subtotal: Used to calculate intermediate totals and summaries within a dataset.

What-if: Used to explore the effects of changing input values on the outcomes in a spreadsheet, typically for scenario analysis.

 

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

Answer:

What-if scenario: A specific set of values and conditions used to explore potential outcomes in a spreadsheet.

What-if tool: A feature in LibreOffice that includes tools like Scenario Manager, Goal Seek, and Solver to perform various types of what-if analysis.

Analyse Data using Scenarios and Goal Seek Question Answer Class 10 IT

3. Give any two advantages of data analysis tools.

Answer:

Improved Decision Making: Data analysis tools help users make informed decisions by providing insights and visualizing trends from data.

Time Efficiency: These tools automate complex calculations and data manipulation, saving significant time compared to manual analysis.

Analyse Data using Scenarios and Goal Seek Question Answer Class 10 IT

4. Name any two tools for data analysis.

Answer:

i) Pivot Tables

ii) Solver

 

5. What are the criteria for consolidating sheets?

Answer: The criteria for consolidating sheets typically include having consistent data ranges, identical structure and labels in each range, and ensuring the data types are compatible for aggregation.

 

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

Answer: The Outline tool in LibreOffice Calc is used to create an outline for the selected data, allowing for hierarchical grouping and collapsing/expanding data ranges for better organization and analysis.

 

You May also Check:

Class 10 IT 402 Chapter wise Important Questions

Unit 1: Digital Documentation (Advanced) using LibreOffice Writer

Chapter 1: Introduction to Styles

Chapter 2: Working with Images

Chapter 3: Advanced Features of Writer

 

Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc

Chapter 5: Using Macros in Spreadsheet

Chapter 6: Linking Spreadsheet Data

Chapter 7: Share and Review a Spreadsheet

 

Unit 3: Database Management System using LibreOffice Base

Chapter 8: Introduction to Database Management System

Chapter 9: Starting with LibreOffice Base

Chapter 10: Working with Multiple Tables

Chapter 11: Queries in Base

Chapter 12: Forms and Reports

 

Unit 4: Maintain Healthy, Safe and Secure Working Environment

Chapter 13: Health, Safety and Security at Workplace

Chapter 14: Workplace Quality Measures

Chapter 15: Prevent Accidents and Emergencies

Copywrite © 2020-2024, CBSE Python,
All Rights Reserved