28. 關於下列 MS- EXCEL,成績介於 100~80 評語為”優”,79~60 評語為”及格”,小於 60 評語為”加油”,則 D2 儲存 格應填入公式?
(A) =IF(C2>=60,"及格",IF(C2>=80,"優","加油")) (B) =IF(C2>=80 && C2<=100,"優",IF(C2>=60,"及格","加油")) (C) =IF(C2>=80 and C2<=100,"優",IF(C2>=60,"及格","加油")) (D) =IF(AND(C2>=80, C2<=100),"優",IF(C2>=60,"及格","加油"))