TEACHING EXCEL FOR DATA ANALYSIS: HANDS ON PRACTICE 4 WORKING WITH ROWS AND COLUMNS

 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/WORKING%20WITH%20ROWS%20AND%20COLUMNS.xlsx

2. The Financial Scorecard worksheet should be open. (If not, click its tab to switch to it.) You can see that Column A overlaps Column B, which is blank. Double-click the separator between these two columns to automatically resize Column A:

3. Now, right-click the Column B header and click Delete:

4. The scorecard should look like this:

5. Our next task is to improve the layout of the Scorecard title. Select cells A1 and B1:

6. Click Home → Merge & Center:

7. Cells A1 and B1 will now look like this:

8. Now, switch to the Financial Data worksheet:

9. The scorecard data is duplicated on this sheet, so let’s remove it. Select cells J1 to L4:

10. Click Home → Clear drop-down arrow → Clear All:

11. The data is now removed. Finally, let’s resize this sheet’s columns. Since we have many columns to resize, we will use a slightly different method. Click the selector icon in the top left corner of the data to select the entire worksheet:

12. Click Format → AutoFit Column Width:

13. Review the results:

14. Save your workbook as Activity 2-4 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%20WORKING%20WITH%20ROWS%20AND%20COLUMNS.xlsx