Y9 Spreadsheets

3. an Excel file that contains one or more worksheets
5. an instruction that checks any condition, if the condition is found to be TRUE then it returns a predefined value however if the condition is False, it returns a different predefined value.
7. enables you to highlight cells with a certain colour, depending on the cell's value.
10. Allows you to fill cells with data that follows a pattern or that is based on data in other cells.
11. Joins multiple cells together to form a single cell
13. The currently selected cell
15. a space created on the spreadsheet / worksheet where a row and column meet
16. A cell reference is the name of the cell that is found by combining the Column Letter with the Row Number. For example the cell in Column "C" in Row "3" would be cell C3.
17. Lines that surround cells

1. a single spreadsheet that contains cells organized by rows and columns
2. Cells that run across the worksheet
4. a graphical representation of numeric data
6. An absolute cell reference is one that does not change when it is copied.
8. built:in formulas that are used to enter either commonly used or very complex formulas. E.g. =MAX(A2:A5)
9. Cells that run down the worksheet
12. the label for a cell made up of the column identifier and the row identifier.
14. A formula is a mathematical equation or set of commands used to generate a specific result or value. Formula may include functions, cell references, ranges, numbers and mathematical operators.