select the correct answer. cassandra copies t...
select the correct answer. cassandra copies the formula =sum($a1:c1) from cell d1 to cell f10. what will the formula change to? a. =sum($a10:c10) b. =sum(a10:e10) c. =sum($a10:e10) d. =sum(a1:c1)
Answer
# Answer:
C. =SUM($A10:E10)
# Explanation:
## Step1: Understand absolute and relative references
In =SUM($A1:C1), $A1 has an absolute - column reference (the $ before the column letter 'A' makes the column fixed) and a relative - row reference, while C1 has a relative column and row reference.
## Step2: Analyze the row and column movement
When copying from cell D1 to F10, the row moves down 9 rows and the column moves right 2 columns.
## Step3: Adjust the formula
The absolute - column reference $A will remain as $A. The relative - row reference 1 will change to 10 (1 + 9). The relative - column reference C will change to E (C is the 3rd column and E is the 5th column, 3+2 = 5). So the new formula is =SUM($A10:E10).