**HP Prime Spreadsheet App Tutorial 1: Sum of a Column of Numbers**

Welcome to the HP Prime Spreadsheet App Tutorial

Over the next couple of weeks, I will be posting short
tutorials on how to use the HP Prime Spreadsheet. Let’s get started. First, some preliminaries.

KEY:

[ button ] : keyboard
buttons.

[ Shift ], [ button ] (shifted function): pressing the Shift key to access the shifted
functions

( soft key ):
soft keys that appear on the bottom of the screen

**Starting the Spreadsheet App**

Press the [Apps] key. Spreadsheet is one of the default
applications to choose from when the HP Prime is first purchased. To enter the spreadsheet, all you have to do
is tap the Spreadsheet icon on the Apps screen.

**Clearing the Spreadsheet**

You can clear the spreadsheet and all of its formatting, press
[Shift], [ Esc ] (Clear).

Tap ( OK ) to clear the spreadsheet.

**Accessing the Spreadsheet**

You can access the spreadsheet at any time (while you are
in the app) by pressing the [ Num ] key.

**Lesson 1: Sum of a Column of Numbers**

Lesson 1 has the following objectives:

* Entering numbers

* The SUM function

* Coloring the text
of a cell

Objective:

Use the spreadsheet to add the following numbers: 85, 96,
63, 52, and 63. Colorize the sum to
differentiate it from the rest of the numbers.

Steps:

1. Enter the following numbers into cells A1
through A5 respectively: 85, 96, 63, 52,
and 63.

2. You should be at cell A6. If you are not you can either (a) press the
arrow keys to get there, (b) tap the cell A6, or (c) press the (Go To) soft key
and enter A6 as the Target. Remember to
use the [ ALPHA ] key for the A.

3. At cell A6, press [ Shift ], [ . ] ( = ) for
the equals sign.

4. Press the [ Menu ] key, select 4 for SUM. Next, press the parenthesis key [ ( ) ].

5. Enter A1:A5.
You will need to type the range. You
should have =SUM(A1:A5) showing on the command line.

6. Press
the soft key ( OK ). You should get the
sum of 359.

7. To color the sum, select the cell A6 again. Press the (Format) soft key, select 4 for
Color, and select any color you want.
In the illustration below, I selected blue (my favorite color).

That concludes the first lesson. Next lesson will include copying and pasting
formulas and using AVERAGE. Talk to you next time,

Eddie

This blog is property of Edward Shore. 2015

Thanks again for your tutorials. Very helpful!

ReplyDeleteThanks again for your tutorials. Very helpful!

ReplyDeleteHi Eddie, If I am in RPN mode I keep getting "Syntax Error" when entering formulae in the Spreadsheet App. If I change to Textbook mode all is well. Any idea why that is the case?

ReplyDeleteHuh! Just after I posted this I found the answer on HPForums... I need to forget the = and surround the formula in single quotes...

ReplyDeleteEddie and Mike, thank you, your information is very helpful.

DeleteHello, how do I get the : sign?

ReplyDeletemore simple: press ALPHA, '-' (minus key)

DeletePress the Shift key, followed by the "Vars" key for "Chars." You'll then see the character you want in the second line from the top, beside the 9.

ReplyDeleteHow do you insert a row in front of this one to add the label: "Total" in front of the some? Also can you select the cells without typing the names? And is it possible to pick up the forumula =SUM() from a list of common Spread Sheet functions?

ReplyDeleteAlso forgot to ask how do you save the sheet for later use?

Deleteseems there is no addcolumn or addrow function as there is in catalog for matrices. The simple way: use mark function (press finger to start cell, wait a moment until soft keys change), let finger on screen and move to end cell to mark a number of cells in row or column or both. When all is marked, use SHIFT, View(copy), copy symbol is shown a moment, then set finger to target cell, then use SHIFT, Menu(paste) to copy into target area. Then mark the 'old' area as before and delete the cells by Del key. Indeed, ancient visicalc had addcol and addrow anno 1982 when cp/m was in usage ��.

DeleteHow do you save a document. It seems to just be creating more apps. Plus what is the basic starting point for a calculation work space where nothing is saved?

ReplyDeleteAny edits to the Spreadsheet app is automatically saved. I am not aware of any method to save the spreadsheet in a separate file.

DeleteEddie