USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
=POWER(C2;2)-4*C1*C3
|
|
=SQRT(C2;2)-4*C1*C3
|
|
=C2*2-4*C1*C3
|
|
CANNOT BE CALCULATED WITH EXCEL FUNCTIONS
|
Detailed explanation-1: -To calculate the discriminant of a quadratic equation, the formula is b2 – 4ac. Substitute the values of a, b and c after reading them from a quadratic equation of the form a2 + b + c. For example, for 2 – 3 + 4, a = 1, b =-3 and c = 4. b2 = 9 and 4ac = 16.
Detailed explanation-2: -The discriminant of the quadratic equation ax2+bx+c=0 is =b2−4ac.
Detailed explanation-3: -The discriminant is the part of the quadratic formula underneath the square root symbol: b²-4ac.
Detailed explanation-4: -If the discriminant is greater than 0, the quadratic equation has 2 real solutions. If the discriminant is equal to 0, the quadratic equation has 1 real solution. If the discriminant is less than 0, the quadratic equation has 0 real solutions.