Please enable JavaScript.

Coggle requires JavaScript to display documents.

spreadsheet - Coggle Diagram

- - - - Relative cell reference
        
         Absolute cell reference
        
         Mixed cell reference
  - - - Predefined formula which performs specific
      - calculation with one or more provided
      - arguments.
- - - -  Allow users to create several sets of input values for specific cells, called
      -  Users can __ between scenarios and __ the results in
      - different scenarios easily.
      -  Can generate a __ on the scenarios automatically.
      -  Steps to use the Scenario Manager:
      - Design the model to be used in the scenario.
      - Identify the _ and the target cells that change with the
      - scenario cells.
      - Create scenarios with the Scenario Manager.
      - Switch to one scenario in the Scenario Manager and view the results.
      - Generate a summary report with the summary function in Scenario Manager if
      - necessary.
    - -  An analysis tool to find out how the changes in variables affect the outcome.
      -  Find out the input value of the formula if the desired end result of a formula is
      - known.
      -  Can only work with one changing cell in the ‘__’ cell format.
- - - - Press the function key ‘F2’ and then change the cell content in the cell.
      -  Double-click the cell and then change the cell content in the cell.
      -  Click the Formula Bar and then change the cell content in the Formula Bar.
- - - - Rearrangement of records according to a _
      -  e.g.
      -  Sort the table by the column ‘Class’ so that the records of the same class are listed
      - in groups.
      -  In this case, ‘Class’ is the sort key.
      -  Records can be sorted using __ or __ criteria.
      -  Simple sort using a single criterion
      -  Users can choose any header to be the sort key.
      -  For a new sorting, the original sorting order is overridden.
      -  All records will be reordered according to the new sorting criterion.