## Sunday, September 20, 2015

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

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

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.

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

Tap ( OK ) to clear 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

3. Hi 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?

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

5. Hello, how do I get the : sign?

1. more simple: press ALPHA, '-' (minus key)

6. Press 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.

7. How 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?

1. Also forgot to ask how do you save the sheet for later use?

2. seems 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 ��.

8. How 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?

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

Eddie

### Casio fx-5800P: Lambert Function by Pierre Gillet

Casio fx-5800P: Lambert Function by Pierre Gillet The programs on this blog entry are created and authored by Pierre Gillet. Gratitude for h...