ICT ECDL- Microsoft Excel Flashcards

?
  • Created by: linaaskar
  • Created on: 29-02-16 14:41
What does the error message #DIV/0! mean?
Excel displays the #DIV/0! error when a formula tries to divide a number by 0 or an empty cell.
1 of 7
What does #REF! error message mean?
Excel displays the #REF! error when a formula refers to a cell that is not valid.
2 of 7
What does the #NAME? error message mean?
The #NAME? error occurs when Excel does not recognize text in a formula.
3 of 7
What does the #VALUE! error message mean?
Excel displays the #VALUE! error when a formula has the wrong type of argument.
4 of 7
What does the #### error message mean?
This is displayed when the column is not wide enough to display all the information in the cell.
5 of 7
What are two alternatives to using simple addition in a formula?
You can use the SUM formula or use Autosum instead, which are much more efficient.
6 of 7
Besides the bottom right of the page, where else could you change the zoom of the page?
The View ribbon, then select Zoom.
7 of 7

Other cards in this set

Card 2

Front

What does #REF! error message mean?

Back

Excel displays the #REF! error when a formula refers to a cell that is not valid.

Card 3

Front

What does the #NAME? error message mean?

Back

Preview of the front of card 3

Card 4

Front

What does the #VALUE! error message mean?

Back

Preview of the front of card 4

Card 5

Front

What does the #### error message mean?

Back

Preview of the front of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Spreadsheets and Databases resources »