Mapa mental
Data handling
Contenido del mapa
Data handling
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.
- Modelling
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
- Range check
- Validation and verification
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