AutoFill and Flash Fill in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is AutoFill in Excel?

AutoFill is a feature that lets you quickly fill cells with a series of values, like numbers, dates, or text patterns, by dragging the fill handle.

beginner

How does Flash Fill differ from AutoFill?

Flash Fill automatically fills in values based on a pattern you start typing, without dragging. It recognizes patterns and completes data for you.

beginner

How do you activate Flash Fill in Excel?

You can activate Flash Fill by typing the pattern in a cell, then pressing Ctrl + E or by going to the Data tab and clicking the Flash Fill button.

beginner

What happens if you drag the fill handle with AutoFill on a cell containing a date?

Excel will fill the cells with a series of dates, increasing by one day for each cell by default.

beginner

Can AutoFill copy formulas? How?

Yes, dragging the fill handle on a cell with a formula copies the formula to adjacent cells, adjusting cell references automatically.

What does AutoFill do when you drag the fill handle on a cell with the number 1?

A Copies 1 to all cells

B Formats the cells

C Deletes the cells

D Fills cells with 1, 2, 3, 4...

By default, AutoFill copies the value to adjacent cells when dragging the fill handle from a single cell containing a number.

Which shortcut activates Flash Fill in Excel?

A Ctrl + D

B Ctrl + F

C Ctrl + E

D Ctrl + R

Ctrl + E triggers Flash Fill to automatically fill data based on the pattern you typed.

If you want to fill cells with weekdays starting from Monday, which feature helps you?

A AutoFill

B Flash Fill

C Sort

D Filter

AutoFill can fill a series of weekdays by dragging the fill handle.

Flash Fill works best when:

A You format cells as text

B You select multiple cells first

C You use formulas

D You provide a clear pattern in the first cell

Flash Fill detects the pattern you start typing and fills the rest automatically.

What happens if you drag the fill handle on a cell with the text 'January'?

A Copies 'January' to all cells

B Fills cells with February, March, April...

C Deletes the cells

D Fills cells with random months

AutoFill recognizes month names and fills the series in order.

Explain how AutoFill can save time when entering dates or numbers in Excel.

Think about how you fill a calendar or numbered list quickly.

Describe a situation where Flash Fill would be more useful than AutoFill.

Consider when you want to split or combine text based on a pattern.