solve by using excel.

3. Coach Night is trying to choose the starting lineup for the basketball team. The team consists of seven players who have been rated on a scale of 1= poor to 3=excellent) according to their ball-handling, shooting, rebounding, and defensive abilities. The positions that each player is allowed to play and the player's abilities are listed in the table below. Rebounding Ball- Handling 3 2 2 1 3 3 3 Player Position 1 G 2 C 3 G-F 4 F-C 5 G-F FC 7 G-F Shooting 3 1 3 3 Defense 3 2 2 3 2 3 3 2 2 3 3 3 1 2 The five player starting lineup must satisfy the following restrictions: 1. At least 1 members must be able to play guard, at least 2 members must be able to play forward, and at least 1 member must be able to play conter. 2. The average shooting level of the starting lineup must be at least 2. 1. Either player 2 or player 3 mit start Given these constraints. Coach Nicht wants to maximize the total defensibility of the starting te Formate an IP that will help him choose his starting team