Please enable JavaScript.

Coggle requires JavaScript to display documents.

Year 9 Computing (SSM (Formulae and Functions (Formatting Tools (Change…

- - - - e.g. =C12*0.55
    - - e.g. $B$4
    - - Change font properties
      - Change alignment and number format of cells
      - Merge and centre cells
      - Add a graphic
    - - =IF(Condition,value if true,value if false)
        
        e.g. =IF(E7=MAX_Profit,"Maximum Profit","")
    - - Sort A-Z
        
        Ascending Order
      - Sort Z-A
        
        Descending Order
    - - Types of Validation
        
        Range Check
        
        Type Check
        
        Length Check
        
        Format Check
        
        Presence Check
      - COUNTIF (range, "A")
        
        Means to count the number of cells that contain A or anything else
    - - Examples of Charts
        
        Line Chart
        
        Bar Chart
        
        Pie Chart
      - How to create a chart
        
        1) Select data needed
        2) Insert -> Chart
        3) Select your chart
        4) Add the labels and customise it to you liking
- - - - .mp4
      - .mov
      - .wmv
    - - .wav
      - .mp3
      - .aac
      - .wma
    - - .jpg
    - - .doc
    - - .xls
- - - - Holds alphanumeric data as text
      - str()
    - - Holds whole numbers
      - int()
    - - Holds number with a decimal point
      - float()
    - - True or False
      - bool()