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.