FUNDAMENTALS OF COMPUTER

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.