DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Deleting a row or column erases the data in that row or column.
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Delete a row or column Select a row or column that you want to delete. Press Backspace, or select the Table Tools Layout tab >Delete, and then select an option. Note: In Excel, select a row or column that you want to delete, right-click and select Delete, and choose the option you want.
Detailed explanation-2: -Insert or delete a column Select any cell within the column, then go to Home > Insert > Insert Sheet Columns or Delete Sheet Columns.
Detailed explanation-3: -In Excel, using key combination Ctrl +-you can delete any number of selected rows and columns.
There is 1 question to complete.