TI-83 Plus CellSheet™
TI
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 Infor m a t ion
Customer Support Error Recovery
2/28/02 © 2001 Texas Instruments
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 2
What is the CellSheet Application?
The CellSheetËapplication combines spreadsheet functionality
with the power of the TI83 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 TI83 Plus.
TI-83 Plus CellSheet™ Application Page 3
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
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.
.
. The version number is displayed
\ /
,
.
A computer with Windows
•
Apple
A TI-GRAPH LINK™ computer-to-calculator cable. If you do
•
®
Mac®OS 7.0 or later installed.
®
95/98/2000, Windows NT®, or
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 TI83 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 4
Where to Find Installation Instructions
Detailed instructions on installing this and other applications are
available at education.ti.com/guides
installation instructions.
. Follow the link to Flash
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
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 TI83 Plus, refer to its comprehensive
guidebook at education.ti.com/guides
Menu
(press
V
), and then select
.
Help
.
TI-83 Plus CellSheet™ Application Page 5
Quick Reference Guide
Note
By default, the help screen is displayed when you start the
CellSheet application. However, you can turn off this feature.
Starting the Application
1. Press
, and then select
n
CelSheet
screen is displayed.
2. Press any key to continue. The CellSheet™ help screen is
displayed.
3. Press any key to continue.
Quitting the Application
From the main spreadsheet screen, press
•
From the
•
CELLSHEET MENU
, select
. The information
\
Quit CellSheet
.
.
TI-83 Plus CellSheet™ Application Page 6
Deleting the Application from Your Calculator
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
¸
.
1. Press
2. Select
3. Select
\ /
Mem Mgmt/Del
.
Apps
4. Move the cursor to
5. Press
6. Select
. A confirmation message is displayed.
^
to delete the application.
Yes
Completing Tasks
to display the MEMORY menu.
.
.
CelSheet
TI-83 Plus CellSheet™ Application Page 7
Task
Instructions
Create a formula
1. Press
¡
or ¥.
2. Enter a formula.
3. Press
¯
.
Use a variable in a
spreadsheet
1. From the TI83 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., =
X
h
A5) 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
e h
to 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
e
before typing alpha characters.
TI-83 Plus CellSheet™ Application Page 8
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
, select
Edit > 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 9
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
.
TI-83 Plus CellSheet™ Application Page 10
Task
Instructions
Cut, copy, and
paste
To cut or copy a cell:
1. Move the cursor to the cell.
2. Press
S
to cut the cell.
—or—
Press
T
to copy the cell.
To cut or copy a range of cells:
1. Move the cursor to the first cell in the range.
2. Press R.
3. Move the cursor to the last cell in the range.
4. Select
Cut
(press
S
) to cut the cell range.
—or—
Select
Copy
(press
T
) to copy the cell range.
To paste:
1. Cut or copy one or more cells.
2. Move the cursor to the new cell (or the first cell of
a new cell range).
3.
Select
Paste
(press
U
).
TI-83 Plus CellSheet™ Application Page 11
Task
Instructions
Grab cell reference
1. While entering or editing a formula, place the
cursor on the edit line where you want to enter a
cell reference.
2. Press
n
.
3. Use the arrow keys to move the cursor to the cell
that contains the formula or value that you want
to copy.
4. Press
¯
. The address of the cell you
referenced appears on the edit line (where you
placed the cursor in step 1) and is now part of the
current formula.
Grab range
reference
1. While entering or editing a formula, place the
cursor on the edit line where you want to enter a
range reference.
2. Press
n
.
3. Use the arrow keys to move the cursor to the first
cell in the range that you want to copy.
4. Press R, and then move the cursor to the last
cell in the range that you want to copy.
5. Press
¯
. The cell range that you referenced
appears on the edit line (where you placed the
cursor in step 1) and is now part of the current
formula.
TI-83 Plus CellSheet™ Application Page 12
CellSheet Main Menu
Menu Item
Description
1: Open
Opens an existing spreadsheet file.
2: Save As
Saves the current spreadsheet with a different name.
3: New
Creates a new spreadsheet and lets you enter a unique
name.
4: Delete
Deletes a spreadsheet. You cannot delete the currently
open spreadsheet.
To display the
•
To display a help screen for common tasks, select
•
the
CELLSHEET MENU
To exit the application, select
•
CELLSHEET MENU
•
Press
-
-
s
Return to the main menu from a submenu
Return to the spreadsheet from the main menu
CELLSHEET MENU,
.
.
or
\
to
select
Quit CellSheet
File Menu
Menu
(press
V
Help
from the
).
from
TI-83 Plus CellSheet™ Application Page 13
Menu Item
Description
5: Format
Lets you set up formatting options such as automatic
recalculation, cursor movement, help screen display, and
edit line display.
6: Recalc
Recalculates the spreadsheet (only needed when the
autocalculation feature in the Format menu is turned off)
Menu Item
Description
1: Go To Cell
Moves the cursor to a specific cell.
2: Undelete Cell
Retrieves the contents of the cell that you just deleted or
cleared.
3: Clear Sheet
Deletes all data from the current spreadsheet.
4: Select Range
Selects a range of cells.
5: Cut
Cuts the contents and formulas from the currently selected
cell or range of cells and places them on the clipboard.
(Shortcut key:
S
)
6: Copy
Copies the contents and formulas from the currently
selected cell or range of cells and places them on the
clipboard. (Shortcut key:
T
)
7: Paste
Pastes the contents and formulas that were just cut or
copied to the clipboard into the current cell. (Shortcut key:
U
)
Edit Menu
TI-83 Plus CellSheet™ Application Page 14
Options Menu
Menu Item
Description
1: Statistics
Calculates 1-variable statistics, 2-variable statistics, or
linear regression for the currently selected cell range.
2: Fill Range
Fills a range of cells with a formula, number, or text.
3: Sequence
Fills a range of cells with a sequence of numbers.
4: Import/Export
Imports lists or matrices, or variables; exports lists,
matrices, or variables.
5: Sort
Sorts a range of cells in ascending or descending order.
6: Col Decimal
Sets the decimal mode display for a column. The calculator
decimal mode display (accessed by pressing
]
) does
not affect the CellSheet™ application.
TI-83 Plus CellSheet™ Application Page 15
Charts Menu
Menu Item
Description
1: Scatter
Displays a scatter chart for a range of cells.
2: Scatter Window
Displays the parameters for the viewing window for the
scatter chart so that you can change the values.
3: Line
Displays a line chart for a range of cells.
4: Line Window
Displays the parameters for the viewing window for the line
chart so that you can change the values.
5: Bar
Displays a bar chart for a range of cells.
6: Bar Window
Displays the parameters for the viewing window for the bar
chart so that you can change the values.
7: Pie
Displays a pie chart for a range of cells.
TI-83 Plus CellSheet™ Application Page 16
Starting and Quitting the Application
Note
By default, the help screen is displayed when you start the
CellSheet™ application. However, you can turn off this feature.
Starting the Application
1. Press
n
to display the list of applications on your
calculator.
2. Select
CelSheet
. The information screen is displayed.
3. Press any key to continue. The help screen is displayed.
4. Press any key to continue. A blank spreadsheet (or the last
spreadsheet that you opened) displays, and cell A1 is
selected.
The first four characters of the spreadsheet's name appear
in the upper left corner of the spreadsheet. You can press
_ `
to highlight the name cell and view the full name on the
edit line.
TI-83 Plus CellSheet™ Application Page 17
Quitting the Application
•
Press
\
from the main spreadsheet screen.
—or—
Select
•
screen, and then select
Menu
(press
V
) from the main spreadsheet
Quit CellSheet
.
Getting Started
Work through the following example to get acquainted with the
main features of the CellSheet™ application.
Example–
purchase a $1500 item. QuickCash charges 1.5 percent
interest that is compounded monthly. The required minimum
monthly payment is 3 percent of the balance. Assuming that
Margaret makes the minimum monthly payment, how much
interest and principal will she have paid in six months?
Start the CellSheet application.
Margaret used her QuickCash credit card to
1. Press
n
to display the list of applications on your
calculator.
TI-83 Plus CellSheet™ Application Page 18
2. Select
Note
If the last spreadsheet that you opened is displayed, create a
new spreadsheet file. To do this, select
Menu
(press
V
),
select
File> New
, enter a name for the spreadsheet, and then
press
¯
two times.
Tip
•
To indicate that an entry is a text string, press
e
["].
•
To turn on alpha-lock mode, press
\
.
•
To complete an entry, press
¯
.
CelSheet
. The information screen is displayed.
3. Press any key to continue. The help screen is displayed.
4. Press any key to continue. A blank spreadsheet (or the last
spreadsheet that you opened) is displayed.
Enter these column headings:
= principal
P
= interest accrued
I
= minimum monthly payment
PMT
1. With the cursor in cell A1, enter the principal column
heading,
(
\
P
["]
¯
P
).
2. Move the cursor to cell B1, and enter the interest accrued
column heading,
TI-83 Plus CellSheet™ Application Page 19
(
\
I
["]
¯
I
).
3. Move the cursor to cell C1, and enter the minimum monthly
Note
To indicate that an entry is a formula, press
¡
to place an
equal sign on the edit line.
payment column heading,
Your spreadsheet should look like this:
Enter the initial data for the spreadsheet in cells A2, B2, and
C2.
P = 1500
I = P
4
.015
PMT = P 4.03
PMT
(
\
["]
PMT
¯
).
1. Move the cursor to cell A2, and enter
1500
. (
1500
¯
)
2. Move the cursor to cell B2, and then enter the formula
A2
44
=
TI-83 Plus CellSheet™ Application Page 20
.015
. (
¡ e
A2
015
¯
)
3. Move the cursor to cell C2, and then enter the formula
= A2
(
44
¡ e
.03
A2
03
¯
).
Your spreadsheet should look like this:
At the beginning of each month, the new principal, P
calculated using the following formula: P
where P
, PMT1, and I1all pertain to the previous month. The
1
= P1– (PMT1– I1),
2
, is
2
interest and minimum monthly payment are calculated exactly
as they were for the first month. Enter the remaining
spreadsheet formulas to find the solution to the problem.
1. Move the cursor to cell A3, and then enter the formula
= A2 – (C2 – B2)
¯
).
(
¡ e
e
A2
e
C2
B2
2. To copy the formulas from B2:C2 to B3:C3, place the cursor
in cell B2, and press Rto begin the range selection.
TI-83 Plus CellSheet™ Application Page 21
3. Press ato move the cursor to C2, and then select
(press
T
) to copy the formula from this range of cells.
Copy
4. Move the cursor to cell B3, and then select
U
5. Press
TI-83 Plus CellSheet™ Application Page 22
) to paste the formula from this range of cells.
\
to exit the copy/paste mode.
Paste
(press
Enter the data for the remaining four months by copying the
Tip
•
To copy and paste a range of cells, press R, select the range,
select
Copy
(press
T
), move the cursor to the new
location, and then select
Paste
(press
U
).
•
To copy a single cell, press
T
, move the cursor to the new
location, and then select
Paste
.
formulas from A3:C3 to rows 4 through 7.
1. With the cursor in cell A3, copy the formulas from A3:C3 (
Copy
a a
2. Move the cursor to cell A4, and then select
U
3. Move the cursor to cell A5, and then select
).
) to paste the formulas into A4:C4.
Paste
Paste
(press
to paste the
R
formulas into A5:C5.
4. Paste the formulas to A6:C6 and A7:C7.
5. Press
\
to exit copy/paste mode.
6. Move the cursor to cell A7, copy the formula, and paste it in
cell A8 (
T h
\
). This amount, $1370, is the
Paste
remaining principal to be paid after six payments have been
made.
TI-83 Plus CellSheet™ Application Page 23
Your spreadsheet should look like this:
Using the following formulas, calculate how much interest and
principal Margaret will have paid after six months.
The total principal paid is 1500 – P
The total interest paid is the sum of I
The total of the payments made is the sum of PMT
PMT
.
6
.
7
through I6.
1
through
1
1. Move the cursor to cell A9, and then enter the formula
=1500 – A8
¡
1500
e
(
2. Move the cursor to cell B9, and then press
3. Press
sum(
4. Press
5. Press
TI-83 Plus CellSheet™ Application Page 24
V
.
n
R
to display a list of functions, and then select
, and then move the cursor to cell B2.
to begin range selection.
A8
¯
).
¡
.
6. Move the cursor to cell B7, and then press
Tip
You could also directly enter the formula by pressing
¡
V1eB2e
[:]
eB7 ¯
.
You can see that after 6
months, Margaret will have
paid $260.08, which included
$130.04 in interest and
$130.04 in principal.
¯
.
7. Press to complete the formula, and then press
8. Move the cursor to cell B9, copy the formula, and then paste
it in cell C9 (
T a
Paste
Your spreadsheet should look like this:
Save the spreadsheet with the name
Each spreadsheet is automatically saved in RAM as you work on
it. Default names, beginning with S01, are used to name the
spreadsheets before you save your file with a unique name.
\
).
INTEREST
.
¯
.
1. Select
TI-83 Plus CellSheet™ Application Page 25
menus.
Menu
(press
V
) to display the CellSheet™
2. Select
Note
•
The spreadsheet name must begin with a letter, but can
contain both letters and numbers.
•
The spreadsheet name can have up to 8 characters.
cursor is at the
File > Save As
New
. The old name is displayed, and the
prompt. Alpha-lock is turned on.
3. At the
prompt, type
New
INTEREST
spreadsheet, and then press
4. Press
¯
again to accept the name and return to the
spreadsheet screen. The first few letters of the new
spreadsheet name are displayed in the upper left corner of
the screen.
Quit the application.
From the main spreadsheet screen, press
as the name for this
¯
.
\
.
TI-83 Plus CellSheet™ Application Page 26
Creating, Saving, and Opening Files
Tip
The spreadsheet name
•
can contain numbers and letters, but must begin with a letter
•
can contain up to 8 characters
TICSFILE is a reserved name used by the CellSheet™
application.
Creating a File
To create a new, blank spreadsheet:
1. Select
2. Select
Menu
>
File
(press
.
New
V
) to display the
3. Enter a name for the new spreadsheet, and then press
¯
two times. A new, blank spreadsheet is displayed.
CELLSHEET MENU
.
TI-83 Plus CellSheet™ Application Page 27
Saving a File
Tip
The spreadsheet name
•
can contain numbers and letters, but must begin with a letter
•
can contain up to 8 characters
TICSFILE is a reserved name used by the CellSheet™
application.
The spreadsheet is automatically saved in RAM as you work.
You do not have to manually save your work. However, you can
save the current spreadsheet with a new file name.
To save a file with a new name:
1. Select
2. Select
Menu
>
File
(press
Save As
V
.
).
3. Enter a name for the new spreadsheet, and then press
¯
two times. The spreadsheet is displayed, and the first
four characters of the new name are displayed in the top left
cell.
TI-83 Plus CellSheet™ Application Page 28
Opening a File
Tip
•
Only one spreadsheet can be open at a time.
•
Names of archived spreadsheets do not appear in the list. You
must unarchive a spreadsheet before you can open it.
1. Select
2. Select
(press
Menu
, and then select
File
V
).
Open
names is displayed.
3. Move the cursor to the spreadsheet name that you want to
open, and then press
¯
.
Managing Files
Copying a File
To copy a spreadsheet file, save the file with a new name
Deleting a File
1. Select
2. Select
Menu
>
File
(press
Delete
V
.
).
. A list of spreadsheet file
.
TI-83 Plus CellSheet™ Application Page 29
3. Move the cursor to the spreadsheet file name that you want
Note
You cannot delete the spreadsheet that is currently open.
Tip
•
If you need to free RAM on your TI83 Plus, you can save a
copy of a spreadsheet on your computer using TIConnect™ or
TI-GRAPH LINK™ software before you delete it.
•
You can also delete a spreadsheet using the memory
management menu from the home screen (
\ /
,
Mem Mgmt/Del> AppVars
{spreadsheet name}
^
Yes
).
to delete, and then press
¯
.
4. Select
Yes
. The spreadsheet file is deleted.
Renaming a File
To rename a file, save the file with a new name
the old spreadsheet.
, and then delete
TI-83 Plus CellSheet™ Application Page 30
Loading...