FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -To quickly insert a new worksheet at the end of the existing worksheets, click the Insert Worksheet tab at the bottom of the screen. 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.

Detailed explanation-2: -’Shift+F11’ keys are used to insert worksheet in Microsoft Excel.

Detailed explanation-3: -First ensure that the Show sheet tabs is enabled. To do this, For all other Excel versions, click File > Options > Advanced-in under Display options for this workbook-and then ensure that there is a check in the Show sheet tabs box.

Detailed explanation-4: -Right-click the cell above which you want to insert a new cell. Select Insert, and then select Cells & Shift Down.

Detailed explanation-5: -On the worksheet, click a cell. Type the numbers or text that you want to enter, and then press ENTER or TAB. To enter data on a new line within a cell, enter a line break by pressing ALT+ENTER.