Quiz › Excel Basics › The fill handle

The fill handle: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

A1 = 1 and A2 = 2. You select both and drag the fill handle down to A5. What is in A5?
- A. 5
- B. 10
- C. 1
- D. 2
Show the answer
A — 5. Excel sees the pattern 1, 2 and carries on: 3, 4, 5.
A1 has Mon. You drag the fill handle down to A3. What is in A3?
- A. Tue
- B. Mon3
- C. Wed
- D. Mon
Show the answer
C — Wed. Excel knows the days: Mon, Tue, Wed.
A1 = 5 and A2 = 10. You select both and drag the fill handle down to A4. What is in A4?
- A. 20
- B. 15
- C. 25
- D. 10
Show the answer
A — 20. The step is 5, so: 5, 10, 15, 20.
A1 has Jan. You drag the fill handle right to D1. What is in D1?
- A. Jan4
- B. Mar
- C. Apr
- D. Jan
Show the answer
C — Apr. Excel knows the months: Jan, Feb, Mar, Apr.
A1 has 7. You select only A1 and drag the fill handle down to A3. What is in A3?
- A. 8
- B. 7
- C. 21
- D. 9
Show the answer
B — 7. One number alone has no pattern, so Excel copies it: 7, 7, 7.