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
   193   194   195   196   197   198   199   200   201   202   203