USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
clicking the Delete command in the Clipboard group on the Home tab
|
|
|
pressing the DELETE key
|
|
|
clicking the DELETE DATA TABLE command on a shortcut menu
|
|
|
pressing the OVERTYPE key
|
Detailed explanation-1: -Method 1: Deleting the Entire Table. If you want to delete the entire table, including the header row and all the data, you can do so by selecting the table and then pressing the Delete key on your keyboard. Once youve selected the table, press the Delete key and the table will be removed.
Detailed explanation-2: -The DROP TABLE statement is used to drop an existing table in a database.
Detailed explanation-3: -To delete a table from the database. In Object Explorer, select the table you want to delete. Right-click the table and choose Delete from the shortcut menu. A message box prompts you to confirm the deletion.
Detailed explanation-4: -Click any cell within a table, and then press Ctrl + A twice to select the whole table including the headers. On the Home tab, in the Editing group, click Clear > Clear Formats.
Detailed explanation-5: -If your Excel worksheet has data in a table format and you no longer want the data and its formatting, here’s how you can remove the entire table. Select all the cells in the table, click Clear and pick Clear All. Tip: You can also select the table and press Delete.