Microsoft Excel Tutorial: Using Autofill to Copy Formulas

This video tutorial covers the use of the autofill command in Excel to copy formulas efficiently. It explains the steps to use autofill, including selecting the cell with the formula, dragging the fill handle, and using the double-click method for vertical autofill. The tutorial provides examples using the autosum formula and highlights the difference between vertical and horizontal autofill. The session concludes with encouragement to practice and an invitation to ask questions.

What is the first step in using the autofill command in Excel?

• Drag the fill handle to the desired range

• Press ALT + Enter

• Select the cell containing the formula

• Double-click the small '+'

In the example provided, which formula is used to calculate the total of numbers in a row?

• COUNT

• AUTOSUM

• AVERAGE

• SUM

What is the purpose of dragging the small '+' in Excel?

• To delete the formula

• To copy the formula to adjacent cells

• To move the formula to another sheet

• To change the formula

Which method is applicable only for vertical autofill?

• Pressing ALT + Enter

• Double-clicking the small '+'

• Using the insert function option

• Dragging the fill handle

Which autofill method can be used both vertically and horizontally?

• Pressing ALT + Enter

• Using the insert function option

• Double-clicking the small '+'

• Dragging the fill handle