TEACHING EXCEL FOR DATA ANALYSIS: HANDS ON PRACTICE 6 FORMATTING CELLS

 In this activity, you will improve the appearance and readability of your sales report using borders, fills, and number formatting.

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

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

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

2. First, let’s apply the proper formatting to our data. The Financial Scorecard worksheet should be open. (If not, click its tab to switch to it.) Select the three cells containing numbers in Column B:

3. Click the dollar icon in the Number group of the Home tab and click $ English (United States):

4. The formatting will be applied. However, we do not need the cents information, so click Decrease Decimal twice:

5. This will remove the decimals from the numbers, but notice that the full value is still available in the formula bar:

6. Now, switch to the Financial Data worksheet:

7. Select cells D2 through H20:

8. Click the dollar icon in the Number group of the Home tab and click $ English (United States):

9. Click the Decrease Decimal button twice to remove the cents values:

10. Review the results:

11. Finally, let’s make the header row stand out a bit more. Select cells A1 to H1:

12. Click the Borders drop-down arrow and click Thick Bottom Border:

13. The border will be added. Now, click the Fill drop-down arrow and choose the color shown here:

14. Click any cell to de-select the header row. Review your formatting changes:

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

16. 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%20WORKING%20WITH%20EXCEL.xlsx