8.若要在Excel試算表中判斷受訪者是否為雙北市居民(身分證字號第1碼A=台北市,F=新北市),請問應在D2儲存格輸入哪個公式,才能正確判斷受訪者資格為「合格」或「不合格」?
(A) IF(OR(MID(C2,1,1)="A", MID(C2,1,1)="F"),"合格","不合格") (B) IF(OR(MID(C2,1,1)="A", MID(C2,1,1)="F"),"不合格","合格") (C) IF(AND(LEFT(C2,1)="A", LEFT(C2,1)="F"),"合格","不合格") (D) IF(AND(LEFT(C2,1)="A", LEFT(C2,1)="F"),"不合格","合格")