Please enable JavaScript.

Coggle requires JavaScript to display documents.

Ch.7 Spreadsheets - Coggle Diagram

- - - - Press function key F2
      - Double click
      - Click Formulae bar
  - - - Autofill
      - Copy & paste
      - Extending series
- - - - MAX __ maximum value
      - MIN __ minimum value
      - AVERAGE __ average
      - COUNT __ No. of cells with numeric data
      - COUNTIFF __ No. cells satisfying a specific condition
      - LARGE __ Latgest value kth
      - SMALL __ smallest value
      - MODE __ highest frequency appearing
  - - - SUM __ Sum up
      - SUMIF __ Value within range
      - ROUND __ round up no.
      - INT __ -> nearest integer
      - MOD __ X\D
      - POWER __ XD
      - RAND () __ random no. > 0 + < 1
  - - - IF __ --- condition true
      - AND __ 1 + 2
      - OR __ 1 or 2
      - NOT __
      - Mostly TRUE \ FALSE
  - - - CODE __ ASCII Code -> text
      - CHAR __ ASCII Code -> no.
      - LEN __ no. characters (text)
      - LEFT __ leftmost character
      - MID __ characters -- Text
      - RIGHT __ rightmost character
      - TEXT __ text representation of no.
      - VALUE __ numeric value
      - DAY __ data
      - MONTH __ date
      - YEAR __ date
      - WEEKDAY __ data 2
      - TODAY __
      - DATEVALUE __ serial no.
      - TIME __ H:M :S
      - TIME VALUE __ + decimal no.
      - HOUR \ MINUTE \ SECOND __ time
- - - - Constant (raw data)
      - Operator
        
        Arithmetic (+ \ - \ x \ / \ )
        
        Comparison (< \ > \ = )
      - Cell reference (specific cell \ range cells)
      - Function (calculations)
  - - - Calculates relative position -> Locate target cell
    - - Remains unchanged when copied and pasted
      - Identifies cell by adding ($)
- - - - Scenario Manager
        
        Create multiple sets of scenario
        
        Switch between to compare the outcome
        
        Generate Summary reports automatically
        
        Multiple No. cells (OK!)
        
        Need pre-set data for each scenario
      - Goal Seek
        
        find out the changes of the outcome
        
        Input value and result of the formula
        
        Only for Numbers (format)
        
        for 1 cell
        
        Fully automatic -> try possible values the meet the target requriment
      - Pivot Table
        
        Create summary table of set of data
        
        ok with multiple layer
        
        For 2 dimensional comparation
        
        With no. of statistical functions ad filtering feature
        
        Basic structure : Row , column , value , report (all fields)
        
        Comprehensive list for manipulate
        
        Create custom calculation field
        
        X create for each product category
        
        For 2 Cells
        
        pre-set data for each scenario :!:
      - Pivot Chart
        
        Graphical representation of pivot tables