Filter
Top Products
Spreadsheet 199
32.Tap and select Color.
33.Choose a color for the contents of the selected cells.
34.Tap and select Fill.
35.Choose a color for the background of the selected cells.
The most important cells in the spreadsheet will now stand
out from the rest.
The spreadsheet is complete,
but you may want to check all
the formulas by adding some
dummy data to the PRICE
column. When the profit
reaches 250, you should see
the value in D9 change from 0
to 1.
Basic operations
Navigation, selection and gestures
You can move about a spreadsheet by using the cursor keys, by
swiping, or by tapping and specifying the cell you want
to move to.
You select a cell simply by moving to it. You can also select an
entire column—by tapping the column letter—and select an
entire row (by tapping the row number). You can also select the
entire spreadsheet: just tap on the unnumbered cell at the top-
left corner of the spreadsheet. (It has the HP logo in it.)
A block of cells can be selected by pressing down on a cell that
will be a corner cell of the selection and, after a second,
dragging your finger to the diagonally opposite cell. You can
also select a block of cells by moving to a corner cell, tapping
and using the cursor keys to move to the diagonally
opposite cell. Tapping on or another cell deselects the
selection.