Page 31 - Trackpad_V2.1_Class6
P. 31
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 display
#### Increase the width of the column.
the number.
Change the divisor to a non-zero
#Div/0! Division by zero is an invalid operation.
value.
Check if the data type is the
#VALUE! The formula contains an invalid operation.
same in all the referred cells.
Check if the data is entered in the
#N/A Data is not available.
cell.
The function name is not recognised by Check and correct the function
#NAME?
Excel. name.
#REF! The cell reference is not valid. Check and correct the cell ranges.
Ensure there are no special
The formula or function contains invalid
#NUM! symbols such as $ or % being
numeric values.
used with the number.
Envision your favourite tech personality as a Gizmo Gadget. How would you paint
their portrait in Excel?
21 st
Self Reflection Century #Technology Literacy
Skills
Your mother has been preparing a list of grocery items with their price. She has been manually
Self Reflection
calculating the total amount. Is there any function or formula that can help her make her task
easier? Do you think you should be helping people whenever you see an opportunity?
Hashtag
#Operator: An operator is a symbol that is used to perform calculations
#Function: A predefined formula in Excel
Formulas and Functions in Excel 2016 29

