Page 198 - IT 402 v2.0 class 10
P. 198
Set the cursor in the olumn input cell field and click cell . he figure below shows the worksheet and the
Multiple Operations dialogue.
lick O . Now the profits are listed in column and the annual profit per item ou might want to format
column F to show decimal points for easier comparison of the amounts.
his feature is an important part of hat-if analysis. It is basically used when the output or target value is fixed
and we have to make a change in any one input cell value. oal seek option reverses the usual order of a formula.
It starts with the desired result and it calculates the input accordingly. For example suppose a student has scored
marks in an exam and the passing percentage is . his student wants to increase the marks of the sixth
sub ect to raise the aggregate. ere oal Seek can be used to calculate the minimum marks that the student
should score in the sixth sub ect.
. hen do we use Solver ow is it different from oal Seek
ns: Solver is the descriptive form of oal Seek. It helps with e uations having multiple unknown variables. oal Seek
is used to manipulate one input cell after fixing the target whereas in Solver we can manipulate a set of cells after
knowing the target value. For example suppose a student is aware of the marks scored in four out of six sub ects.
he aggregate percentage this student needs to attain is . ith this as the target value the Solver tool can
help the student determine the minimum marks needed in the other two sub ects to meet the target.
. xplain Solver with the help of example.
ns. he steps to insert a new sheet in alc are as follows:
lick Insert and Select Sheet option. Insert Sheet dialog box appears on the screen.
Select the desired position of the sheet i.e. position after or before the current sheet.
ype the number of worksheets re uired and click the O button.
12. Write the steps to insert a new sheet in Calc.
ns. he steps to insert a new sheet in alc are as follows:
lick Insert and Select Sheet option. Insert Sheet dialog box appears on the screen.
Select the desired position of the sheet i.e. position after or before the current sheet.
ype the number of worksheets re uired and click the O button.
13. Write the steps to rename a sheet in Calc.
ns: he steps to rename a sheet in alc are as follows:
Double click on one of the existing worksheet names.
ename Sheet dialog box appears on the screen.
196 Touchpad Information Technology-X

