 |
| Navigation Links |
 Step
3 |
| Working
Smarter |
| Absolute Cell Reference |
| Error Messages |
| IF statements |
| Charts |
| Database and quiz |
| Text Version |
Welcome to Excelling with Excel
Working Smarter
Understanding
Excel's error messages and a look a the right click
Look at the following error messages - they
will help you in understanding where you may be having problems with Excel.
Excel gives these error messages when something is not quite right
Usually they appear after you have done an AutoFill or if you used a relative
cell reference when you should have used an absolute cell reference.
Knowing what these messages mean can help you rework Excel so there are
no error messages
| #N/A | stands for no value is available |
| #NAME | Excel cannot recognize a name. It may be that the name was misspelled or a colon was omitted when defining a range (A10A33) |
| #NUM | indicates a problem with a number |
| #REF | displays when reference is made to an invalid cell |
| #VALUE | displays when the wrong type of formula is entered |
| #DIV/0 | displays when a value is divided by zero |
A look at the right click
Using a
right click on cell opens a pop-up menu where you can select various options
of what you would like to do. If you select copy, the cell will be copied.
Then if you right click on another cell you can paste the data from that
cell into a new cell by right clicking and selecting paste.
POWER USERS use the right click.
Diagram:
You are now ready to look at IF statements.
They are great fun!