USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the function of the Insert Sheet Rows option?
|
|
to insert a new cell
|
|
|
to insert a new column
|
|
|
to insert a new row
|
|
|
to insert a new sheet
|
Explanation:
Detailed explanation-1: -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-2: -The insertrow statement inserts a new row into the table field display. Unlike other methods of adding rows to the data set, the insertrow statement allows you to add rows to the beginning, middle, or end of the data set.
Detailed explanation-3: -Luckily, there is an easy keyboard shortcut for this: Ctrl+Shift+Plus. Simply click a row number to select a row, hold down the Ctrl and Shift keys, and press plus (+). Excel will then add a row above the selected row.
There is 1 question to complete.