**HP Prime Spreadsheet App Tutorial 6: Row and Column References in Formulas**

Lesson 6
Objectives:

* Use Row
and Col in spreadsheet formulas

We can use
formulas that are determined where the cell position. Use

**Row**for row references and**Col**for column references. Be aware that Row and Col are case-sensitive.
What value
Row takes is almost obvious since rows are labeled numerically. Columns are labeled alphabetically. The values each column assign is:

1 for column
A,

2 for column
B,

3 for column
C,

4 for column
D,

5 for column
E, and so on.

Part 1: Build a Spreadsheet of Fibonacci Numbers with the first column of row numbers.

1. Start by clearing the spreadsheet ( [ Shift ],
[ Esc ] (Clear), (OK) ).

2. Select the header cell for Column
A. The header cell is above cell
A1. Enter the formula =Row.

3. Select the header cell for Column B,
above B1. Type the following formula:

=( ((1 +
√5)/2)^Row – ((1 - √5)/2)^Row ) / √5

Part 2: Build a Spreadsheet of Powers

4.
Clear the Spreadsheet.

5.
Select
the upper left hand cell, with the hp logo.

6.
Type
=Row^Col.

That concludes
Lesson 6. Next we will tackle using
absolute references. Have a great day,

Eddie

This blog is
property of Edward Shore, 2015.

## No comments:

## Post a Comment