Please enable JavaScript.

Coggle requires JavaScript to display documents.

Ch.7 Spreadsheets(Excel) - Coggle Diagram

- - - - create charts
      - organize
      - input
      - perform data analysis
    - - many mathematical operation
      - advanced data analysis
  - - - General
        
        1.05
      - Currency
        
        HK$1.05
      - Date
        
        1/1/1900
      - Time
        
        1:12:00
      - Fraction
        
        1 1/20
      - Scientific
        
        1.05E+00
    - - Copy and paste
      - 2.Extending the series
  - - - Constant
      - Operator
        
        Arithmetic operators
        
        +(addition)
        
        -(subtraction)
        
        *(multiplication)
        
        / (division)
        
        ^ (exponentiation)
        
        % (percent)
        
        Comparison operators
        
        = (equal to)
        
        <> (not equal to)
        
        (greater than)
        
        = (greater than or equal to)
        
        < (less than)
        
        <= (less than or equal to)
      - Cell reference
      - Function
    - - is basic element
        
        Relative cell reference ( e.g. A1 and B5 )
        
        Absolute cell reference(e.g.$A$3 and $F$10)
        
        Mixed cell reference(e.g. $A5 and A$1)
- - - - MAX(<range of cells>)
      - MIN(<range of cells>)
      - AVERAGE(<range of cells>)
      - COUNT(<range of cells>)
      - COUNTIF(<range of cells>,<condition>)
      - LARGE(<range of cells>,k)
      - SMALL(<range of cells>,k)
      - MODE(<range of cells>)
    - - SUM(<range of cells>)
      - SUMIF(<cell range>,<criteria>,<sum range>)
      - ROUND(X,D)
      - INT(X)
      - MOD(X,D)
      - POWER(X,D)
      - RAND()
    - - IF(<condition>,X,Y)
      - AND(<condition1>,<condition2>...)
      - OR(<condition1>,<condition2>...)
      - NOT(<condition>)
    - - CODE(<text>)
      - CHAR(<number>)
      - LEN(<text>)
      - LEFT(<text>,N)
      - MID(<text>,S,N)
      - RIGHT(<text>,N)
      - TEXT(<number>,X)
      - VALUE(<text>)
    - - DAY(<date>)
      - MONTH(<date>)
      - YEAR(<date>)
      - WEEKDAY(<date>)
      - TODAY()
      - DATEVALUE(<text>)
      - TIME(H: M :S)
      - TIMEVALUE(<text>)
      - HOUR(<time>)
      - MINUTE(<time>)
      - SECOND(<time>)
  - - - Column chart,/Bar chart
      - Line chart
      - Pie chart
      - Scatter chart
      - Stock chart
- - - - Record
      - Field
      - Table header
      - Record
    - - simple sort using a single criteria
      - sorting records using multiple criteria
  - - - Goal seek
      - Scenario Manager
    - - Pivot table
      - Pivot chart
- - - - One input cell. (=0)
    - - Two input cell (need pre-set)
    - - Three input cell 以上(need pre-set)