1. perform calculations and recalculations automatically 2. allow results to be displayed in tabular or graphical format 3. consist of a table devided into rows and columns to produce cells 4. consist of a number of worksheets
1 of 7
Data formatting/types
Text, number, date, formula, time, percentage, currency
2 of 7
Name the Functions
MAX, MIN, AVERAGE, COUNT, SUM, IF
3 of 7
Name the formulaes
addition, subtraction, multiplication and devision
4 of 7
What is absolute cell referencing?
Is used to ensure the cell reference remains the same when copied
5 of 7
What is Data Validation?
Can be used to control the data entered into a cell
6 of 7
What is Macros?
can be built and used to carry out a particular task in the spreadsheet
7 of 7
Other cards in this set
Card 2
Front
Data formatting/types
Back
Text, number, date, formula, time, percentage, currency
Comments
No comments have yet been made