DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Cut
|
|
|
Office Clipboard
|
|
|
Workbook Properties
|
|
|
Paste
|
Detailed explanation-1: -If you click a cell and then press DELETE or BACKSPACE, you clear the cell contents without removing any cell formats or cell comments. If you clear a cell by using Clear All or Clear Contents, the cell no longer contains a value, and a formula that refers to that cell receives a value of 0 (zero).
Detailed explanation-2: -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-3: -at the top-left corner of the worksheet, and then click Clear Formats. To remove formatting from a whole column or row, click the column or row heading to select it. To clear formats in non-adjacent cells or ranges, select the first cell or range, press and hold the CTRL key while selecting other cells or ranges.