NCERT Solutions Information Technology Class 10 Chapter 4 Analyse Data Using Scenarios And Goal Seek – A Comprehensive Guide | TutorialAICSIP

In this article, I will provide NCERT solutions Information Technology Class 10 Chapter 4 Analyse Data Using Scenarios and Goal Seek. Let us begin!

NCERT solutions Information Technology Class 10 Chapter 4 Analyse Data Using Scenarios and Goal Seek

Lets begin NCERT solutions Information Technology Class 10 Chapter 4 Analyse Data Using Scenarios and Goal Seek. Here we go!

A. Multiple Choice Questions

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

Ans. (d) Page Layout
Consolidating data, Goal Seek and Page layout are used for data analysis

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

[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

Ans. (d) Mail Merge
Mail merge can be performed using LibreOffice writer, LibreOffice calc can be used to save the data source.

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

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

Ans. (b) Sum
The default function is Sum

[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

Ans. (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) Find and Replace

Ans. (b) What-if Scenario
(a) Consolidate Function: Combine data from two spreadsheets and return result into another spreadsheet
(b) What-if scenario: Tests what-if questions
(c) Goal Seek: Predict the output while changing the input
(d) Find and replace: Search and replace a word

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

Ans. (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

Ans. (b)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.

Ans. True

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

Ans. False

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

Ans. True

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

Ans. False

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

Ans. False

[6] Only one scenario can be created for one sheet.

Ans. False

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

Ans. False

[8] Goal seek analysis tool is used while calculating the output depending on the input.

Ans. False

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

Ans. False

C. Fill in the blanks

[1] Consolidate function is used to combine information from multiple sheets to ___________ the information.

Ans. summarize

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

Ans. consolidate Function

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

Ans. Consolidate

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

Ans. Subtotal

[5] _______________ scenario is used to explore and compare various alternatives depending on changing conditions.

Ans. What-if

[6] _____________ is a planning tool for what-if questions.

Ans. What-if Tool

[7] What-if analysis tool uses ____________________ array of cells, one array contains input values and the second uses the _________________.

Ans. two, formula/output

[8] __________________ helps in finding out the input for the specific output.

Ans. Goal Seek

D. Answer the following questions

[1] Define the terms
(a) Consolidate function
(b) What-if analysis
(c) Goal seek

Ans.
(a) Consolidate Function: It is used to combine information from multiple sheets of the spreadsheet into one place to summarize the information. It is used to view and compare variety of data in a single spreadsheet for identifying trends and relationships.
(b) What-if analysis: What-if analysis is is planning tool for what-if questions. It is useful to check in the beginning to understand
from the output for the efficiency.
(c) Goal Seek: Goal seek helps in finding out the input for the specific output. For example, if you want to know the number of units produced to get the desired output then use Goal seek analysis tool.

[2] Give one point of difference between
(a) Subtotal and What-if
(b) What-if scenario and What-if tool

(a) Subtotal and What-if

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

[3] Give any two advantages of data analysis tools:

[4] Name any two tools for data analysis.

[5] What are the criteria for consolidating sheets?

Ans.: Criteria for consolidating sheets are as follows:
• Each sheet in the spreadsheet must match the data types
• Match the labels from all the sheets which are used for consolidating
• Enter the first column as the primary column on the basis of which the data is to be consolidated

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

Ans.: The subtotal command is used to create an outline for selected data

Related