Question

3
select the correct answer
cassandra copies the formula =sum($a1:c1) from cell d1 to cell f10. what will the formula change to?
o a. =sum(a1:c1)
o b. =sum(a10:e10)
o c. =sum($a10:e10)
o d. =sum($a10:c10)

Explanation:

Step1: Analyze cell reference types

In Excel, \(\$A1\) is a mixed reference (column fixed, row relative), and \(C1\) is a relative reference.

Step2: Determine row and column changes

When copying from row \(1\) (in \(D1\)) to row \(10\) (in \(F10\)), the row number in relative references changes. The column part of \(\$A1\) remains \(\$A\) (because of the \(\$\) fix), and the row number changes from \(1\) to \(10\). For the relative reference \(C1\), the column changes from \(C\) (in \(D1\), since formula is in \(D1\) and the range starts at \(\$A1\)) to \(E\) (as we move from column \(D\) (original formula cell) to \(F\), and the range start - column \(\$A\) is fixed, so the end - column of the range changes relative to the formula cell column movement). The row number changes from \(1\) to \(10\).

Answer:

C. \(=\text{SUM}(\$A10:E10)\)