DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Right-click or access the context menu for a row number, select INSERT
|
|
|
Right-click or access the context menu for a column header, select INSERT
|
|
|
None
|
|
|
Both answer choices
|
Detailed explanation-1: -It is a collection of numbers of rows and columns. Thus the answer is right click on the context menu for a column header and selects the insert option.
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.
Detailed explanation-3: -Click where you want in your table to add a row or column and then click the Layout tab (this is the tab next to the Table Design tab on the ribbon). To add rows, click Insert Above or Insert Below and to add columns, click Insert Left or Insert Right.
Detailed explanation-4: -Explanation: Choose Home→Cells and click the arrow to the right of the Insert button to open the drop-down list for the Insert button. From the menu, choose Insert Sheet Rows or Insert Sheet Columns.