please explain how to solve in excel

1. The following questions refer to the CRT Technologies project selection example presented in this chapter. Formulate a constraint to implement the conditions described in each of the following statements. Write the notation form of each constraint in a textbox and solve the optimization (Ex: X1+X2=1). Out of projects 1, 2, 4, and 6, CRT's management wants to select exactly two projects. Project 2 can be selected only if project 3 is selected and vice-versa. If projects 2 and 4 are undertaken, then project 5 must also be undertaken. CRT Technologies Select? Project (0-no, 1-yes) NPV 1 0 $141 2 0 $187 3 $121 4 0 $83 5 0 $265 E 0 $127 Capital Required Capital Available Year 1 $75 $90 $60 $30 $100 $50 Capital Required in Year 2 Year 3 Year $ $25 $20 $15 $35 $0 $0 $15 $15 $15 $20 $10 $5 $25 $20 $20 $20 $10 $30 Year 5 $10 $30 $15 $5 $20 $40 $250 $75 $50 $50 $50 Total Net Present Value