Microsoft Office Tutorials and References
In Depth Information
Tutorial 3 Working with Formulas and Functions Developing a Family Budget
3
TUTORIAL
Working with
Formulas and
Functions
Developing a Family Budget
OBJECTIVES
Session 3.1
• Copy formulas
• Build formulas containing
relative, absolute, and mixed
references
• Review function syntax
• Insert a function with the Insert
Function dialog box
• Search for a function
• Type a function directly in
a cell
Case | Drake Family Budget
Newlyweds Diane and Glenn Drake are trying to balance career,
school, and family life. The couple’s income and expenses vary
throughout the year. Diane works full-time as a legal assistant, but
earns less in the summer months when she cuts back her work
hours to attend summer courses. Glenn is in a graduate program
at a nearby university where he recently was hired as a lab
assistant. In the summer, Glenn takes on other work to earn additional
income. The couple just moved into a new apartment, but plan to
purchase a house in the next several few years. Although Glenn and
Diane’s salaries have grown in the past few years, the couple seems
to have less cash on hand. This ﬁ nancial shortage has prompted
them to take a closer look at their ﬁ nances and ﬁ gure out how to
best manage them.
Session 3.2
• Use AutoFill to ﬁ ll in a formula
and complete a series
• Enter the IF logical function
• Insert the date with the TODAY
function
• Use the PMT ﬁ nancial function
to calculate monthly mortgage
payments
Diane has set up an Excel workbook and entered the monthly
income from their two jobs. She has identiﬁ ed and entered
expenses the family pays on a monthly basis, such as the rent and
grocery bill, as well as other expenses that occur only a few times a
year, such as Glenn’s tuition and vacations. She wants to calculate
how much money they are bringing in and how much money they
are spending. She also wants to come up with a savings plan for the
down payment on a house they hope to buy in a few years.
You’ll help Diane complete the workbook. You will enter formulas
to perform the calculations that will provide Diane with a better
overall picture of the family’s ﬁ nances. Diane and Glenn will be
able to use this information to manage their money more effectively.
STARTING DATA FILES
Excel3
Tutorial
Review
Case1
Case2
Case3
Case4
Drake.xlsx
Timov.xlsx
Chemistry.xlsx
Wizard.xlsx
Loan.xlsx
V6.xlsx
EX 115

Search JabSto ::

Custom Search