USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Use the Paste Special command instead, and select the Formats option.
|
|
|
Use the Paste Special command instead, and select the Values option.
|
|
|
Use the Paste Special command instead, and select the All using Source theme option.
|
|
|
Use the Paste Special command instead, and select the Transpose option.
|
Detailed explanation-1: -Suppose you used the Copy and then the Paste command to copy the contents of cells A1 to cell B1, but you do not want to copy the cell formatting to cell B1. What can you do to fix it? Use the Paste Special command instead, and select the Values option.
Detailed explanation-2: -Select the cell or range of cells. Select Copy or press Ctrl + C. Select Paste or press Ctrl + V.
Detailed explanation-3: -When you paste formula cells using the paste button in the clipboard group, which of the following is true? The paste options button then lets you paste specific elements of the copied cells.
Detailed explanation-4: -Right-click on the top-right cell and look for “Paste Options” in the drop-down menu. Choose the icon that shows text reading “Transpose” when you hover your mouse over it.
Detailed explanation-5: -Which of the following is true when you copy and paste formulas using the fill handle? The AutoFill Options button lets you fill cells with specific elements of the copied cell.