Please enable JavaScript.

Coggle requires JavaScript to display documents.

LO6 revision - Coggle Diagram

- - - - It organises the data bse and makes it easy to access data
      - A lot of data values of the same type in a table.
    - - Collection of fields about the same object within a databse
      - Make it easier to access the objects data , as they are together
  - - - checks to see if the data's length is suitable against the specified augments
    - - checks to see if data has been entered into the cell
    - - checks to see if data is in a list of values
- - - - Adds all the values in the selected range
      - similar to '+' but uses a range .e.g. =SUM(B5:B7)
    - - finds the relevant data from the referenced table using an input
    - - checks to see if the statement specified is true or false and outputs depending on the result
    - - addition, subtraction, division, multiplication
    - - It is a function that makes Excel search for a certain value in a row (the so called 'table array'), in order to return a value from a different row in the same column.