Quiz › Excel Basics › Copying formulas and $

Copying formulas and $: Excel Quiz

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

B1 has =A1*2. You copy it down to B2. What is the formula in B2?
- A. =A2*2
- B. =A1*2
- C. =B1*2
- D. =A2*3
Show the answer
A — =A2*2. A1 has no $, so it moves down one row and becomes A2.
B1 has =$A$1*2. You copy it down to B2. What is the formula in B2?
- A. =$A$2*2
- B. =$A$1*2
- C. =A2*2
- D. =$B$1*2
Show the answer
B — =$A$1*2. $A$1 is locked. It stays the same wherever you copy it.
C1 has =A1+B1. You copy it right to D1. What is the formula in D1?
- A. =A1+B1
- B. =C1+D1
- C. =A2+B2
- D. =B1+C1
Show the answer
D — =B1+C1. Copying one column right moves each letter one step: A to B, B to C.
B1 has =A$1. You copy it down to B5. What is the formula in B5?
- A. =B$1
- B. =A$5
- C. =A$1
- D. =A5
Show the answer
C — =A$1. The $ before 1 locks the row, so it stays A$1.
B1 has =$A1. You copy it right to C1. What is the formula in C1?
- A. =$B1
- B. =B1
- C. =$A1
- D. =$A2
Show the answer
C — =$A1. The $ before A locks the column, so it stays $A1.