enSCSpreadsheet 'KEY WORDS' - scramble12
Three: There are basically __________ things you can enter in a worksheet cell
Text: __________ can be formatted in a variety of ways, for example you can change its font, size or colour.
Numbers: ________ can be formatted depending on what kind of numbers they are. For example, you can choose the Currency format, which will display a number with a currency symbol in front and two digits after the decimal point. You can also format the appearance of numbers in the same way as you can text.
Formula: A _______ carries out a calculation on numeric values in other cells.
Workbook: _______ is a spreadsheet file, which is made up of a group of worksheets that are saved together in a single file.
Worksheet: _________ is a page of tables used to create a spreadsheet.
Formulae: ___________ is used to carry out calculations in a spreadsheet. This is what make spreadsheets really useful. A formula must begin with an equals sign and can use either actual values, known as numbers, or references to cell addresses.
Value: ______ is a number which can either be a fixed number entered by the spreadsheet’s user or a number that is calculated by a formula.
Cell address: __________is the method used to refer to the contents of a particular cell in a formula. The cell address consists of the column letter and row number of the cell.
Formula bar: ____________ in Excel this is located under the Ribbon and shows the formula of the current cell, if it contains one. The cell itself shows the result of the formula.
Relative cell referencing: _____________a cell address that changes when it is copied to a different cell.
Absolute cell referencing: _____________ a cell address that does not change when you copy it.
Spreadsheet 'KEY WORDS' - scramble
1. ROKEEHSTW
_________ is a page of tables used to create a spreadsheet.
2. LRIEEEUBNCSGTERCEONLFLA
_____________ a cell address that does not change when you copy it.
3. FLOUARM
A _______ carries out a calculation on numeric values in other cells.
4. ERHET
There are basically __________ things you can enter in a worksheet cell
5. TVEREELLRNLIEICNGFCEREA
_____________a cell address that changes when it is copied to a different cell.
6. TXET
__________ can be formatted in a variety of ways, for example you can change its font, size or colour.
7. KWOOOBRK
_______ is a spreadsheet file, which is made up of a group of worksheets that are saved together in a single file.
8. ELUAV
______ is a number which can either be a fixed number entered by the spreadsheet’s user or a number that is calculated by a formula.
9. ERLLCESASDD
__________is the method used to refer to the contents of a particular cell in a formula. The cell address consists of the column letter and row number of the cell.
10. ORLBAFMURA
____________ in Excel this is located under the Ribbon and shows the formula of the current cell, if it contains one. The cell itself shows the result of the formula.
11. MRAULEFO
___________ is used to carry out calculations in a spreadsheet. This is what make spreadsheets really useful. A formula must begin with an equals sign and can use either actual values, known as numbers, or references to cell addresses.
12. BUERMNS
________ can be formatted depending on what kind of numbers they are. For example, you can choose the Currency format, which will display a number with a currency symbol in front and two digits after the decimal point. You can also format the appearance of numbers in the same way as you can text.
_________ is a page of tables used to create a spreadsheet.
W
O
R
K
S
H
E
E
T
2. LRIEEEUBNCSGTERCEONLFLA
_____________ a cell address that does not change when you copy it.
A
B
S
O
L
U
T
E
C
E
L
L
R
E
F
E
R
E
N
C
I
N
G
3. FLOUARM
A _______ carries out a calculation on numeric values in other cells.
F
O
R
M
U
L
A
4. ERHET
There are basically __________ things you can enter in a worksheet cell
T
H
R
E
E
5. TVEREELLRNLIEICNGFCEREA
_____________a cell address that changes when it is copied to a different cell.
R
E
L
A
T
I
V
E
C
E
L
L
R
E
F
E
R
E
N
C
I
N
G
6. TXET
__________ can be formatted in a variety of ways, for example you can change its font, size or colour.
T
E
X
T
7. KWOOOBRK
_______ is a spreadsheet file, which is made up of a group of worksheets that are saved together in a single file.
W
O
R
K
B
O
O
K
8. ELUAV
______ is a number which can either be a fixed number entered by the spreadsheet’s user or a number that is calculated by a formula.
V
A
L
U
E
9. ERLLCESASDD
__________is the method used to refer to the contents of a particular cell in a formula. The cell address consists of the column letter and row number of the cell.
C
E
L
L
A
D
D
R
E
S
S
10. ORLBAFMURA
____________ in Excel this is located under the Ribbon and shows the formula of the current cell, if it contains one. The cell itself shows the result of the formula.
F
O
R
M
U
L
A
B
A
R
11. MRAULEFO
___________ is used to carry out calculations in a spreadsheet. This is what make spreadsheets really useful. A formula must begin with an equals sign and can use either actual values, known as numbers, or references to cell addresses.
F
O
R
M
U
L
A
E
12. BUERMNS
________ can be formatted depending on what kind of numbers they are. For example, you can choose the Currency format, which will display a number with a currency symbol in front and two digits after the decimal point. You can also format the appearance of numbers in the same way as you can text.