DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To insert another row or column,
|
|
Right click on a cell and choose insert
|
|
|
Click on Insert Row/Column in the Home Tab/Cells group
|
|
|
Highlight a row or column, right click and choose insert.
|
|
|
Both B & C are correct.
|
Explanation:
Detailed explanation-1: -In this example, we’ve selected cell B3 because we want to insert a new column between column A and column B. Right-click and select “Insert” from the popup menu. When the Insert window appears, select the “Entire column” option and click on the OK button. A new column should now be inserted in the spreadsheet.
Detailed explanation-2: -To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which you want to add new ones. Right-click the selection, and then select Insert Rows.
There is 1 question to complete.