6939113
Description
Flashcards by Charlotte Adams, updated more than 1 year ago
|
|
Created by Charlotte Adams
over 7 years ago
|
|
| Question | Answer |
| 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. |
Want to create your own Flashcards for free with GoConqr? Learn more.