Spreadsheets Revision Resource

?
  • Created by: notae003
  • Created on: 12-05-14 10:29
What is a workbook?
An application that can store all its data in a single file.
1 of 26
What does a workbook contain?
Worksheets
2 of 26
What is a worksheet?
A single tab in the spreadsheet workbook
3 of 26
What does a cell reference start and end with?
A letter and a number
4 of 26
What is a range of cells?
A set of cells in a row or column
5 of 26
What is a label?
Any text in a cell describing the data in a row/column e.g titles
6 of 26
What is data?
Any values (text/numbers) that are entered for the use of calculation
7 of 26
What are formulas/functions?
Mathematical calculations carried out automatically
8 of 26
Name the four operators for formulas
+ Add, - Subtract, * Multiply and / Divide
9 of 26
What must formulas/functions start with?
An equals sign (=)
10 of 26
What do formulas/functions perform calculations on?
Cell contents
11 of 26
Where do formulas/functions appear?
In the formula bar
12 of 26
What are functions (specific definition)?
Specialised calculations built into the spreadsheet software
13 of 26
Give three examples of different functions
SUM, AVERAGE, IF, COUNT, MIN/MAX, COUNTIF, WHATIF
14 of 26
What is relative cell reference?
When a cell is used in a formula and the formula is copied to a new cell reference and changes to take account of the formula's new position
15 of 26
What is absolute cell referencing?
Where a reference to a cell used in a formula where, when the formula is copied to a new cell reference, the cell reference doesn't change
16 of 26
Benefits of using a spreadsheet are...
Auto-recalculation, accurate calculations, graphs/charts, replication etc.
17 of 26
What is the active cell?
The cell that is currently in use - it is featured in the name box
18 of 26
What is automatic recalculation?
Every time the content of a cell changes, calculations are performed and other cells are updated if necessary
19 of 26
Give three examples of different graphs/charts
Bar charts, pie charts and line graphs
20 of 26
Why are graphs/charts used in spreadsheets?
They allow us to notice patterns/trends more easily
21 of 26
Why are bar charts used in spreadsheets?
To compare values
22 of 26
What are pie charts used in spreadsheets?
To show how a total is divided among a number of different categories
23 of 26
Why are line graphs used in spreadsheets?
To display trends
24 of 26
Give 6 different ways that a cell can be formatted
Font style, size, colour, border style, alignment, cell colour
25 of 26
Why are 'what if' calculations used?
To allow us to use a spreadsheet to see what would happen if certain figures changed in the spreadsheet
26 of 26

Other cards in this set

Card 2

Front

What does a workbook contain?

Back

Worksheets

Card 3

Front

What is a worksheet?

Back

Preview of the front of card 3

Card 4

Front

What does a cell reference start and end with?

Back

Preview of the front of card 4

Card 5

Front

What is a range of cells?

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 »