¡GoConqr estrena diseño! Cuéntanos qué te parece.

Mapa mental

Data handling

MaxG Inglés

Contenido del mapa

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

Información

Descripción
Mapa Mental sobre Data handling, creado por MaxG el 19/04/2014.
Creado por
MaxG
Visitas
14
Valoración

Más sobre Data Validation and Verification

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué te parece el nuevo diseño?

¿Te gusta?