6939113
Descripción
Fichas por Charlotte Adams, actualizado hace más de 1 año
|
|
Creado por Charlotte Adams
hace más de 7 años
|
|
| Pregunta | Respuesta |
| State one benefit of using Spreadsheets | -Spreadsheet can automatically recalculate sums if one cell has changed in value |
| What is the difference between data and information? | -Data- meaningless information e.g. 50 -Information- meaningful e.g. £50 |
| Do spreadsheets store data or information? | -Spreadsheets store the data before it is processed but once it is formatted it turns into information. |
| What is a function? | -A specialised calculation. |
| Give an example of a function | e.g. =SUM (E3:P3) |
| Give 3 examples of ways you can format data in a spreadsheet | 1) Currency 2) Percentage 3)Text |
| Give 2 ways you can format the whole spreadsheet | 1) Cell Merging (putting 2 or more cells together) 2) Borders |
| What are labels? | -Titles and Headings |
| =MAX(A4:H4) What does this formula calculate | -Its calculates the highest (maximum) number within the given cells. |
| Give another advantage of using Spreadsheets | -Easy to produce graphs and charts after all the data has been inputted. |
| What are the 3 functions in a Spreadsheet? | 1) Labels- titles 2) Data- the values 3) Formulas |
| What are formulas used for in a Spreadsheet? | -Formulas are used to perform calculations, used as an easier way of working out answers. |
¿Quieres crear tus propias Fichas gratiscon GoConqr? Más información.