DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Insert Cells
|
|
Insert Sheet Rows
|
|
Insert Sheet Column
|
|
Insert Sheet
|
Detailed explanation-1: -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.
Detailed explanation-2: -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.
Detailed explanation-3: -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.