USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Deleting the contents of a cell clears all formatting from the cell. If you use the Delete Cells command, the formatting is still applied to the cell.
|
|
|
Deleting the contents of a cell places the deleted contents into the Clipboard. If you use the Delete Cells command, the cell contents are not copied to the Clipboard.
|
|
|
Deleting the contents of a cell leaves the structure of the worksheet intact. If you use the Delete Cells command, you have the option of shifting the cells after the delete action is complete.
|
|
|
Deleting the contents of a cell leaves any formatting still applied. If you use the Delete Cells command, the formatting is also cleared from the cell.
|
Detailed explanation-1: -If you use the Delete Cells command, the cell contents are not copied to the Clipboard. Deleting the contents of a cell leaves the structure of the worksheet intact. If you use the Delete Cells command, you have the option of shifting the cells after the delete action is complete.
Detailed explanation-2: -Clearing cells means erasing everything within them, whereas deleting actually deletes the entire cell (or cells).
Detailed explanation-3: -Notes: 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-4: -Pressing the Delete key to remove the contents from a cell will not remove the conditional formatting. This is in the same way that pressing the Delete key does not remove the number format.
Detailed explanation-5: -If you want to clear all content and formatting from cells, you can use the Clear All shortcut. To do this, select the cells you want to clear, then press the Ctrl + Shift + A keys on your keyboard. This shortcut will instantly clear all content and formatting from the selected cells. That’s all there is to it!