NCERT solutions Information Technology Class 10 Chapter 4 Analyse Data Using Scenarios and Goal Seek – A comprehensive Guide

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!

If you prefer watching this video instead of reading:

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

[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

[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

[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

[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

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

[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

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.

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

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

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

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

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

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

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

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

C. Fill in the blanks

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

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

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

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

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

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

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

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

D. Answer the following questions

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

[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?

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

.