ICT ECDL- Microsoft Excel Flashcards 4.5 / 5 based on 2 ratings ? ICTSpreadsheets and DatabasesGCSEOther Created by: linaaskarCreated 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
Comments
No comments have yet been made