HP Prime
Spreadsheet App Tutorial 3: Adding
Labels, Entering Numeric Calculations, Changing Numeric Format of Cells, and Extending
Columns
Lesson 3 Objectives:
* Adding Labels to Cells
* Entering Numeric Calculations
* Changing the Numeric Format of Cells
* Expanding the Length of a Column
Note: I had the calculator set to Fix 3 as the
number format.
Objective:
A calculator company wants to find out the profit of
their graphing calculator sales for a week from a local store. The store sells the calculator for $149, including
tax. It costs the company $69 per
calculator for manufacturing and research costs, plus an estimated fixed cost
of $2,500. For the week in question, 150
calculators were sold. Find the profit.
Steps:
1. We’ll
start with the labels Sales, Costs, and Profit.
Use cells A1, A2, and A3, respectively.
Enter labels as strings. So, for
A1, enter “Sales”; “Costs” for A2; and “Profit” for A3.
2. The
next step is to add the numerical calculations.
We are going to have the HP Prime execute the numeric calculation. For sales, enter =150*149. Put the calculation in cell C1.
3. For
C2, calculate the costs. The formula is
=150*69+2500.
4. For
C3, calculate the profit. Enter
=C1-C2. The result should be $9,500.00.
5. Change
the format of the cells containing numbers to show 2 decimal numbers. To do this, first select C1.
6. Next
press the (Select) soft key. It turns
into the soft key (Sel *) (The *
represents a solid circle. You are in
Select Mode. Any cell you go to using
the arrow keys selects that cell. In
this case, press down [ ↓ ] twice to select cells C2 and C3.
7. Choose
the Fixed Format: Press the (Format)
soft key and select 1 for Number Format, then 3 for Fixed.
8. Choose
2 Decimal Places: Press the (Format)
soft key and select 1 for Number Format, then 8 for Decimal Places, then 2.
9. Select
the Header Cell of Column C: Select the
header cell of column C, which is above cell C1. You can tap the header cell or use the arrow
keys. Unfortunately the (Go To) feature
won’t let you select header cells.
10. Enlarge
Column C: Press the (Format) soft key
and select 8 for Column ←→ . Enter
125. Column sizes are measured in pixels
and not in font size.
Next time, we will name columns, use names in a formula,
and recall columns in places outside the Spreadsheet App Num View.
Have a great day,
Eddie
This blog is property of Edward Shore, 2015.
