Using Excel to Graph a Function Math!（用Excel图表功能数学!）.pdfVIP

Using Excel to Graph a Function 1. Make the x-values. a. Type x in cell A1. b. Type 1 in cell A2 and type 2 in cell A3. c. Select cells A2 and A3 by clicking-and-dragging. Select the “formula drag” point in the lower right corner of the selection and drag this down until you have the values 1 through 15 showing. 2. Make the Column of Function Values a. Type y in cell B1. b. In cell B2 type: =a2^2 and press Enter. We’re starting with the example y = x2. c. Select cell B2 then click the lower right corner and drag the formula down for a