DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS 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: -To insert columns: The new column will appear to the left of the selected column.
Detailed explanation-2: -To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns. To insert multiple columns: Select the same number of columns to the right of where you want to add new ones. Right-click the selection, and then select Insert Columns.
Detailed explanation-3: -1. To insert a column, you need to select the necessary one and right click on it. 2. Then pick Insert-> Table Columns to the Right for the last column or Table Columns to the Left.
Detailed explanation-4: -Answer: Simply right-click on any cell in a column, right-click and then click on Insert. This will open the Insert dialog box where you can select ‘Entire Column’. This would insert a column to the left of the column where you selected the cell.