156k views
4 votes
You copy the formula =SUM($A1:C1) from cell D1 to cell F10. What will the formula change to? A.) =SUM(A1:C1) B.) =SUM($A10:E10) C.) =SUM(A10:E10) D.) =SUM($A10:C10)

2 Answers

3 votes

The right answer is C) =SUM(A10:E10)


This is a problem of using Excel. This problem has been solved in Figure 1 and 2. The first formula =SUM($A1:C1) has been written in cell D1. This sum is:

Cell A1 + Cell B1 + Cell C1

Next, by using copy and paste tool in cell F10 the formula automatically changes to =SUM(A10:E10). This means that the program will compute the following sum:


Cell A10 + Cell B10 + Cell C10 + Cell D10 + Cell E10

You copy the formula =SUM($A1:C1) from cell D1 to cell F10. What will the formula-example-1
You copy the formula =SUM($A1:C1) from cell D1 to cell F10. What will the formula-example-2
User SwingMan
by
6.7k points
2 votes

Answer:

It's B

Step-by-step explanation:

Can't forget the dollar sign. That's why it's B, not C.

=SUM($A10:E10)

I also got it right on the test with B as my answer.

User Vinny Roe
by
7.8k points