Copying and graphs
Answers are for parents and teachers.
1
If A3 = 4 and B1 = 3, what does =$A3^B$1 give?
64
2
Find the value of y = 2x + 1 at x = –2.
-3
3
If the value of x is in cell A2, write the formula that calculates y = 3x² – 6.
=3*A2^2-6
4
List in order the steps of drawing the graph of a function in Excel.
1) table of x values; 2) the y formula and copying; 3) select both rows; 4) Insert – Scatter – Smooth Lines; 5) add the titles.
5
What does =SIN(RADIANS(90)) give?
1