FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
This error indicates that you used the distance from the formula where you should use the math symptoms. For example, instead of the formula = A1 + A2 + A3, you mistakenly entered the value = A1 + A2 A3. One of the other reasons why this formula is displayed is that you have somewhere in the formula to specify a range between the two cells of the sign.
A
N / A #
B
DIV / 0 #
C
! REF #
D
! NULL #
Explanation: 

Detailed explanation-1: -An invalid cell reference error occurs when a formula contains incorrect cell references. This happens most often when: Individual cells or entire columns or rows containing data referenced in a formula are accidentally deleted.

Detailed explanation-2: -Conclusion. Excel returns #REF error to indicate that the cell reference used in the formula is not valid. It may be because the referred cell, row, or column has been deleted or the range used in the formula is incorrect.

Detailed explanation-3: -Solution: Correct the typo in the syntax and retry the formula. Tip: Instead of manually entering defined names in formulas, you can have Excel do it automatically for you. To do that, go to the Formulas tab, in Defined Names group, click Use in Formula, and then select the defined name you want to add.

Detailed explanation-4: -What are #REF Excel Errors? 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.

There is 1 question to complete.
Previous
Next