FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following are True for inserting a row?I.Right-click the row heading where you want to insert the new row and select insert form the popup menuII.Select the row heading where you want to insert the new row then select Rows from the Insert tabIII.Right click on the cell where you want to insert the new row, select insert then select the Entire rowIV.Select the cell where you want to insert the new row and select Home=>Cells=>Insert Sheet Rows
A
I, III, IV
B
II, III
C
II, III, IV
D
I, II, III, IV
Explanation: 

Detailed explanation-1: -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-2: -Click in a cell above or below where you want to add a row. Under Table Tools, on the Layout tab, do one of the following: To add a row above the cell, click Insert Above in the Rows and Columns group. To add a row below the cell, click Insert Below in the Rows and Columns group.

Detailed explanation-3: -Use the mini toolbar to add rows and columns To open the mini toolbar, right-click in a table cell or tap in a selected table cell next to where you want to add a row or column. On the mini toolbar, click Insert and choose where you’d like to insert the row or column.

There is 1 question to complete.
Previous
Next