Suppose that the formula in cell C8 is "=H2+$P6". If cell C8 is copied to cell E10, the formula in cell E10 will be "=J4+$P8".

Question

Quizplus · Accepted Answer

When a formula is copied to a new location, Excel adjusts the cell references based on the relative position of the original and new locations. In this case, moving from C8 to E10 is a shift of 2 columns to the right and 2 rows down, so the formula adjusts from "=H2+$P6" to "=J4+$P8".

Suppose That the Formula in Cell C8 Is "=H2+$P6