Name a cell or range, Enter a formula, Insert a function – Unitech PA950 User Manual

Page 110

Advertising
background image

10-110

Name a cell or range

1. Select the cell or range you want to name.

2. Tap Tools > Define Name.

3. Type the name.

4. Tap Add.The name appears in the name box.

To delete a name, select it in the list and tap Delete.

To paste the list of cell names and their locations on the worksheet, tap

Paste List.

See Also: Go to a cell

Refer to a cell or range

Enter a formula

1. Select a cell.

2. Begin the formula with an equal sign (=).

3. Enter values, cell references, name references, operators, and functions

as appropriate.Examples:=(B4/25)+100=Revenue-Expenses

4. To enter the formula in the cell, tap ENTER in the input panel.

See Also: Refer to a cell or range

Insert a function

1. Tap Tools > Insert Function.

2. In Category, select a function category.

3. From the Function list, select a function. You can review function

information in the description area.

Advertising