Project 5

1.       Insert a new worksheet named “CAsoft” with Dark Red tab color to between two available worksheets.

2.       Check the workbook for accessibility and correct only the errors in warning section. Accept all other default settings.

3.       Import file Cong Academy.txt into the cell A2 in the “CAsoft” worksheet as tab-delimited that has header row. Accept all other settings.

4.       On the “Bun” worksheet, create a drop-down list in cell range D2:D15 to allow people to pick an item from the list. The source data for this list is the value of the “Period” column. Accept all other default settings.

5.       On the “Sam” worksheet, sort the invoices in ascending order by the “Region” column then in descending order by the “Quantity” column.

6.       On the “Sam”, create subtotal for data range A1:I38 at each change in “Region” field and use Sum function. Insert Page break between groups. Grand Total should be in cell E2 and G2.

7.       Locate and remove all personal information from this workbook.