Question

The formula in cell C5 is "=SUMPRODUCT($A$1:$C$1,A2:C2)". If one copies and pastes the formula from the cell C5 into the cell C6, what numerical value will appear in the cell C6?

Answer 1

See Explanation

Explanation:

Given

Formula: =SUMPRODUCT($A$1:$C$1,A2:C2)

Required

Determine the numerical value that will appear

The question seem incomplete; however, I'll give a general explanation

FIrst, when the formula is copied from C5 to C6, A2 and C2 changes to A3 and C3 respectively.

This is because they are relative references and they behave on a relative position.

This implies that, when the formula is in cell C5, the formula considers cells A2 and C2 when executing the formula;

However, C6 will consider cells A3 and C3, respectively.