TEACHING EXCEL FOR DATA ANALYSIS: HANDS ON PRACTICE 5 FORMATTING TEXT

 In this activity, you will format header rows and a title in your worksheet.

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-

https://github.com/alcadelina/Excel-/blob/main/FORMATTING%20TEXT.xlsx

2. First, let’s format the header row of the Financial Data sheet. Select Row 1:

3. Click the Increase Font Size button twice:

4. The value in the Size menu should now be 14:

5. Apply the Bold effect:

6. Click the drop-down arrow next to the Font Color command:

7. Click the Blue swatch in the Standard Colors palette:

8. Because of the font changes, the data no longer fits in the cells. Press Ctrl + A to select the entire worksheet. Click Home → Format → AutoFit Column Width:

9. Now, let’s copy the header row formatting to the second sheet. Click any cell in Row 1 to select it and click Home → Format Painter:

10. Click the Financial Scorecard worksheet tab:

11. Click cell A1:

The formatting will be applied; notice that the Merge & Center formatting option has been removed as part of this process. We will fix this in a later activity.

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

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

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

https://github.com/alcadelina/Excel-/blob/main/EXCEL%20EXERCISE%20FORMATTING%20TEXT.xlsx