Microsoft Office Tutorials and References

In Depth Information

**Copying Formulas: More Than Just Duplication**

What Excel
won’t
do, then, is take the 60 and multiply it by 3 – 2, yielding 60. Play

around with some of your own examples and the order of operations will become

clearer.

Copying Formulas: More Than Just Duplication

I’ve already discussed how to copy data and formats through the format painter. But

copying formulas introduces something new, something important. Let’s see what that

means.

1.

Enter the test data shown

in Figure 4–20 in a blank

spreadsheet, starting at

cell J7.

Figure 4–20.
Tough test

2.

Save the file under the name Student Scores.

3.
Now let’s say that, because the scores are on the low side (these could

be scores relative to a test score maximum of say, 120, but it doesn’t

much matter), the teacher decides to award a five-point bonus—and as

a result, needs to write a formula that will impart that bonus to all the

students. Enter the word
Bonus
to serve as a heading in cell L7, and in

L8, write

=K8+5

That little formula delivers a score of 82 to John, boosting his original 77. The question is

how to award the same bonus to all the students, along with the implied question of

what would happen if the class consisted of 100 students instead of just the five in our

example.

The one thing the teacher
won’t
do is write the formula for each student—that’s way too

inconvenient. The alternative is to
copy
the original formula down the L column, but we

need to describe how that works.

There are several ways to copy a formula; we’ll look at two of them. The first is very

similar to the technique discussed in Chapter 2.