Filter
Top Products
296 Section 5B: Increasing Your Productivity
Calculating a Sum
1. Press View (left softkey) and select Toolbar.
2. Highlight the cell where you want to insert the sum.
3. Select Sum .
4. Tap and drag the stylus across the cells you want to add.
5. Press Return .
Entering a Formula
1. Highlight the cell where you want to enter the formula.
2. Enter an equal (=) sign followed by any values, cell references, name references,
operators, and functions. Example: =(B4/25)+100=Revenue-Expenses
3. Press Return .
Referring to a Cell or Range in a Formula
1. Open the workbook where you want to refer to a cell or range in a formula.
2. Begin entering a formula in a cell.
3. Navigate to the cell you want to refer to in the formula. To refer to a range, tap and drag
the stylus over the cells you want to include in the range.
4. Finish entering the formula and press OK .
Did you know?
You can switch worksheets by selecting the sheet list at the bottom of the
screen.