Please add steps

1. The Purchase Orders Excel file provides information about the POs characterized by auniqueOrderNo.
   1. Use the COUNTIF function to determine how many O-Ring, Electrical Connector, andShieldedCable weresoldseparately.
   2. Use an appropriate function to determine the number of Electrical Connectors sold byHulkeyFasteners.

Modify the spreadsheet so the sheet is grouped together according to the suppliernames.

Purchase Orders
Supplier	Order No.	Item No.	Item Description	Item Cost	Quantity	Cost per order	A/P Terms (Months)	Order Date	Arrival Date
Hulkey Fasteners	Aug11001	1122	Airframe fasteners	$ 4.25	19,500	$ 82,875.00	30	08/05/11	08/13/11
Alum Sheeting	Aug11002	1243	Airframe fasteners	$ 4.25	10,000	$ 42,500.00	30	08/08/11	08/14/11
Fast-Tie Aerospace	Aug11003	5462	Shielded Cable/ft.	$ 1.05	23,000	$ 24,150.00	30	08/10/11	08/15/11
Fast-Tie Aerospace	Aug11004	5462	Shielded Cable/ft.	$ 1.05	21,500	$ 22,575.00	30	08/15/11	08/22/11
Steelpin Inc.	Aug11005	5319	Shielded Cable/ft.	$ 1.10	17,500	$ 19,250.00	30	08/20/11	08/31/11
Fast-Tie Aerospace	Aug11006	5462	Shielded Cable/ft.	$ 1.05	22,500	$ 23,625.00	30	08/20/11	08/26/11
Steelpin Inc.	Aug11007	4312	Bolt-nut package	$ 3.75	4,250	$ 15,937.50	30	08/25/11	09/01/11
Durrable Products	Aug11008	7258	Pressure Gauge	$ 90.00	100	$ 9,000.00	45	08/25/11	08/28/11
Fast-Tie Aerospace	Aug11009	6321	O-Ring	$ 2.45	1,300	$ 3,185.00	30	08/25/11	09/04/11
Fast-Tie Aerospace	Aug11010	5462	Shielded Cable/ft.	$ 1.05	22,500	$ 23,625.00	30	08/25/11	09/02/11
Steelpin Inc.	Aug11011	5319	Shielded Cable/ft.	$ 1.10	18,100	$ 19,910.00	30	08/25/11	09/05/11
Hulkey Fasteners	Aug11012	3166	Electrical Connector	$ 1.25	5,600	$ 7,000.00	30	08/25/11	08/29/11
Hulkey Fasteners	Aug11013	9966	Hatch Decal	$ 0.75	500	$ 375.00	30	08/25/11	08/31/11
Steelpin Inc.	Aug11014	5234	Electrical Connector	$ 1.65	4,500	$ 7,425.00	30	08/28/11	09/05/11
Steelpin Inc.	Sep11001	4312	Bolt-nut package	$ 3.75	4,200	$ 15,750.00	30	09/01/11	09/10/11
Alum Sheeting	Sep11002	5417	Control Panel	$ 255.00	406	$ 103,530.00	30	09/01/11	09/10/11
Hulkey Fasteners	Sep11003	3166	Electrical Connector	$ 1.25	5,500	$ 6,875.00	30	09/01/11	09/06/11
Steelpin Inc.	Sep11004	5234	Electrical Connector	$ 1.65	4,850	$ 8,002.50	30	09/02/11	09/11/11
Steelpin Inc.	Sep11005	4312	Bolt-nut package	$ 3.75	4,150	$ 15,562.50	30	09/03/11	09/11/11
Hulkey Fasteners	Sep11006	1122	Airframe fasteners	$ 4.25	15,500	$ 65,875.00	30	09/04/11	09/12/11
Spacetime Technologies	Sep11007	4111	Bolt-nut package	$ 3.55	4,800	$ 17,040.00	25	09/05/11	09/20/11
Alum Sheeting	Sep11008	1243	Airframe fasteners	$ 4.25	9,000	$ 38,250.00	30	09/05/11	09/12/11
Durrable Products	Sep11009	7258	Pressure Gauge	$ 90.00	120	$ 10,800.00	45	09/05/11	09/09/11