DATABASE FUNDAMENTALS
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: -Click in your Office file at the place you wish to insert that item. On the Home tab, in the Clipboard group, click the arrow under Paste, click Paste Special, and then choose one of the options below. Tip: If you’d prefer to use the keyboard you can press CTRL+ALT+V to invoke Paste Special.
Detailed explanation-3: -Excel Paste Special makes the pasting operation smoother by letting you choose which formatting (source or destination) to keep or by stripping all formatting and just pasting the values or formulas.
Detailed explanation-4: -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-5: -Paste Special options. Select the cells that contain the data or other attributes that you want to copy. On the Home tab, click Copy . Click the first cell in the area where you want to paste what you copied. On the Home tab, click the arrow next to Paste, and then select Paste Special.