DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Work Sheet
|
|
Move or Copy Sheet
|
|
Delete Sheet
|
|
Insert Sheet
|
Detailed explanation-1: –> Select the sheet where you want to insert a new sheet, then go to Insert > Sheet on the Menu bar.-> Right-click on the sheet tab where you want to insert a new sheet and select Insert Sheet from the context menu.-> Click in the empty space at the end of the sheet tabs.
Detailed explanation-2: -Right-click the cell above which you want to insert a new cell. Select Insert, and then select Cells & Shift Down.
Detailed explanation-3: -On the Home tab, in the Cells group, click Insert, and then click Insert Sheet. Tip: You can also right-click the selected sheet tabs, and then click Insert. On the General tab, click Worksheet, and then click OK.
Detailed explanation-4: -Then select the “Insert Sheet” command from the drop-down menu. Alternatively, press the keyboard shortcut of “Shift” + “F11” on your keyboard to automatically insert a new worksheet. If using one of these last two methods, however, note that Excel inserts the new worksheets to the left of the active worksheet.
Detailed explanation-5: -’Shift+F11’ keys are used to insert worksheet in Microsoft Excel.