Question $3(1$ point$)$

When do you need to use an absolute cell reference?

You are using cell references in a calculation

you plan to copy the calculation to another row or column

you want the cell references to change relative to the new location

You are using all constants $($typed in numbers$)$ in your calculation.

You have a complex calculation that you want Excel to take seriously.

You are using cell references in a calculation

You plan to copy the calculation to another row or column

You don't want some $($or all$)$ of the cell references to change when you copy the calculationQuestion $3(1$ point$)$

When do you need to use an absolute cell reference?

You are using cell references in a calculation

you plan to copy the calculation to another row or column

you want the cell references to change relative to the new location

You are using all constants $($typed in numbers$)$ in your calculation.

You have a complex calculation that you want Excel to take seriously.

You are using cell references in a calculation

You plan to copy the calculation to another row or column

You don't want some $($or all$)$ of the cell references to change when you copy the calculation