DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
This error indicates that you have divided some formulas from zero. The amount of one of the cells you used in your formula may be zero or missing. Excel does not count the cells in the calculation of zero, and if you divide some numbers into them, this error will be displayed.
|
|
*? NAME #
|
|
|
DIV / 0 #
|
|
|
! NUM #
|
|
|
VALUE #
|
Explanation:
Detailed explanation-1: -The #DIV/0! error appears when a formula attempts to divide by zero, or a value equivalent to zero. Like other errors, the #DIV/0! is useful, because it tells you there is something missing or unexpected in a spreadsheet.
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.
There is 1 question to complete.