TEACHING EXCEL FOR DATA ANALYSIS: HANDS ON PRACTICE 7 ALIGNING CELL CONTENT

 In this activity, you will use alignment tools to improve the appearance of your financial data 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/ALIGNING%20CELL%20CONTENT.xlsx

2. First, select columns D through H:

3. Click the Format drop-down arrow in the Cells group of the Home tab:

4. Enter 15 in the Column width field of the Column Width dialog box, then click OK:

5. Now, select Row 1, then click Home → Wrap Text:

6. Click the Middle Align button in the Alignment group of the Home tab:

7. Now select cells D1 through H1 and click the Center button:

8. Now that the financial data is neatly arranged with a well-formatted header row, select cells A1 through C20, then click the Increase Indent button:

9. To adjust the cell width, click Home → Format drop-down arrow → AutoFit Column Width:

10. Now select cell A1 and click Home → Format Painter, to copy the cell formatting. Once done, switch to the Financial Scorecard worksheet:

11. Click on cell A1 to apply the format:

12. Finally, select cells A1 through B1, then click Home →Merge & Center:

13. The cells are now merged and centered, and the formatting from cell A1 has also been applied to cell B1:

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

15. 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/COMPLETED%20EXERCISE%20ALIGNING%20CEL%20CONTENT.xlsx