1:00
en
MA
Matching Spreadsheet KEY WORDS
12
Three: How many things you can enter in a worksheet cell?
Text: This can be formatted in a variety of ways, for example you can change its font, size or colour.
Numbers: This can be formatted. For example, you can choose the Currency format, with or without two digits after the decimal point. You can also format the appearance in the same way as you can text.
Formula: This carries out calculations 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: This 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: This 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: Is a cell address that changes when it is copied to a different cell.
Absolute cell referencing: Is a cell address that does not change when you copy it.
Matching Spreadsheet KEY WORDS
1. | Is a cell address that does not change when you copy it. | A. | Value |
2. | This 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. | B. | Numbers |
3. | This carries out calculations on numeric values in other cells. | C. | Cell address |
4. | 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. | D. | Absolute cell referencing |
5. | 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. | E. | Formula |
6. | This can be formatted. For example, you can choose the Currency format, with or without two digits after the decimal point. You can also format the appearance in the same way as you can text. | F. | Workbook |
7. | Is a cell address that changes when it is copied to a different cell. | G. | Text |
8. | This can be formatted in a variety of ways, for example you can change its font, size or colour. | H. | Worksheet |
9. | How many things you can enter in a worksheet cell? | I. | Three |
10. | This 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. | J. | Relative cell referencing |
11. | is a spreadsheet file, which is made up of a group of worksheets that are saved together in a single file. | K. | Formula bar |
12. | is a page of tables used to create a spreadsheet. | L. | Formulae |
© 2015
PuzzleFast.com, Noncommercial Use Only
Matching Spreadsheet KEY WORDS
1. | Is a cell address that does not change when you copy it. → D |
2. | This 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 |
3. | This carries out calculations on numeric values in other cells. → E |
4. | 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. → K |
5. | 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. → L |
6. | This can be formatted. For example, you can choose the Currency format, with or without two digits after the decimal point. You can also format the appearance in the same way as you can text. → B |
7. | Is a cell address that changes when it is copied to a different cell. → J |
8. | This can be formatted in a variety of ways, for example you can change its font, size or colour. → G |
9. | How many things you can enter in a worksheet cell? → I |
10. | This 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. → A |
11. | is a spreadsheet file, which is made up of a group of worksheets that are saved together in a single file. → F |
12. | is a page of tables used to create a spreadsheet. → H |
© 2015
PuzzleFast.com, Noncommercial Use Only