Microsoft Office Tutorials and References

In Depth Information

EX 90

Excel Chapter 2
Formulas, Functions, Formatting, and Web Queries

To Change Workbook Properties and Save the Workbook

Entering Numbers

in a Range

An efﬁ cient way to enter

data into a range of

cells is to select a range

and then enter the ﬁ rst

number in the upper-left

cell of the range. Excel

responds by entering the

value and moving the

active cell selection down

one cell. When you enter

the last value in the ﬁ rst

column, Excel moves the

active cell selection to the

top of the next column.

With the data entered into the worksheet, the following steps save the workbook

using the ﬁ le name, Silver Dollars Stock Club Portfolio Summary. As you are building a

workbook, it is a good idea to save it often so that you do not lose your work if the

computer is turned off or if you lose electrical power. The ﬁ rst time you save a workbook, you

should change the workbook properties.

1
Click the Ofﬁ ce Button, click Prepare on the Ofﬁ ce Button menu, and then click Properties.

2
Update the document properties with your name and any other information required.

3
Click the Close button on the Properties pane.

4
With a USB ﬂ ash drive connected to one of the computer’s USB ports, click the Save button

on the Quick Access toolbar.

5
When Excel displays the Save As dialog box, type
Silver Dollars Stock Club

Portfolio Summary
in the File name text box.

6
If necessary, click UDISK 2.0 (E:) in the Save in list (your USB ﬂ ash drive may have a

different name and letter). Click the Save button in the Save As dialog box to save the

workbook on the USB ﬂ ash drive using the ﬁ le name, Silver Dollars Stock Club Portfolio

Summary.

Entering Formulas

One of the reasons Excel is such a valuable tool is that you can assign a
formula
to a cell

and Excel will calculate the result. Consider, for example, what would happen if you had

to multiply 440

64.59 and then manually enter the product, 28,419.60, in cell F4. Every

time the values in cells D4 or E4 changed, you would have to recalculate the product and

enter the new value in cell F4. By contrast, if you enter a formula in cell F4 to multiply

the values in cells D4 and E4, Excel recalculates the product whenever new values are

entered into those cells and displays the result in cell F4.

Plan

Ahead

Determine the necessary formulas and functions needed.

The formulas needed in the worksheet are noted in the requirements document as follows:

1. Initial Cost (column F) = Shares

Initial Price Per Share

2. Current Value (column H) = Shares

Automatic

Recalculation

Every time you enter

a value into a cell in

the worksheet, Excel

automatically recalculates

all formulas. You can

change to manual

recalculation by clicking

the Calculation Options

button on the Formulas

tab on the Ribbon and

then clicking Manual.

In manual calculation

mode, press the
F9
key

to instruct Excel to

recalculate all formulas.

Current Price Per Share

3. Gain/Loss (column I) = Current Value – Initial Cost

4. Percent Gain/Loss (column J) = Gain/Loss / Initial Cost

The necessary functions to determine the average, highest, and lowest numbers are

discussed shortly.

C6161_EXC_02.4c.indd 90

C6161_EXC_02.4c.indd 90

3/6/07 3:28:09 PM

3/6/07 3:28:09 PM