TEACHING EXCEL FOR DATA ANALYSIS: HANDS ON 21 Formatting worksheet tabs

 

Formatting worksheet tabs

A workbook that details product usage and inventory information has unlabeled tabs. In this activity, you will label these tabs correctly and change their colors.

1. Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.

https://github.com/alcadelina/Excel-

2. Ensure that Sheet1 is displayed. Click Home → Format → Rename Sheet:

3. Type “Product Usage” into the active text field and press Enter:

4. Next, click Home → Format → Tab Color → Blue:

5. Now you need to format the second sheet in this workbook. Right-click Sheet2 and click Rename:

6. Type “Product Inventory” into the active text field and press Enter:

7. Next, right-click on the Product Inventory tab and click Tab Color → Red:

8. Both tabs are now correctly labeled and formatted with contrasting colors:

9. Save your workbook as Activity 5-1 Complete. Close Microsoft 365 Excel to complete this activity.

10. Now, you can check out an example of a completed document in the link below:

https://github.com/alcadelina/Excel-