USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
At the beginning of the tabs sequence
|
|
|
Before the active worksheet
|
|
|
After the active worksheet
|
|
|
At the end of the tabs sequence
|
Detailed explanation-1: -The fastest method is to click on the Add Sheet (+) icon located to the left of the sheet tabs, at the bottom of the spreadsheet. This inserts one new sheet without opening any dialog, with a default name (Sheet2, for example) and with the new sheet’s tab positioned at the right hand end of the sheet tabs.
Detailed explanation-2: -The “Activate” tab shows the active worksheet available to edit. By default, there can be three worksheet tabs opened. We can insert more tabs in the worksheet using the plus button provided at the end of the tabs. We can also rename or delete any of the worksheet tabs.
Detailed explanation-3: -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-4: -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.