Microsoft Office Tutorials and References

In Depth Information

**Session 2.1**

To enter the TODAY() function on the Documentation sheet:

1.
Switch to the Documentation sheet.

2.
Click cell
B4
, type
=TODAY()
, and then click the
Enter
button on the Formula bar. Note

that there are no arguments in the TODAY() function, but you still have to include the open-

ing and closing parentheses, and there are no spaces between the parentheses. Excel dis-

plays the current date as shown in Figure 2-23.

Inserting the current date

Figure 2-23

TODAY() function inserts the current

date (yours will be different)

You have completed your work on the Budget2 workbook.

3.
Save your changes to the workbook, and then close it.

Using Math and Statistical functions, you have been able to calculate the monthly and

end-of-year values Amanda requested. With these values in place, Amanda has a better

picture of the family’s finances, and she is more confident about how she will manage the

family budget in the year to come.

Session 2.1 Quick Check

1.
What is the function you enter to calculate the minimum value in the range B1:B50?

2.
Cell A10 contains the formula
=A1+B1
. When you copy the content of cell A10 and

paste it into cell B11, what formula is inserted into the destination cell?

3.
Cell A10 contains the formula
=$A$1+B1
. When you copy the content of cell A10

and paste it into cell B11, what formula is inserted into the destination cell?

4.
Express the reference to cell A1 as (a) a relative reference, (b) an absolute reference,

and (c) a mixed reference (both possibilities).

5.
List the steps you use in Excel to create a series of odd numbers from 1 to 99 in col-

umn A of your worksheet.

6.
To display the current date in a workbook each time you reopen it, you enter the

function in the cell where you want the date to appear.

Review

To reinforce the tasks you

learned in this session, go

to the SAM 2003 Training

Companion CD included

with this text.