USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Clear
|
|
|
Copy
|
|
|
Cut
|
|
|
Format Painter
|
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: -Clear the formatting in cell range A4:D4 on the Rental Rates worksheet. Select cell range A4:D4 on the Rental Rates worksheet. On the Home tab, in the Editing group, click Clear and select Clear Formats.
Detailed explanation-3: -Right click on one of the selected cells and choose “Clear Contents". Your formulas remain, but the rest of the cells are cleared.
Detailed explanation-4: -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!