FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To customize the sheet tabs in a workbook, choose the ____ command.
A
Freeze Panes
B
Rename
C
Find
D
Replace
Explanation: 

Detailed explanation-1: -To change the color of a sheet tab, right-click the tab, point to Tab Color and pick a color that you want. Tip: Click away from the formatted tab to see the new tab color. If you want to remove the color, right-click the tab, point to Tab Color, and pick No Color.

Detailed explanation-2: -Rename a Sheet Using a Keyboard Shortcut But we can take advantage of the Alt hotkey shortcuts. Alt + H + O + R will get you to the Rename Sheet command in the Home tab.

Detailed explanation-3: -In the Body of the Activity on the right side of the field and then, from the menu, select the file, and then the sheet to rename. If you select Indicate in Excel, you can select any cell or range from the sheet you want to rename directly from the file.

Detailed explanation-4: -These names (Sheet1, Sheet2, Sheet3, and so on) are not very descriptive; you might want to rename your worksheets to reflect what they contain. For instance, if your workbook contains your annual budget, each worksheet within the workbook might contain budgets for individual months.

There is 1 question to complete.