You are working on a worksheet in Excel 2010. You have entered few data in the sheet as shown below:
You need to change that in the format given below:
Which of the following steps will you take to accomplish the task?
A.
Use the Inverse Paste Special option.
B.
Use the Rows to Columns Paste Special option.
C.
Use the Transpose Paste Special option.
D.
Use the Flip Rows and Columns Paste Special option.
Explanation:
According to the question, you are required change entries in which column values are needed to be
written in rows and row values in columns. In order to accomplish the task, you will have to use the
Transpose Paste Special option. The Transpose Paste Special option can be used to accomplish the task.