Chapter 8 Pocket Sheet

6.Type * into the input field.

7.Tap cell C2.

8.Tap any cell or the NEXT button to display the calculation result.

• The value in cell C5 shows the result of the function.

Controlling the Appearance of a Cell

This section explains how to make cell format settings that control the format of data inside individual cells or a range of cells. The format settings are: numeric value category (monetary unit, percent), number of decimal places, alignment, text style (bold or normal), comma separators for values, and cell lock.

Changing the Format Settings of a Cell

1. Make the cell whose format you want to change the active cell (page 85).

•You can select a single cell or a range of cells.

2.Tap Menu Bar to display the menu bar, and then tap Option – Formats to display the Formats tab.

93