perform calculations and recalculations automatically, allows results to be displayed in tabular or graphical format, consist of a table divided into rows and columns to produce cells, they consist of a number of worksheets
1 of 7
data formatting
general, number,currency, date, time, percentage
2 of 7
functions
max, min,average,count,sum,if
3 of 7
formulae
additions/subtraction/multiplication and division
4 of 7
absolue cell referencing
the cell reference must remain the same when it is copied
5 of 7
data validation
data validation makes it possible to control the values input into a given cell
6 of 7
macros
a macros is a way to automate a task or procedure which you can 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 future
Comments
No comments have yet been made