Please enable JavaScript.

Coggle requires JavaScript to display documents.

electronic spreadsheet - Coggle Diagram

- - - - cell formulae created by users to perform specific calculations
    - - logical functions
      - text functions
      - mathematical funtions
      - date and time fuctions
      - statistical functions
- - - - the relationship between data
- - - - sorting
        
        is a process of
        
        recording the records according
        to a specific criterion
      - filtering
        
        is a function to
        
        select and display the records
        meeting the criteria specified by a
        user
- - - - pivot table
        
        creates
        
        summary tables for a given data table and
        extract useful information from them
      - pivot chart
        
        is
        
        a graphical representation of a pivot table
      - what-if analysis
        
        allows users to
        
        try out different input values in a
        spreadsheet
        
        produce different outcomes for analysis
        
        tools
        
        Scenario Manager
        
        Goal Seek
- - - - absolute cell reference
        
        property
        
        after a cell is copied and pasted
        into another cell, the cell
        reference does not change
      - mixed cell reference
        
        property
        
        After cell is copied and pasted
        into another cell, only part of the
        cell reference changes
      - relative cell reference
        
        property
        
        after a cell is copied and pasted
        into another cell, the cell
        reference changes
- - - - contains
        
        data
        
        formula
      - common formats
        
        date
        
        time
        
        currency
        
        general
        
        fraction
        
        scientific