To get the effect of a calculated column in a range of data you must copy and paste the formula or use the ____ feature.
A)Concatenation
B)Merged
C)AutoFill
D)Indexed

Question

Quizplus · Accepted Answer

AutoFill is the feature in Excel that allows you to copy a formula or pattern to a range of cells. This will apply the same formula to all cells in the range, so you can easily get the effect of a calculated column in a range of data. Simply select the cell with the formula and drag the fill handle (a small square in the bottom right corner of the cell) across the desired range of cells.

To Get the Effect of a Calculated Column in a Range