Filter
Top Products
Section 5B: Increasing Your Productivity 297
Productivity
Inserting a Function
1. Highlight the cell where you want to insert the function.
2. Press Menu (right softkey) and select Insert > Function.
3. Select the Category list, and then select the type of function
you want to insert.
4. Select the Function list, and then select the specific function
you want to insert.
5. Select OK.
Tip
To refer to a cell from another worksheet in your formula, enter the
worksheet name followed by an exclamation point (!) and the cell, range, or
name reference.
Example: =Sheet1!Earnings.
To create a 3-D reference in your formula, specify two or more sheets in a
workbook. Use a colon between the first and last worksheet names.
Example: =SUM(Sheet2:Sheet6!$A$2:$C$5)
Did you know?
To enter symbols that are not on the keyboard, such as the = sign, press Alt
and select the symbol from the list.