GoConqr has a new look! Let us know what you think.

Mind map

Data handling

MaxG English

Map content

Data handling

  1. Spreadsheets

    • Modelling
      • Goal seek allows the user to see what needs to change in their spreadsheet in order to reach a certain target such as more money. This can be used to see how many more things a company will need to sell in order to get a certain amount of money.
      • If a value on spreadsheet is changed, formulae make sure that the change is updated throughout the rest of the spreadsheet.
    • Formulas and functions
      • Functions such as SUM allow date to be easily entered into a spreadsheet and helps solve the solution quicker and easier.
    • Features such as merging and formatting cells allow the spreadshet to look more proffesional and overall better.
  2. Databases

    • Validation and verification
      • Range check
        • A range check allows you to set boundaries for numbers, for example the cell must have between 10 and 20 characters entered into it.
      • Type check
        • Will check that the correct type of data is being entered into the cell.Like number data.
      • Check digit
        • This will check that a correct amount of digits have been entered, this would be useful in entering barcode information.
      • Length check
        • Make sure all the data has the same number of characters, for example a landline telephone which has 11 characters.
      • Format check
        • The data will consiste of the same pattern, this is useful in entering postcodes.
      • Presence check
        • Checks that something has been entered in the cell. The cell has to have data in it

Information

Description
Mind Map on Data handling, created by MaxG on 19/04/2014.
Created by
MaxG
Views
14
Rating

More on Data Validation and Verification

Feedback

What is it about?

What do you think of the new look?

How do you like it?