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

2 comments:

  1. Thanks again for your tutorials. Very helpful!

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

    ReplyDelete

HP 15C: Pythagorean Triples

HP 15C:   Pythagorean Triples This program calculates the Pythagorean triple (A, B, C) such that A^2 + B^2 = C^2 by the formulas: ...