Answer :
Final answer:
In Microsoft Excel, you transpose data by copying it from the original range, in this case L1:N2, then pasting with the transpose option in the desired cell, here A2. Afterward, the original data is deleted by selecting the same range again and using the delete key.
Explanation:
The question asks how to perform specific data manipulation tasks in a spreadsheet program like Microsoft Excel. To transpose data from the range L1:N2 in the 'Data' worksheet, you would first select this range by clicking on L1 and dragging to N2 or by using the Shift key to select both cells.
Once selected, you would copy this data. Next, you move to cell A2 and perform a paste special, selecting the transpose option to switch rows to columns. Finally, to clear the original data range L1:N2, select it again and press the delete key.
Deleting columns or rows works by selecting the column or row headings, and then using the 'Delete' command either from the right-click context menu or from the 'Home' tab. In the current scenario, after the data is pasted and transposed to the new location, the original data in L1:N2 should be deleted.