DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
This error means that you are referring to the cell in the formulas that are not there. This error usually occurs when you delete cells or, for example, copy the formula that is written in relative terms and refers to cell A3, copy the A4 cell of that cell into another A2 cell.
|
|
*? NAME #
|
|
|
DIV / 0 #
|
|
|
! REF #
|
|
|
VALUE #
|
Explanation:
Detailed explanation-1: -An #REF error (the “ref” stands for reference) is the message Excel displays when a formula references a cell that no longer exists, usually caused by deleting cells that a formula is referring to.
Detailed explanation-2: -The #REF! error shows when a formula refers to a cell that’s not valid. This happens most often when cells that were referenced by formulas get deleted, or pasted over.
Detailed explanation-3: -If you have previously ignored any errors, you can check for those errors again by doing the following: click File > Options > Formulas. For Excel on Mac, click the Excel menu > Preferences > Error Checking. In the Error Checking section, click Reset Ignored Errors > OK.
There is 1 question to complete.