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?