Texas Instruments TI-83 Plus Silver Edition Manual

2/28/02 © 2001 Texas Instruments
TI-83 Plus CellSheet™
Application
Getting Started
Start here
How To…
Enter data Edit data
Create charts Import and export data
Examples
Scatter chart Bar chart
Pie chart Linear regression
Gravity Simple interest
Fibonacci numbers
Slope of secant and tangent lines
More Information
Customer Support Error Recovery
TI

TI-83 Plus CellSheet™ Application Page 2
Important Information
Texas Instruments makes no warranty, either expressed or
implied, including but not limited to any implied warranties of
merchantability and fitness for a particular purpose, regarding
any programs or book materials and makes such materials
available solely on an “as-is” basis.
In no event shall Texas Instruments be liable to anyone for
special, collateral, incidental, or consequential damages in
connection with or arising out of the purchase or use of these
materials, and the sole and exclusive liability of Texas
Instruments, regardless of the form of action, shall not exceed
the purchase price of this item or material. Moreover, Texas
Instruments shall not be liable for any claim of any kind
whatsoever against the use of these materials by any other
party.
Graphing product applications (Apps) are licensed. See the
terms of the license agreement for this product.
Windows, NT, Apple, and Mac are trademarks of their respective owners.

TI-83 Plus CellSheet™ Application Page 3
What is the CellSheet Application?
The CellSheetËapplication combines spreadsheet functionality
with the power of the TI83 Plus. The CellSheet application can
be useful in classes other than math, such as social studies,
business, and science.
Cells can contain:
•Integers
•Real numbers
•Formulas
•Variables
•Text and numeric strings
•Functions
Each spreadsheet contains 999 rows and 26 columns. The
amount of data you can enter is limited only by the available
RAM on your TI83 Plus.

TI-83 Plus CellSheet™ Application Page 4
What You Need
To install and run the application, you need:
•A TI-83 Plus calculator with version 1.13 or higher of the
operating system software to optimize the performance of your
calculator and the application.
-To check the operating system version, press \/,
and then select About. The version number is displayed
below the product name.
-You can download a free copy of the latest operating
system software from education.ti.com/softwareupdates.
Follow the link to Operating Systems.
•A computer with Windows®95/98/2000, Windows NT®, or
Apple®Mac®OS 7.0 or later installed.
•A TI-GRAPH LINK™ computer-to-calculator cable. If you do
not have this cable, call your distributor, or order the cable
from TI's online store.
•TI Connect™ or TI-GRAPH LINK software that is compatible
with the TI83 Plus. You can download a free copy of
TI Connect or TI-GRAPH LINK software from
education.ti.com/softwareupdates. Follow the link to
Connectivity Software.

TI-83 Plus CellSheet™ Application Page 5
Where to Find Installation Instructions
Detailed instructions on installing this and other applications are
available at education.ti.com/guides. Follow the link to Flash
installation instructions.
Getting Help
This application has a built-in help screen that gives you basic
information about using the application. The help screen is
automatically displayed when you start the application.
•To display the help screen from the main spreadsheet
screen, select Menu (press V), and then select Help.
•To exit the help screen and return to the main spreadsheet
screen, press any key.
The instructions in this guidebook are only for this application. If
you need help using the TI83 Plus, refer to its comprehensive
guidebook at education.ti.com/guides.

TI-83 Plus CellSheet™ Application Page 6
Quick Reference Guide
Starting the Application
1. Press
n, and then select CelSheet. The information
screen is displayed.
2. Press any key to continue. The CellSheet™ help screen is
displayed.
Note
By default, the help screen is displayed when you start the
CellSheet application. However, you can turn off this feature.
3. Press any key to continue.
Quitting the Application
•From the main spreadsheet screen, press \.
•From the CELLSHEET MENU, select Quit CellSheet.

TI-83 Plus CellSheet™ Application Page 7
Deleting the Application from Your Calculator
1. Press
\/to display the MEMORY menu.
2. Select
Mem Mgmt/Del.
3. Select
Apps.
4. Move the cursor to CelSheet.
5. Press
^. A confirmation message is displayed.
6. Select
Yes to delete the application.
Completing Tasks
Task
Instructions
Enter a value in a
cell
Enter the value, and then press ¯.
Enter text or a
numeric string in a
cell
1. Press eÉ.
2. Enter the text.
3. Press ¸.

TI-83 Plus CellSheet™ Application Page 8
Task
Instructions
Create a formula
1. Press ¡or ¥.
2. Enter a formula.
3. Press ¯.
Use a variable in a
spreadsheet
1. From the TI83 Plus home screen, store a value
to a variable (for example, 5 §Ù).
2. Start the CellSheet™ application, and open the
spreadsheet file.
3. Move the cursor to a cell and type the variable
(such as X). Do not surround the variable with
quotation marks.
4. Press ¸. The variable's value appears in the
cell.
Tip: You can also use variables in formulas
(e.g., =XhA5) or in cell calculations (e.g., log(X)).
If you change the value of a variable, you must
manually recalculate the spreadsheet.
Navigate rapidly in
a spreadsheet
•Press ehto page down by 6 rows.
•Press e`to page up by 6 rows.
•To jump to a specific cell, select Menu, select
Edit >Go To Cell, and then enter the cell
address.
Note: Press ebefore typing alpha characters.

TI-83 Plus CellSheet™ Application Page 9
Task
Instructions
Switch between the
spreadsheet and a
chart or graph
1. Select Menu, select Charts, and then select the
chart you want to display.
2. To return to the spreadsheet, press \.
Select a range of
cells
1. Move the cursor to the starting cell, and then
press R.
2. Use _, `, a, and has needed to select the
range.
Tip: For a large range, it might be faster to select
Menu, selectEdit >Select Range, and then specify
the range (for example, A6:A105).
Insert a row
1. Press _as needed to select the row.
2. Press 2/to insert a row above the selected
row.
Insert a column
1. Press `or e`as needed to select the
column.
2. Press 2/to insert a column to the left of the
selected column.

TI-83 Plus CellSheet™ Application Page 10
Task
Instructions
Delete a row or
column
1. Move the cursor to the row header or column
header to select the row or column.
2. Press ^.
The columns to the right of the deleted column
shift left.
The rows below a deleted row shift up.
Clear data from a
cell, cell range, row,
or column
1. Select one or more cells, a row, or a column.
2. Press M.