You have been asked to present the sales report data by state and to exclude all corporate information. You will use Excel 365 sorting and filtering tools to accomplish these tasks.
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. Our first task is to sort the data by state. Select cells B2 to B20:
3. Now, click Home → Sort & Filter → Sort Ascending:
4. Select Expand the selection in the Sort Warning dialog box and click Sort:
5. Review the results:
6. Now we want to filter out the corporate data. Select any cell within the data and click Data → Filter:
7. Click the drop-down arrow in cell C1 (Office Type):
8. Click in the checkbox next to Corporate to deselect, then click OK:
9. Review the results, and note the AutoFilter icon in cell C1, the blue row numbers, and the double lines indicating the hidden cells:
10. Save your workbook as Activity 2-5 Complete. Close Microsoft 365 Excel to complete this activity.
11. Now, you can check out an example of a completed document in the link below:
No comments:
Post a Comment