• They perform calculations and recalculations automatically
1 of 8
Give examples of data types?
General, number, currency
2 of 8
List the different functions
MIN ,MAX, AVERAGE, COUNT
3 of 8
What are the different types of formulae?
Addition, Subraction, Multiplication and Division
4 of 8
What is an Absolute cell referencing?
It is an 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 refernce unless you change it to an absolute cell reference
5 of 8
What is Data validation? give examples
it ensures that data is present, in the correct range and in the correct format. Length check, typre check, range check, presence checks
6 of 8
What is Maros?
A macro is a way to automate a task or procedure which you perform on a regular basis. 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. A macro is
7 of 8
What is a Vlookup?
The VLOOKUP function takes the value in any particular cell and finds it in the lookup table. The function returns the corresponding value in the next column
Comments
No comments have yet been made