Sunday, September 20, 2015

HP Prime Spreadsheet App Tutorial 3: Adding Labels, Entering Numeric Calculations, Changing Numeric Format of Cells, and Extending Columns

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.

1 comment:


  1. Thank you for this blog post it actually couldn't have come at a better time for me !!


    HP Printer Customer Care Support

    ReplyDelete

HP Prime and Casio fx-CG50: Trapezoid Midsegment, Height, Area

HP Prime and Casio fx-CG50:  Trapezoid Midsegment, Height, Area The program TRAPEZ calculates the following: Midsegment leng...