Creating a spreadsheet with X-Y data.

Steps

  1. Put titles x and y into cells B1 and C1.

  2. In cell B2, enter your first value of x.

  3. In cell B3, enter the formula =B2+1.

    You may use another increment instead of 1.

  4. Click on cell B3 and holding down the mouse button, drag the mouse to cell B22 (or so). You have highlighted cells B3 through B22.

  5. From the Calculate menu select Fill Down. Let the machine do the work.

  6. In cell C2, enter your formula, such as =B2^2. The ^ above the 6 on your keyboard means "raise to the power."

  7. Highlight cells C2 through C22 and use Fill Down again.

Cool hint: absolute reference

  1. In cell A1 enter a value you'd like to use for your increment.

  2. Change to formula in cell B3 to =B2+$A$1

  3. Highlight cells B2 down to B22 (or wherever).

  4. Use the Fill Down command from the Calculate menu.

    The reference $A$1 is absolute. Look at the other cells in column B.

  5. Now, by changing the value in cell A1, you can change the increment for your function.

Return to Graphing

Return to main Mathematics and... page.