1.A Microsoft Excel sheet contains Roll , Name, and Marks in five subjects in column A,B,C,D,E,F and G columns respectively as shown in figure , solve : Solution :– I. Using “IF” and “AND” operators, write the syntax to display “PASS” or “FAIL” In H Column (Assumed pass marks in 45 in each subject). ii. […]