TI-Nspire For Dummies
Book image
Explore Book Buy On Amazon

You can use relative cell references in the Lists & Spreadsheet application on the IT-Nspire. Here’s how to take the heights of a random group of students and perform a conversion:

  1. Type the heights (in feet and inches) in rows 2 through 5.

  2. Go to cell C1 and press [CTRL][CLICK].

    This action selects the cell and allows copying, as indicated by the dashed box. See the first screen.

  3. Use the

    image0.png

    key to extend the dashed box to cell C5 and press [ENTER].

    See the second and third screens.

    image1.jpg

Notice that cell C5 is highlighted in the third screen and that the formula is located in the entry line at the bottom of the screen. Recall that the original formula typed was =a1*12+b1. The formula has changed to =a5*12+b5. This is because you have used relative cell references.

When you copy a relative cell reference, the cell references automatically update. If you copied this formula to cell F7, it would reference the cells directly to the left of this cell and display the formula =d7*12+f7 on the entry line.

About This Article

This article is from the book:

About the book authors:

Jeff McCalla teaches Algebra 2 and Pre-Calculus at St. Mary's Episcopal School in Memphis. He is a T3 instructor for Texas Instruments and co- founder of the TI-Nspire SuperUser group. Steve Ouellette wrote the first edition of TI-Nspire For Dummies as well as CliffsNotes® Guide to TI-Nspire.

This article can be found in the category: