单项选择题
A.IF(G2=博士,300,IF(G2=研究生,300,IF(G2=本科生,200))) B.IF(G2="博士",300,IF(G2="研究生",300,IF(G2="本科生",200))) C.IFERROR(IF(G2=博士,300,IF(G2=研究生,300,IF(G2=本科生,200))),100) D.IFERROR(IF(G2="博士",300,IF(G2="研究生",300,IF(G2="本科生",200))),100,50)
A.IF(G2<60,"不及格",IF(G2<80,"及格","优良")) B.IF(G2="",IF(G2<60,"不及格",IF(G2<80,"及格","优良"))) C.IF(G2<60,"不及格",IF(G2<80,"及格")) D.IF(G2<60,不及格,IF(G2<80,及格,优良))
A.2 B.3 C.1 D.0