FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The menu that works to add a new worksheet is ____
A
Insert Sheet Column
B
Insert Sheet
C
Borders
D
Column Width
Explanation: 

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: -The formula tab is used to insert functions, outline the name, produce the name, review the formula, etc.

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

Detailed explanation-4: -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-5: -Right-click the cell above which you want to insert a new cell. Select Insert, and then select Cells & Shift Down.

There is 1 question to complete.
Previous
Next