Page 74 - Penta Book's ICT Catalogue
P. 74
Common error
messages
Sometimes when you type
a formula, you may make
mistakes. Error messages
appear on your worksheet.
The most common error messages are:
###### This “message” appears when a column with numerical contents is not wide
enough to display all of its content. You can correct it by increasing the width of the
column to fit everything correctly.
#DIV/0! This error message appears when you divide something by 0. You can correct it by
changing the divisor in the function or formula so it is not zero or blank.
#NAME? This error message appears when you have typed a wrong formula and Microsoft
Excel cannot recognize it. You can correct it by typing the formula’s correct name.
In the example above, cell B7 displays this error.
#VALUE! This error appears when a mathematical formula includes cells that contain text as
well as numbers. You can correct it by removing references to cells containing text.
You can correct the mistake by DIGITAL TEENS 2 MODULE 5 Computing and ICT . Sample Pages
clicking the button that appears next
to the cell that displays the message
and choosing Edit in Formula bar.
8
GRADE
hands on!
Type the following table and fill in the cells with the appropriate function.
In cells 14:10, remember to use a function with an absolute reference.
Penta Books 73
