HP Prime Spreadsheet App Tutorial 2: Copying and Pasting Formulas
Lesson 2
Objectives:
* Using the AVERAGE
function
* Copying
and pasting formulas
Note: I had the calculator set to Fix 3 as the
number format.
Objective:
We are
looking at three quizzes for three students, Belinda, Chris, and Drake, or B,
C, and D for short. The professor wants
to see how they are doing overall. The
data:
Brenda
|
Chris
|
Drake
|
|
Quiz 1
|
96
|
95
|
97
|
Quiz 2
|
90
|
98
|
88
|
Quiz 3
|
86
|
76
|
84
|
Steps:
1. Enter the data in the following cells: B2 = 96, C2 = 95, D2 = 97, B3 = 90, C3 = 98,
D3 = 88, B4 = 86, C4 = 76, and D4 = 84.
2. Go to cell B5. To recall, you can go to a cell in any one
of three ways: use the arrow keys, tap
the cell, or use the (Go To) function on the soft key menu.
3. Press [ Shift ], [ . ] ( = ), [ Menu ],
select 5 for AVERAGE, the parenthesis key [ ( ) ], and then enter B2:B4. You should have =AVERAGE(B2:B4). Press ( OK ).
The result should be 90.667, the average for Belinda.
4. Copy and paste the formula from B5 to C5
to get the average for Chris. To copy
the formula, press [ Shift ], [ View ] (Copy).
5. Move to cell C5. To paste, press [ Shift ], [ Menu ]
(Paste). You will be presented by what
is on the clipboard. You will want to
select the last result 90.667. Note that
there is a > next to it. Press the
right key [ → ] and select Formula (not Value).
The formula is copied on to cell C5, with the proper cells as its
range. If it goes right, C5 contains
89.667.
6. Repeat the steps 4 and 5 for Drake, except
you can copy the formula from either cell B5 or C5. Don’t forget when pasting, select the copied
result, press the right key [ → ], and select Formula. Drake should have an average of 89.667.
7. The professor has just realized that
score of Drake’s third quiz is incorrect (cell D4). It should be 81. Go to cell D4 and enter 81. Note that the average for Drake (cell D5) is
automatically updated, and it is now 88.667.
This
concludes Lesson 2. Next time, adding
labels to cells and extending columns.
Eddie
This blog is
property of Edward Shore, 2015.
