Machine-translated by Google. Questions are authored in English.
Top

Discussion

What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20?

  • A.Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows
  • B.Select the range you want, include both cells, point to fill on the Edit menu, and then click down.
  • C.Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special
  • D.All of above

Answer: A

Correct answer: Select both cells, and then drag the fill handle over the range you want, for instance 18 more cells

Two cells establish the step, and dragging the fill handle continues it. One cell alone would be copied rather than extended, since Excel would have no interval to work from.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.