DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You no longer need a certain column in the worksheet.
|
|
Delete sheet row
|
|
|
Delete sheet column
|
|
|
Insert sheet column
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Select all blank columns-click on the first column letter, press Shift, and then click the letter of the last blank column. Right-click the selected columns and choose Delete from the pop-up menu.
Detailed explanation-2: -Columns in an Excel worksheet are ALWAYS named A, B, C, … It doesn’t matter if you insert or delete columns. Afterwards, the columns will still be A, B, C, … The column letters are just a way to refer to columns; they don’t have an intrinsic meaning.
There is 1 question to complete.