DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Answer. Answer: If you click a cell and then press DELETE or BACKSPACE, you clear the cell contents without removing any cell formats or cell comments.
Detailed explanation-2: -It is located directly above the spreadsheet. Excel formula bar is a special toolbar at the top of the Excel worksheet window. You can use it to enter a new formula or copy an existing one. The formula bar displays information entered in the current or active cell.
Detailed explanation-3: -Clear Formatting Highlight the portion of the spreadsheet from which you want to remove formatting. Click the Home tab. Select Clear from the Editing portion of the Home tab. From the drop down menu of the Clear button, select Clear Formats.
Detailed explanation-4: -To delete multiple cells, first select the cells you want to delete. Then, press the Delete key on your keyboard. This will delete the contents of the cells and shift the cells to the left. If you want to delete the cells and shift the cells to the right, press the Shift+Delete keys.