Your extra credit assignment is to create a spreadsheet similar to m100qestudio.xls (the spreadsheet for studio 3), but where the sliders control the parameters of a quadratic in the form y = ax² + bx + c. Click here to get instructions on creating sliders in Excel. You can also look at m100qestudios07.xls for ideas. Note that this isn't just (or even mainly) a test of how well you understand spreadsheets. You will find you need to solve a number of linear equations and work with the quadratic formula to finish this assignment.

1. You will need to create 3 sliders, one for each parameter a, b and c. The sliders produce unsigned integers and so after linking the sliders to specific cells, you will then need to create a formula in another cell to convert these integer values to the desired range of values (as discussed in the instructions for making a slider). In particular:
   • The slider for a should create values from -4 to 4 with small steps of 0.1 and large steps of 0.5.
   • The slider for b should create values from -10 to 10 with small steps of 0.1 and large steps of 1.
   • The slider for c should create values from -16 to 16 with small steps of 0.2 and large steps of 2.
   You can look at the sliders in m100qestudios07.xls, which are linked to cells A1, B1, and C1, with the final values for coefficients computed in cells A3, B3, and C3 for an example of what is needed here (but with different numbers).
2. Create an unchanging table of x values from -10 to 10 in steps of 0.1 and a corresponding table of y values computed by y = ax² + bx + c which will change as the sliders change the values of a, b, and c. This corresponds to the range from A7 to B208 in m100qestudios07.xls.
3. Build an XY graph of these values. It will look smoother if you don't include marks at the points and if after creating the graph you right-click on the X and Y axes and fix the scale with a min of -10 and a max of 10 so the scale doesn't keep resizing as you move the sliders about.
4. Finally, use the quadratic formula and compute the two zeros of the quadratic function in a pair of cells below the graph, as in cells H42 and I42 in m100qestudios07.xls.