Do Now-02/05/24

What symbol is used to denote an absolute cell reference in Excel?

• $

• %

• &

• #

If you copy the formula `=B3+1` from cell A1 to B2, what will the formula in B2 be?

• =B3+1

• =B4+1

• =B3+1

• =B4+1

Which of the following is an example of a mixed cell reference?

• $A1

• A$1

• Both A) and B) are correct

What happens to the cell reference `A1` when it is copied from one cell to another in a relative manner?

• It does not change.

• It changes based on the relative position of the new cell.

• It becomes an absolute reference.

• It turns into a mixed reference.

If you have a formula `=B$3*C1` in cell A1 and you copy it to cell A2, what will the formula in A2 be?

• =B$3*C1

• =B$3*C2

• =B$4*C2

• =B$4*C1

Which of the following formulas uses an absolute reference to refer to cell B1?

• =B1+10

• =$B1+10

• =B$1+10

When would you use a mixed cell reference in a formula?

• When you want the reference to change both column and row when copied.

• When you want the reference to remain fixed when copied.

• When you want the column to change but the row to remain fixed when copied.

• When you want the row to change but the column to remain fixed when copied.

If a formula containing a relative cell reference is moved (not copied) to a different cell, what happens to the reference?

• It adjusts to the new location.

• It stays the same as it was in the original location.

• It becomes an absolute reference.

• It becomes a mixed reference.

What is the difference between a relative cell reference and an absolute cell reference?

• A relative cell reference changes when the formula is copied; an absolute cell reference does not.

• An absolute cell reference changes when the formula is copied; a relative cell reference does not.

• There is no difference; they are just different terms for the same thing.

• A relative cell reference is used for calculations, while an absolute cell reference is used for text.

If you want a cell reference to adjust automatically to its new location when copied but to remain constant when the worksheet is moved, which type of reference should you use?

• Absolute

• Relative

• Mixed

• None of the above