Microsoft Office Tutorials and References
In Depth Information
Excel Chapter 2 Formulas, Functions, Formatting, and Web Queries
To Change Workbook Properties and Save the Workbook
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
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.
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
Every time you enter
a value into a cell in
the worksheet, Excel
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
3/6/07 3:28:09 PM
3/6/07 3:28:09 PM