USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
#NULL!
|
|
|
#DIV/0!
|
|
|
#N/A
|
|
|
#REF!
|
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: -Usually the CELL REFERENCES will CHANGE! If you copy a formula 2 rows to the right, then the cell references in the formula will shift 2 cells to the right. If you copy a formula 3 rows down and 1 row left, then the cell references in the formula will shift 3 rows down and 1 row left.
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.