DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To calculate the discriminant of the 2nd degree equation whose coefficients are written in cells a-C1, b-C2, c-C3, the formula is used:
|
|
=POWER(C2;2)-4*C1*C3
|
|
|
=SQRT(C2;2)-4*C1*C3
|
|
|
=C2*2-4*C1*C3
|
|
|
CANNOT BE CALCULATED WITH EXCEL FUNCTIONS
|
Explanation:
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: -For the quadratic equation ax2 + bx + c = 0, the expression b2 – 4ac is called the discriminant.
There is 1 question to complete.