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 fi nances for the upcoming year, and
she is more confi 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 defi 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