As with any other formula, you can insert cell references and defined names into your functions easily using the mouse.

For example, to enter a function in cell C11 that averages the cells in the range C2:C10, select cell C11, type =average(, and then select the range C2:C10. A marquee appears around the selected cells and a reference to the selected range appears in the formula. Then type the closing parenthesis.

If you define named ranges, constants, or formulas in your worksheets, you can insert them into your formulas. To do this, choose Insert, Name, Paste, and then select the name you want in the Paste Name dialog box. When you click OK, the name appears at the insertion point in the formula.