Page 194 - IT 402 v2.0 class 10
P. 194

  If another user is trying to save the shared document while other user is resolving conflicts  a message that
           the shared spreadsheet file is locked due to a merge in progress.  hoose to   ancel  saving or   etry  saving
           later.
         hen a shared spreadsheet is successfully saved  the document shows the latest version of all changes that
        got saved by all users.




            Recap Zone


               ata consolidation refers to collecting and integrating data from multiple worksheets or workbooks
             into a single/master worksheet.

               he Subtotal command is used to automatically create groups and apply inbuilt functions like S M
              O N             etc.  to summarise data.

               hat-if  nalysis is the most powerful feature in spreadsheet that helps to run reverse calculations
             sensitivity analysis and scenarios comparison.

              Scenario is a tool to test  what-if   uestions. Scenario is a set of values that spreadsheet saves and can
             substitute automatically in cells on a worksheet.

               ike scenarios  Multiple Operations is also a planning tool for  what-if   uestions.  nlike Scenario
             Multiple Operations tool does not present the alternative versions in the same cells or with a drop-
             down list.

               oal Seek option reverses the usual order of a formula.
              Solver  is  a  more  descriptive  form  of   oal  Seek.  Solver  can  deal  with  e uations  having  multiple
             unknown variables.
               y default  every workbook contains a sheet named  Sheet   which is managed using tabs at the
             bottom of the spreadsheet.
               hile doing calculations or summarising data in spreadsheet  we often find ourselves in a situation
             to fetch data from other worksheets or even from different workbooks.  his can be done by creating
             Cell Reference.

               yperlink is a reference to a specific location  document or webpage that the user can switch by
             clicking on that link.




         192       Touchpad Information Technology-X
   189   190   191   192   193   194   195   196   197   198   199