USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Ctrl+X then Ctrl+V
|
|
|
Ctrl+X then Ctrl+Z
|
|
|
Ctrl+C then Ctrl+V
|
|
|
Ctrl+V then Ctrl+Z
|
Detailed explanation-1: -Select Copy or press Ctrl + C. Select Paste or press Ctrl + V.
Detailed explanation-2: -In computing, a Control key Ctrl is a modifier key which, when pressed in conjunction with another key, performs a special operation (for example, Ctrl + C ); similar to the Shift key, the Control key rarely performs any function when pressed by itself.
Detailed explanation-3: -(ConTRoL-V) In a Windows PC, holding down the Ctrl key and pressing the V key pastes the contents of the clipboard into the current cursor location.
Detailed explanation-4: -Smart filling Ctrl+E can help us merge data scattered in different columns into the same column. Take this worksheet as an example. We will merge the characters from column A to D into column E. After inputting, press the shortcut key Ctrl+E to merge the scattered data of each columnquickly.
Detailed explanation-5: -To undo an action press Ctrl+Z. If you prefer your mouse, click Undo on the Quick Access Toolbar. You can press Undo (or CTRL+Z) repeatedly if you want to undo multiple steps.