DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
only the contents
|
|
|
only the formatting
|
|
|
both the contents and formatting
|
|
|
None of the above
|
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: -Clearing cells means erasing everything within them, whereas deleting actually deletes the entire cell (or cells).
Detailed explanation-3: -clear removes cell contents and certain types of formatting when specified. . delete removes the entire cell and whatever formatting and shifts the rest of the documents in to cover the gap.
Detailed explanation-4: -The Backspace key will only delete content from one cell at a time.
Detailed explanation-5: -Edit>Clear>Contents or just hit the delete key.