Chapter 8 Pocket Sheet

Mixed Cell References

A mixed cell reference is one in which one component (column name or row number) is relative, and the other component is absolute. Note the following examples.

Mixed Cell

Meaning

Reference

 

 

 

$A1

Contents of cell A1. The column reference ($A)

 

is absolute, and the row reference (1) is

 

relative.

 

 

A$1

Contents of cell A1. The column reference (A)

 

is relative, and the row reference ($1) is

 

absolute.

 

 

Using the On-screen Keyboards

Opening a new sheet that does not contain any data or tapping the highlighted cell within a sheet causes an on-screen keyboard to appear.

•Tapping the button above the text keyboard changes to the numeric keyboard.

•Tapping the button above the numeric keyboard changes to the text keyboard.

•Tapping displays a menu of built-in functions.

88