Class 10 IT Chapter 4 Analyse Data using Scenarios and Goal Seek questions answers

by

Class 10 IT Chapter 4 Analyse Data using Scenarios and Goal Seek questions answers

class 10 IT chapter 4 analyse data using scenarios and goal seek questions asnwers

Dear students here you will get exercise as well as additional questions answers of Class 10 IT Chapter 4 Analyse Data using Scenarios and Goal Seek

Check your progress

A. Multiple Choice Questions

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

(a) Consolidating Data

(b) Goal Seek

(c) Subtotal

(d) Page layout

Ans: (d) Page Layout

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

(a) Writer

(b) Calc

(c) Impress

(d) Draw

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

Ans: (d) Mail Merge

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

(a) .odb

(b) .odt

(c) .odg

(d) .ods

Ans: (d) .ods

5. The default function while using Consolidate is ___________

(a) Average

(b) Sum

(c) Max

(d) Count

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

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

Class 10 IT Chapter 4 Analyse Data using Scenarios and Goal Seek questions answers

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

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 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 analysis

7. What – if analysis tool uses ___________ array of cells, one array contains input values and the second uses the __________

Ans: two, formula

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

Ans: What -if analysis 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. It is useful to check in the beginning to understand from the output for the efficiency. This tool uses two arrays of cells, one array contains the input values and the second array uses the formula and display the result.

(b) What – if analysis

Ans: What -if analysis 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. It is useful to check in the beginning to understand from the output for the efficiency. This tool uses two arrays of cells, one array contains the input values and the second array uses the formula and display the result.

(c) Goal seek

Ans: Goal seek is an useful tool in spreadsheets that helps in finding out the input value needed to achieve a desired output. It allows the user to determine the desired input value for a formula when the output value is already known. It is very helpful in various types of financial analysis.

2. Give one point of difference between

(a) Subtotal and What-if

Ans: Subtotal tool in spreadsheets creates the group automatically and applies common functions like sum, average on the grouped data.

Whereas What – if 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.

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

Ans: What – if Scenario is a set of values that can be used within the calculations in the spreadsheet . A name is given to the scenario and several scenarios can be created on the same sheet.

Whereas What – if is a planning tools 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.

3. Give any two advantages of data analysis tools.

Ans: i. Data analysis can help businesses identify potential problems before they occur, minimizing risks. 

ii. Data analysis can help companies gain a deeper understanding of the market and adapt their strategies accordingly. 

4. Name any two tools for data analysis .

Ans : Microsoft Excel and Libre Office Calc.

5. What are the criteria for consolidating sheets ?

Ans: The criteria for consolidating sheets are-

i. The data types of all the sheets to be consolidated must match.

ii. The labels of all the sheets to be consolidated must match .

iii. The first column should be entered 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: Group and Outline tool in Calc is used to create an outline for the selected data.

Related Posts

  1. Class 10 IT Chapter 1 Introduction to Styles Exercise and additional questions answers.
  2. Class 10 IT 40+ important MCQs of Introduction to Styles
  3. Class 10 IT Chapter 1 Introduction to Styles Online Quizzes/ MCQ Tests
  4. Class 10 IT Chapter 2 Working with images exercise and additional questions answers.
  5. Class 10 IT Chapter 3 Advanced Features of Writer exercise and additional questions answers.
  6. Class 10 IT Employability Skills Unit 1 Communication Skills Important Questions Answers.
  7. Class 10 IT 402 book, Syllabus and Previous Year Question Papers

Leave a Comment