Microsoft Office Tutorials and References
In Depth Information
Session 3.1 Quick Check
With Diane’s promotion, the couple’s annual income increases from \$51,000 to
\$53,700 and the monthly average increases from \$4,250 to \$4,475. The couple’s income
should exceed their expenses by about \$700 per month. The monthly income now
ranges from a minimum of \$4,400 up to a maximum of \$4,700.
Diane now has a better picture of the family’s ﬁ nances for the upcoming year, and
she is more conﬁ dent about how to manage the couple’s budget. She and Glenn hope
to save enough for a down payment on a house in a few years. With the promotion, this
seems like a real possibility. In the next session, you’ll help Diane explore the couple’s
options in planning for the purchase of a house.
Session 3.1 Quick Check
1. You need to reference cell Q57 in a formula. What is the absolute cell
reference? What are the two mixed references?
2. If cell R10 contains the formula =R1+R2. What formula is entered if this formula
is copied and pasted into cell S20?
3. If cell T10 contains the formula =\$T1+T\$2. What formula is entered if this
formula is copied and pasted into cell U20?
4. If cell V10 contains the formula =AVERAGE(\$U1:\$U5). What formula is entered
if this formula is copied and pasted into cell W20?
5. What are optional arguments? What happens if you do not include an optional
argument in a function?
6. What function formula can you use to add the numbers in the range X1:X10?
7. The range of a set of values is deﬁ ned as the maximum value minus the
minimum value. What formula with functions can you enter to calculate the range of
the values in Y1:Y10?
8. What formula with functions can you enter to calculate the ratio of the
maximum value in the range Z1:Z10 to the minimum value?   Search JabSto ::

Custom Search