KB109047 - Works: How to Insert Functions and Range Names in Spreadsheets

MORE INFORMATION

To insert a function into a spreadsheet, do the following:

Place the pointer in the cell where you want the function to go.
From the Insert menu, click Function.
Select the Function you want to use and click OK.

NOTE: When you highlight a function, a brief description will appear at the bottom of the dialog box explaining how to use that specific function.
Modify the function using the Formula Bar. (To access the Formula Bar, place the mouse pointer in the Formula Bar and click the left mouse button or press F2).

To insert a range name into a formula of a spreadsheet:

Select the cell containing the formula.
Place your cursor in the Formula Bar at the position where you want to insert the range name.
From the Edit menu, click Go To or press F5.
From the Go To List, choose the range name you want to insert. Click OK. Works will highlight the data contained in the Range Name.
Press ENTER on the keyboard to accept the information.

For example, if you want to find the sum of the cells with the range name "Totals", the formula would be:

=Sum(Totals)

NOTE: If a function references a cell range that is later assigned a name, that range name will then appear in the syntax of the formula on the formula bar.

Works: How to Insert Functions and Range Names in Spreadsheets

SUMMARY

MORE INFORMATION

REFERENCES