DATABASE FUNDAMENTALS
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: -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-2: -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.
Detailed explanation-3: -The DROP TABLE statement is used to drop an existing table in a database.
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.