USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Putting data or cell contents in a location with option to just insert the values only, formatting, or perform operations on data.
|
|
Fill
|
|
|
Flash Fill
|
|
|
Paste Special
|
|
|
Replace Data
|
Explanation:
Detailed explanation-1: -Transpose Data Click the cell where you want to paste the data. Click the Paste list arrow. To preview a paste option before you commit to it, click the Paste list arrow and hold the mouse over the paste option. Select Transpose.
Detailed explanation-2: -Right-click the cell where you want to paste (B4), choose Paste special and Paste all except borders.
Detailed explanation-3: -You can move cells in Excel by drag and dropping or using the Cut and Paste commands. Select the cells or range of cells that you want to move or copy. Point to the border of the selection., drag the cell or range of cells to another location.
There is 1 question to complete.