ICT Spreadsheets

ICT Spreadsheets

1. Cell Reference

   • the name of a cell in a spreadsheet

2. worksheet

   • 1 sheet within a spreadsheet workbook

3. Formula

   • calculation using *, /, -, +

4. Function

   • Complex calculation built into a spreadsheet using words e.g.SUM

5. Conditional Formatting

   • a cell changes colour according to the data entered in it

6. Macro

   • a series of actions recorded as one action usally run using a button

7. cell link

   • a formula that links data in a cell in one worksheet to a cell in another

8. IF Function

   • gives a true or false answer depending on a logical test or comparison between a value in 1 cell and another value

9. VLOOKUP

   • looks at a value in a cell in a range of cells to give an answer from a specified column number in that cell range

10. COUNTIF

    • counts number of cells in a range of cells that contain a specified criteria or value

11. realitive cell referance

    • a cell referance in a formula that will change relative to its position, if the formula is copied to another place in the spreadsheet

12. absolute cell referance

    • a cell referance in a formula that won't change relative to its position, if the formula is copied to another place in the spreadsheet. The $ is used to do this.

13. MAX Function

    • finds the highest value in a range of cells

14. MIN Function

    • finds the lowest value in a range of cells