They perform calculations and recalculations automaticall They allow results to be displayed in tabular or graphical format. They consist of a table divided into rows and columns to produce cells. They consist of a number of worksheets
1 of 6
List different data types?
Text, Date, Number, Currency
2 of 6
List different data functions?
Max, Min, Average, Count, Sum, If
3 of 6
What is absolute cell referencing?
It is a cell address that contains a dollar sign in the row or column or both when you enter a cell reference in a formula. Excel assumes it is relative reference unless you change it to absolute
4 of 6
What is Data Validation?
Data validation makes it possible to control the values input into a given cell. In the data validation settings dialogue, you can define the data type (whole number) and range check to ensure that the value lies between 0 and 25.
5 of 6
What is Macros?
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.
Comments
No comments have yet been made