When cell C3 containing the formula B6C8 is copied to cell D2 the formula in cell D2 is?

When cell C3 containing the formula B6C8 is copied to cell D2, the formula in D2 will adjust based on its new location. It will become C6D8, as Excel automatically updates the cell references relative to the position of the new cell. This is known as relative referencing.