Gerald has copied a 2 × 5 data set and is trying to paste it into an Excel worksheet, but he

selected a data range in the middle of an existing data set. What risk is Gerald running?
(1 point)
The data won’t be formatted correctly.
Not all the copied data will transfer.
He’ll replace existing data.
He’ll get an error message saying he can’t paste.

1 answer

Gerald is running the risk that he'll replace existing data. When pasting copied data into a selected range that overlaps with existing data, the new data will overwrite any data currently in that range.