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.

Search JabSto ::

Custom Search