Microsoft Office Tutorials and References

In Depth Information

**MAX and MIN—Recording Highs and Lows**

Figure 3–25.
Test scores, about to be boosted by three points each

So how do I go about padding these pause-giving scores by those three points? Gordon’s score is in

cell D11, and so I could write the following in E11, couldn’t I:

=D11+3

Sure I could. Then I’d return to cell E11, and utilize my newfound double-click-on the fill-handle trick.

I’ll bring about this revised grade distribution (Figure 3 - 26):

Figure 3–26.
Nice guy: the three-point curve, now in effect

Are my calculations correct? Absolutely; but still I wouldn’t recommend this approach. That’s

because if I conclude that I need to award my charges say, 5 points instead, I’d need to edit the formula

in E11 to read:

=D11+5

and then copy that rewritten expression down the column again, so that all the students will enjoy my 5-

point largesse. Not an enormously big deal, but not an elegant way in which to proceed. As a rule, one

wants to avoid editing cells if one can; it can get messy, and a preferable alternative would be to enter the

5-point bonus figure in a cell—say in this case, A11, and rewrite Gordon’s formula thusly:

=D11+A11

and copy it down the column. And exactly why is this approach recommended? Because if I change

my mind again and issue a 7-point curve, all I need do is type 7 in cell A11, and all the scores should

change automatically—with no additional cell editing required.