AutoFill and Flash Fill in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to fill cells with a series of numbers starting from 1.

Excel

Select cell A1 and enter 1. Then drag the fill handle down to cell A[1].

Drag options to blanks, or click blank then click option'

A5

B10

C20

D15

Attempts:

3 left

💡 Hint

Common Mistakes

Dragging too far and filling unwanted cells

Not starting with the number 1 in cell A1

Dragging the fill handle down to cell A5 will fill cells A1 to A5 with numbers starting from 1.

2fill in blank

medium

Complete the code to use Flash Fill to separate first names from full names in column A into column B.

Excel

Type the first name from cell A2 into cell B2. Then select B2 and press [1] to activate Flash Fill.

Drag options to blanks, or click blank then click option'

ACtrl + C

BCtrl + V

CCtrl + E

DCtrl + X

Attempts:

3 left

💡 Hint

Common Mistakes

Using copy or paste shortcuts instead of Flash Fill

Not typing the example first before using Flash Fill

Pressing Ctrl + E activates Flash Fill in Excel, which automatically fills the column based on the pattern you started.

3fill in blank

hard

Fix the error in the instruction to fill dates incrementing by 1 day starting from 1/1/2024 in cell A1.

Excel

Enter 1/1/2024 in A1 and 1/2/2024 in A2. Then select both cells and drag the fill handle down to [1].

Drag options to blanks, or click blank then click option'

AA10

BA5

CA15

DA20

Attempts:

3 left

💡 Hint

Common Mistakes

Dragging too few cells and not filling enough dates

Dragging too far and filling unwanted dates

Dragging down to A10 fills dates from 1/1/2024 to 1/10/2024 incrementing by 1 day.

4fill in blank

hard

Fill both blanks to create a Flash Fill formula that extracts the domain from email addresses in column A into column B.

Excel

Type the domain from A2 into B2 (e.g., example.com). Then select B2 and press [1] to activate Flash Fill. If Flash Fill does not work, go to the Data tab and click [2].

Drag options to blanks, or click blank then click option'

ACtrl + E

BFlash Fill button

CCtrl + F

DSort button

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong shortcuts like Ctrl + F

Clicking unrelated buttons like Sort

Ctrl + E activates Flash Fill shortcut. The Flash Fill button on the Data tab also triggers Flash Fill.

5fill in blank

hard

Fill all three blanks to create a formula that uses AutoFill to create a series of multiples of 3 starting from 3 in cell A1.

Excel

Enter [1] in A1. Enter [2] in A2. Select both cells and drag the fill handle down to [3].

Drag options to blanks, or click blank then click option'

A3

B6

CA10

DA15

Attempts:

3 left

💡 Hint

Common Mistakes

Entering wrong starting numbers

Dragging too few or too many cells

Starting with 3 and 6 in A1 and A2, dragging down to A10 fills multiples of 3 up to 30.