Titles, headings, names and identifying rows or columns
1 of 9
What is a function?
A function is a specialized calculation that the software has memorized
2 of 9
The average function would do what?
Find the average of the numbers in a range of cells
3 of 9
The sum function would do what?
Display the total from a range of cells
4 of 9
What are the two types of cell referencing?
Relative cell referencing and absolute cell referencing
5 of 9
What is relative cell referencing?
When a cell is used in a formula and the formula is copied to make a new address, the cell changes to take account of its new position
6 of 9
What is absolute cell referencing?
A reference to a cell used in formula where, when the formula is copied to a new address, the cell address doesn't change
7 of 9
What are three examples of spreadsheet formatting techniques?
Setting symbols like percentages or currencies - Aligning cells - Text size and font - Borders - Adding colour - Merging cells
8 of 9
What are two benefits of using spreadsheets?
You can perform 'what if' investigations - Automatic recalculation - Accurate calculation - Easy to produce graphs and charts - Can have formulas and functions
9 of 9
Other cards in this set
Card 2
Front
What is a function?
Back
A function is a specialized calculation that the software has memorized
Comments
No comments have yet been made