Page 158 - IT_V1.0_Class10
P. 158
DIFFERENCE BETWEEN GOAL SEEK AND SOLVER
Goal seek determines what values needs to be input in a specific cell to achieve the described result in a
formula cell as it allows varying the value for one cell whereas Solver can solve equations that uses several
variables, so it can be used to determine what values need to be entered in multiple input cells to achieve
the described result.
21 st
Lab Assignment ‘n Activity Century #Technology Literacy
Skills
Complete the following activities and tick the circle.
Consider the sheet as shown below.
Objective is to get Maximum Profit by optimising the Quantity using Solver.
Constraints: Here are a couple of constraints that must be considered while trying to
maximise the profit.
(a) Quantity of Product 'A' should be made at least '90'.
(b) Quantity of Product 'B' should be made at least '30'.
(c) Quantity of Product 'C' should be made at least '20'.
(d) Total Quantity of Products should be made '350'.;
Recap Zone
Data consolidation refers to collecting and integrating data from multiple sheets or spreadsheets
into a single/master sheet.
Group and Outline allows you to organise data by grouping rows or columns, enabling you to
collapse or expand them with a single click.
The Subtotal command is used to automatically create groups and apply inbuilt functions like
SUM, COUNT, AVERAGE, etc., to summarise data.
Scenario is a tool to test ‘what-if’ questions. By adding a Scenario, you can easily view new results for
the arguments of a formula. You can create several scenarios for any given range of cells.
What-If Analysis can be performed by changing the values in cells to see how those changes will
affect the outcome of formulas on the sheet.
Like scenarios, Multiple Operations is also a planning tool for ‘what-if’ questions. Unlike Scenario,
Multiple Operations tool does not present the alternative versions in the same cells or with a
drop-down list.
Goal Seek option reverses the usual order of a formula.
Solver enables you to manipulate a set of cells to achieve a desired output, estimating the minimum
or maximum values for these cells.
156 Information Technology Play (Ver 1.0)-X

