Question: Cell D2 contains the formula =B2-C2. What is the fastest way to copy that formula into cells D3:D501 (the bottom of the data set)?
- Right-click D2 and select _Fill Down_.
- Click D2's fill handle and drag it down to D501.
- On the ribbon's _Data_ tab, select _Flash fill_.
- Double-click D2's fill handle.
Answer: The correct answer of the above question is Option D:Double-click D2's fill handle.