When you use the fill handle to copy a formula across columns,cell references that should NOT change must be ________.
A)mixed
B)absolute
C)relative
D)constant

Question

Quizplus · Accepted Answer

When using the fill handle to copy a formula across columns, cell references that should not change must be made absolute by adding a dollar sign ($) before the column letter and row number (e.g., $A$1). This ensures that the reference remains fixed while the formula is being copied across columns.

When You Use the Fill Handle to Copy a Formula