Solving equations in Excel
Answers are for parents and teachers.
1
What is D for x² – 4x + 3 = 0 and what are the roots?
D = 4; x = 1 and x = 3
2
Find the meeting point of the lines y = x + 2 and y = –x + 6.
(2; 4)
3
How many days pass from 1 January to 1 March 2026?
59
4
If A1 = a, B1 = b, C1 = c and D1 is the discriminant, write the formula of the first root (D ≥ 0).
=(-B1+SQRT(D1))/(2*A1)
5
What must be changed in the table to find the root more precisely? Write one sentence.
Make the x step smaller in the interval where the sign changes and recalculate the table.