• They perform calculations and recalculations automatically
1 of 8
Give 3 examples of Data types
General, Number and Currency
2 of 8
List the different functions
MAX, MIN, AVERAGE, COUNT, SUM, IF
3 of 8
What is the MAX function?
The MAX function finds the largest value stored in a group of cells. Eg =MAX(C3:C8)
4 of 8
What is the MIN function?
The MIN function finds the smallest value stored in a group of cells. Eg =MIN(C3:C8)
5 of 8
What is absolute cell reference?
An absolute cell reference is a cell address that contains a dollar sign ($) in the row or column coordinate, or both. When you enter a cell reference in a formula, Excel assumes it is a relative reference unless you change it to an absolute referenc
6 of 8
What does Data Validation do?
Data validation makes it possible to control the values input into a given cell.
7 of 8
What is a macro?
A macro is a set of instructions and/or actions that can be recorded or saved and then set to run whenever you need to perform the task in the future. EG. Producing a graphfrom a table of data.
Comments
No comments have yet been made