Microsoft Office Tutorials and References
In Depth Information
Self study
To use a name to build a formula:
1
Click in cell D3, and then type a equal sign ( ). =
2
Click in cell C3 to select the retail price for the i rst item, and then type an asterisk ( ).
3
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.
4
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.
5
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.
Self study
1
Open the excel0502_done document. Calculate the annual loan payment using a 2.2%
interest rate.
2
Open the excel0503_done document. Calculate the sum of the sales for 2010.
3
Open the excel0504_done document. Calculate the sales average for Division 1 and
Division 2.
Review
Questions
1
What is the name for a sign or symbol that specii es the type of calculation to perform,
such as a plus sign?
2
What are the two possible results for a comparison formula?
3
What are the two components for every function?
4
What character must begin each formula?
Answers
1
A sign or symbol that specii es the type of calculation to perform is called an operator.
2
A comparison formula can return a result of 0 for false or 1 for true.
3
The two components for every function are a name that must appear in uppercase and
arguments that appear in parentheses.
4
An equal sign must be the i rst character in every formula.
Search JabSto ::




Custom Search