Microsoft Office Tutorials and References
In Depth Information
To use a name to build a formula:
Click in cell D3, and then type a equal sign ( ). =
Click in cell C3 to select the retail price for the i rst item, and then type an asterisk ( ).
Click Use in Formula in the Dei ned Names group. Excel displays a list of the dei ned
names. Select Discount_rate and press Enter.
In cell D3, click the bottom-right corner of the cell, and drag through cell D7.
Excel displays the discount for each item in column D.
Click File > Save, and then click File > Close.
Congratulations! In this lesson you have discovered how to build and use formulas and
functions using the tools that Excel provides.
Open the excel0502_done document. Calculate the annual loan payment using a 2.2%
Open the excel0503_done document. Calculate the sum of the sales for 2010.
Open the excel0504_done document. Calculate the sales average for Division 1 and
What is the name for a sign or symbol that specii es the type of calculation to perform,
such as a plus sign?
What are the two possible results for a comparison formula?
What are the two components for every function?
What character must begin each formula?
A sign or symbol that specii es the type of calculation to perform is called an operator.
A comparison formula can return a result of 0 for false or 1 for true.
The two components for every function are a name that must appear in uppercase and
arguments that appear in parentheses.
An equal sign must be the i rst character in every formula.