試題詳解

59. In Microsoft Excel, cell A1 is the value -8, cell A2 is the value -4, cell A3 is the value -2, cell A4 is the value 0, cell A5 is the value 2, cell A6 is the value 4 and the value in cell A7 is 8. If cell B1 is the formula "=MAX(COUNTIF(A1:A7,"＞-2"), COUNTIF(A1:A7,"＜ 0"))" , then what is the result of B1？
(A) 4
(B) 3
(C) 2
(D) 5