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.


[ 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


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.


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, 


This blog is property of Edward Shore.  2015


  1. Thanks again for your tutorials. Very helpful!

  2. Thanks again for your tutorials. Very helpful!


Eclipse and HHC 2017

Eclipse On August 21, 2017 there will be a solar eclipse.  Totality (where the moon completely covers the sun) will occur in the northern...