Part $1$: The werkheets are reguired for part $2.$

Slop Gaupany produces cauputers. The following table contains monthly data regarding Warhank's numufacturing costs, production volumes, machine bours, and parts.

$\backslash$table$[[$Menth$,\backslash$table$[[$Total$],[$Manifacturing$],[$Cosits$]],\backslash$table$[[$Conoputers$],[$Produced$]],\backslash$table$[[$Number of$],[$Machine Hours$]],\backslash$table$[[$Nomber of$],[$Parts$]]],[$Jamury$,$$$1,709,880,23,800,25,000,9,500],[$Felruary$,$$$1,708,550,23,800,25,000,10,100],[$March$,$$$1,667,130,22,750,17,500,7,400],[$April$,$$$2,647,000,24,780,20,150,15,400],[$May$,$$$1,918,680,24,330,17,500,13,160],[$June$,$$$1,907,030,23,950,20,500,13,600],[$July$,$$$1,785,650,23,800,21,250,10,300],[$August$,$$$1,569,750,22,750,17,500,6,800],[$September$,$$$1,698,350,22,750,18,250,8,560],[$October$,$$$1,904,000,24,250,23,150,13,250],[$November$,$$$1,906,330,23,800,20,500,13,800],[$December$,$$$1,596,150,23,150,22,750,7,900]]$

Requirements: Complete requirements $1-5($except for $1.$a$.$i$)$ on a single workheet. Requirements $6-8$ will be completed on a second workheet.

Eater the above data in a worksheet.

a$.$ Convert the data to a Table.

i$.$ Copy the table that you just created in part Ia to a new workheet for use with reguirements $6-8$ BEFORE you do requiremeras $2-5.$

Change the Table name to: SLOP.

a$.$ Sort the records in ascending order based on the number of parts used.

Add a Field named Computer Cost.

a$.$ Add a fommia in the Computer Cost field that calculates the cost per computer.

The formula may NOT use Field Names.

Add a Field named Machine Hours.

a$.$ Add a formula in the Machine Hours Field that calculates the machine hours per computer.

i$.$ The formila MUST use Field Names.

Add a filter to the Total Manufacturing Costs column.

a$.$ The flter must result in only the records with the seven highest Totsl

Manufacturing Costs being displayed.

b$.$ You may NOT complete this by using the check boxes in the Filter Butrou tool.

Use the worksket you that created in part $1.$a$.$i above to complete recquirements $6-8.$

$6.$ Sort the data in the following order:

a$.$ Dexcending by Computers Produced, then

b$.$ Ascending by Number of Machime Hours, then

c$.$ Deycending by Month.