DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
true
|
|
|
false
|
|
|
X
|
|
|
X
|
Detailed explanation-1: -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-2: -On the Home tab, under Edit, click Paste, and then click Paste Special. Paste all cell contents and formatting, including linked data.
Detailed explanation-3: -Under the “Home” tab, select the “Paste” button to see the different paste options.
Detailed explanation-4: -You can use Paste Special to multiply the positive number(s) by-1. Enter-1 into a blank cell and copy that cell. Then select the cells that need to be converted to a negative number and choose Paste Special from the Home tab. Select Multiply and click OK. Pasting into Word and PowerPoint.