DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -error when a number is divided by zero (0). It happens when you enter a simple formula like =5/0, or when a formula refers to a cell that has 0 or is blank, as shown in this picture. To correct the error, do any of the following: Make sure the divisor in the function or formula isn’t zero or a blank cell.
Detailed explanation-2: -The reason that the result of a division by zero is undefined is the fact that any attempt at a definition leads to a contradiction. a=r*b. r*0=a.
Detailed explanation-3: -This is because division by zero is not a well-defined operation and it is not possible to assign a meaningful value to it. For example, if you try to divide 6 by 0, you will get an error or undefined result because it is not possible to divide a number by zero.