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


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

13 comments:

  1. Thanks again for your tutorials. Very helpful!

    ReplyDelete
  2. Thanks again for your tutorials. Very helpful!

    ReplyDelete
  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?

    ReplyDelete
  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...

    ReplyDelete
    Replies
    1. Eddie and Mike, thank you, your information is very helpful.

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

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

      Delete
  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.

    ReplyDelete
  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?

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

      Delete
    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 ��.

      Delete
  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?

    ReplyDelete
    Replies
    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

      Delete

TI-84 Plus CE: Simple Elliptic Curves Determined by Two Points

TI-84 Plus CE:  Simple Elliptic Curves Determined by Two Points Introduction The program ECURVE determines the coefficients of a simple...