USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Above the current row.
|
|
|
You must copy and paste any existing data down one row to have a blank row at the cursor position.
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -When you insert a row, where does Excel place it in relation to the cursor position? Below the current row. You must select the row before you can insert a new row. You must copy and paste any existing data down one row to have a blank row at the cursor position.
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: -To insert a row, pick a cell or row that’s not the header row, and right-click. To insert a column, pick any cell in the table and right-click. Point to Insert, and pick Table Rows Above to insert a new row, or Table Columns to the Left to insert a new column.
Detailed explanation-4: -You may also use the Format button in the Cells group of the ribbon to set a specific column width. From the dropdown menu, you will choose Column Width or Row Height and manually type in the size you wish each column (or row) to be.
Detailed explanation-5: -To insert a new worksheet in front of an existing worksheet, select that worksheet and then, on the Home tab, in the Cells group, click Insert, and then click Insert Sheet. Tip: You can also right-click the tab of an existing worksheet, and then click Insert. On the General tab, click Worksheet, and then click OK.