FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To insert a Sheet after selecting the Insert menu on Home then select the sub menu ____
A
Work Sheet
B
Move or Copy Sheet
C
Delete Sheet
D
Insert Sheet
Explanation: 

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.

There is 1 question to complete.