FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
This error occurs when you write the wrong name in the formulas, use the text values ​​used in the formula in the “Do not leave” column or leave the empty parentheses associated with the function.
A
*? NAME #
B
DIV / 0 #
C
! REF #
D
VALUE #
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: -VALUE! Error. The #VALUE! error tells you there’s something wrong with the cells you’re referencing or with the way the formula is typed.

Detailed explanation-3: -ValueError : this error is used to indicate that a variable has the right type but the wrong value. For example, we used it when age was an integer, but the wrong kind of integer.

Detailed explanation-4: -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.

There is 1 question to complete.