Page 30 - trackpad v5.1 class 6 flipbook
P. 30
For example, TODAY() function:
Subject: Use of AutoSum Command
To use the common functions like SUM, AVERAGE,
MAX and MIN, click on the down-arrow under
Formula tab of the AutoSum command.
Type =TODAY()
in the cell.
Press Enter key, the current date appears in the cell.
COMMON ERRORS IN FUNCTIONS
We may get an error while performing calculations using functions. Some common errors are:
Error Meaning Troubleshooting Tip
The column is not wide enough to
#### Increase the width of the column.
display the number.
Division by zero is an invalid Change the divisor to a
#Div/0!
operation. non-zero value.
The formula contains an invalid Check if the data type is the same in all
#VALUE!
operation. the referred cells.
#N/A Data is not available. Check if the data is entered in the cell.
The function name is not
#NAME? Check and correct the function name.
recognised by Excel.
#REF! The cell reference is not valid. Check and correct the cell ranges.
The formula or function contains Ensure there are no special symbols such
#NUM!
invalid numeric values. as $ or % being used with the number.
Envision your favourite tech personality as a Gizmo Gadget. How would you paint
their portrait in Excel?
28 Pro (V5.1)-VI

