DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Backstage View
|
|
|
Background
|
|
|
Keyboard
|
|
|
Clipboard
|
Detailed explanation-1: -By default when you copy (or cut) and paste in Excel, everything in the source cell or range-data, formatting, formulas, validation, comments-is pasted to the destination cell(s). This is what happens when you press CTRL+V to paste.
Detailed explanation-2: -When you cut a cell, its content is removed from the original location and placed in the Clipboard.
Detailed explanation-3: -The Office Clipboard allows you to copy up to 24 items from Office documents or other programs and paste them into another Office document. For example, you can copy text from an email message, data from a workbook or datasheet, and a graphic from a presentation, and then paste them all into a document.
Detailed explanation-4: -The Office Clipboard stores text and graphics that you copy or cut from anywhere, and it lets you paste the stored items into any other Office file.