Flashcards
Spreadsheets by Emily
Cards in this deck (8)
- 1Spreadsheet Software☺☺☺
- 2'What If' investigations are one benefit of using spreadsheets, what are 2 more?Either, automatic re-calculation, accurate calculation, easy to produce graphs and charts
- 3What are the 3 components and what are they used for?1- Labels (titles/headings)
2- Data (text or numbers)
3- Formulas- calculations (+ - x /) - 4What is a function?A specialised calculation that the spreadsheet software has memorised
- 5Name 2 functions-Average
-Sum
-MAX
-MIN - 6What is relative referencing?A relative reference that moves
- 7What is absolute cell referencing?Sticks it to one position
- 8In what ways can data be formatted?-data
-integer ( whole number)
-percentage currency
-text -rotating text
-alignment -cell merging
-text (colour, font face, size)
-border
Information
- Description
- Flashcards on Spreadsheets by Emily, created by Emily Riley on 09/11/2016.
- Created by
- Emily Riley
- Views
- 15
- Rating