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?

Back

Preview of the front of card 3

Card 4

Front

The sum function would do what?

Back

Preview of the front of card 4

Card 5

Front

What are the two types of cell referencing?

Back

Preview of the front of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Spreadsheets and Databases resources »