USING MICROSOFT EXCEL
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: -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.
Detailed explanation-3: -According to Brahmagupta, A positive or negative number when divided by zero is a fraction with the zero as denominator. Zero divided by a negative or positive number is either zero or is expressed as a fraction with zero as numerator and the finite quantity as denominator. Zero divided by zero is zero.