FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -#REF! If formulas located in other cells reference cells in the deleted row or column, Excel displays the error message in those cells to indicate a cell reference error.

Detailed explanation-2: -When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion? Cell references are automatically adjusted.

Detailed explanation-3: -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-4: -These are called “relative” cell references, since they change relative to where you copy the formula. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a “$” before the column letter if you want that to always stay the same.

Detailed explanation-5: -Correct a # error value. If a formula cannot correctly evaluate a result, Excel displays an error value, such as #####, #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!. Each error type has different causes, and different solutions.