# ICT TOPIC 10 - SPREADSHEET SOFTWARE

HideShow resource information
What are labels used for?
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

### Card 3

#### Front

The average function would do what?

### Card 4

#### Front

The sum function would do what?

### Card 5

#### Front

What are the two types of cell referencing?