Question

ellen highlights the data in the range a10:a20 in her spreadsheet. she presses ctrl+x. she then uses the mouse to select cells h10:h20, and presses ctrl+v. what operation did ellen just perform? a she deleted the data in both ranges a10:a20 and h10:h20. b she moved the data from the range a10:a20 to the range h10:h20. c she copied the data from the range h10:h20 to the range a10:a20. d she copied the data from the range a10:a20 to the range h10:h20.

Explanation:

In spreadsheet operations, \( \text{CTRL+X} \) is the shortcut for cutting (moving) data, and \( \text{CTRL+V} \) is for pasting. Ellen cut data from A10:A20 (using CTRL+X) and pasted it to H10:H20 (using CTRL+V), which means she moved the data from A10:A20 to H10:H20. Option A is wrong as she didn't delete both; Option C is wrong as she didn't copy from H10:H20; Option D is wrong as she used cut (not copy) for A10:A20.

Answer:

B. She moved the data from the range A10:A20 to the range H10:H20.