Microsoft Excel Tutorial: Using Autofill to Copy Formulas

Microsoft Excel Tutorial: Using Autofill to Copy Formulas

Assessment

Interactive Video

Engineering

10th Grade - University

Hard

Created by

Quizizz Content

FREE Resource

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.

Read more

2 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

Describe the difference between autofilling vertically and horizontally in Excel.

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What should you do if the double click method does not work for horizontal autofill?

Evaluate responses using AI:

OFF