Page 174 - IT 402 v2.0 class 10
P. 174
Lab Assignment ‘n Activity S ub j e ct E nr ich me nt
Complete the following activities and tick on the circle.
t the end of the course a student participates in exams. he passing score is 5 . ll
the exams have the same weightage so the overall score is calculated by average of their
scores. he student has already given out of exams and secured . pply oal Seek
method to find what score does the student re uire in the third exam to pass the entire
course.
SOLVER
Solver is a more descriptive form of oal Seek. Solver can deal with e uations having multiple unknown
variables. oal Seek is used to manipulate one input cell after the outcome or target is fixed. In Solver we can
manipulate a set of cells after knowing the output and can estimate the minimum or maximum value that can
be entered into those cells. It is specifically designed to minimise or maximise the result according to a set of
limiting rules defined by the user. ach of these rules sets up whether an argument in the formula should be
greater than lesser than or e ual to the entered value. If the argument need not to be changed set the rule
so that the argument in the cell is e ual to its current entry.
et us take an example suppose a student wants to achieve . e can change the values of two sub ects
to achieve the target. ere we need to set the limiting condition as marks of omputer sub ect must be
greater than the Science sub ect.
Step 1: lace the cursor in the formula cell i.e. .
Step 2: Click on ‘Tools’ menu.
Step 3: Select Solver option. Solver dialog box appears on the screen.
2
3
1
Step 4: Set the result to 80.
Step 5: Select the cells whose value can be changed. ere and .
172 Touchpad Information Technology-X

