Please include steps

1. The Purchase Orders Excel file provides information about the POs characterized by a unique Order No.
   1. Use the COUNTIF function to determine how many O-Ring, Electrical Connector, and Shielded Cable were sold separately.
   2. Use an appropriate function to determine the number of Electrical Connectors sold by Hulkey Fasteners.

Modify the spreadsheet so the sheet is grouped together according to the supplier names.

Supplier	Item No.	Item Description	Order Date	Arrival Date
Hulkey Fasteners	1122	Airframe fasteners	08/05/11	08/13/11
Alum Sheeting	1243	Airframe fasteners	08/08/11	08/14/11
Fast-Tie Aerospace	5462	Shielded Cable/ft.	08/10/11	08/15/11
Fast-Tie Aerospace	5462	Shielded Cable/ft.	08/15/11	08/22/11
Steelpin Inc.	5319	Shielded Cable/ft.	08/20/11	08/31/11
Fast-Tie Aerospace	5462	Shielded Cable/ft.	08/20/11	08/26/11
Steelpin Inc.	4312	Bolt-nut package	08/25/11	09/01/11
Durrable Products	7258	Pressure Gauge	08/25/11	08/28/11
Fast-Tie Aerospace	6321	O-Ring	08/25/11	09/04/11
Fast-Tie Aerospace	5462	Shielded Cable/ft.	08/25/11	09/02/11
Steelpin Inc.	5319	Shielded Cable/ft.	08/25/11	09/05/11
Hulkey Fasteners	3166	Electrical Connector	08/25/11	08/29/11
Hulkey Fasteners	9966	Hatch Decal	08/25/11	08/31/11
Steelpin Inc.	5234	Electrical Connector	08/28/11	09/05/11
Steelpin Inc.	4312	Bolt-nut package	09/01/11	09/10/11
Alum Sheeting	5417	Control Panel	09/01/11	09/10/11
Hulkey Fasteners	3166	Electrical Connector	09/01/11	09/06/11
Steelpin Inc.	5234	Electrical Connector	09/02/11	09/11/11
Steelpin Inc.	4312	Bolt-nut package	09/03/11	09/11/11
Hulkey Fasteners	1122	Airframe fasteners	09/04/11	09/12/11
Spacetime Technologies	4111	Bolt-nut package	09/05/11	09/20/11
Alum Sheeting	1243	Airframe fasteners	09/05/11	09/12/11