the cell address that contains a dollar sign in the row or column coordinate. When you enter a cell reference in a formula, excel assumes it is a relative reference unless you cahnge it to an aboslute reference
4 of 8
Data Validation
Data validation makes it possible to control the values input into a given cell.
5 of 8
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.
6 of 8
What is meant by AVERAGE
The AVERAGE function calculates the average of a group of selected cell values.
7 of 8
What is the function of sum
The SUM function calculates the total of a group of selected cell values.
Comments
No comments have yet been made