USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Multiply the selection by a copied value
|
|
|
Cell comments
|
|
|
Formatting options
|
|
|
The resulting values of a formula instead of actual formula
|
Detailed explanation-1: -To use options from the Paste Special box, select Home, select the clipboard icon (Paste), and select Paste Special. Keyboard Shortcut: Press Ctrl+Alt+V.
Detailed explanation-2: -Excel pastes the values of the copied cell into the selected cell. Whenever you paste data, the Paste Options Smart Tag appears next to the selected cell. You can also paste values by clicking this tag and selecting a paste option from the list.
Detailed explanation-3: -Paste Special can paste numbers with the formatting of the destination where they are being pasted. To do this, copy the numbers to be pasted. Choose Paste Special from the Home tab, select Values and number formats, and click OK.
Detailed explanation-4: -Select the cell(s) with formulas and press Ctrl + C to copy them. Select the destination range. If you don’t need to keep the formulas, you can select the same range that you’ve just copied (cells with formulas). Press Excel’s paste values shortcut: Ctrl + Alt + V, then V.
Detailed explanation-5: -When you copy text that has different formatting into an Office program, the program, such as PowerPoint or Word, automatically reformats that text to match the text of the destination. However, you can use Paste Special to maintain the original formatting or paste it as a link or a picture, for example.