FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
When you click the + button (New Sheet) on the tabs bar, where is a worksheet always inserted?
A
At the beginning of the tabs sequence
B
Before the active worksheet
C
After the active worksheet
D
At the end of the tabs sequence
Explanation: 

Detailed explanation-1: -To insert a worksheet, right-click on a worksheet tab and select Insert from the menu. Excel always inserts the spreadsheet to the left of the current worksheet. To delete a worksheet, right-click on the worksheet tab and select Delete from the context menu.

Detailed explanation-2: -Down in the bottom left corner of the screen to the left of the worksheet tabs, you’ll find the worksheet navigation buttons. These nav buttons come into play when you create so many worksheet tabs that they disappear behind the scroll bar divider.

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: -Answer: By double clicking on a worksheet tab in the workbook the worksheet will active. The working sheet is called active worksheet.

There is 1 question to complete.