How do you apply AutoFill to copy a formula from E2 to E3:E6?

How do you apply AutoFill to copy a formula from E2 to E3:E6?

• A. Copy and paste manually.
• B. Use the Fill Without Formatting option.
• C. Use the Paste Special command.
• D. Drag the bottom right corner down.

Answer: (D)

AutoFill works by using the fill handle to extend a pattern or formula. To copy a formula from E2 to E3:E6, grab the small square at the bottom-right corner of E2 (the fill handle) and drag it down to E6. As you release, the formula is copied into each cell and any relative references shift to match the new row, so E3 gets the next version of the formula, and so on. This is the quickest way to propagate a formula down a column. If you need certain references to stay fixed, use absolute references (like $A$1) inside the formula; otherwise dragging will adjust them automatically. Other methods (manual copy-paste, or Paste Special variants) require more steps or don’t leverage the automatic reference updating.

AutoFill works by using the fill handle to extend a pattern or formula. To copy a formula from E2 to E3:E6, grab the small square at the bottom-right corner of E2 (the fill handle) and drag it down to E6. As you release, the formula is copied into each cell and any relative references shift to match the new row, so E3 gets the next version of the formula, and so on. This is the quickest way to propagate a formula down a column. If you need certain references to stay fixed, use absolute references (like $A$1) inside the formula; otherwise dragging will adjust them automatically. Other methods (manual copy-paste, or Paste Special variants) require more steps or don’t leverage the automatic reference updating.