"Dựa vào hình trên, công thức = COUNTA(A4:B7)-COUNT(A4:B7) trả kết quả là? Hình 7"
Trả lời:
Đáp án đúng: A
The formula `=COUNTA(A4:B7)-COUNT(A4:B7)` calculates the difference between the number of non-empty cells and the number of cells containing numbers in the range A4:B7.
`COUNTA(A4:B7)` counts the non-empty cells in the range A4:B7. Assuming the range contains numbers and potentially empty cells, this will count all cells containing any value (text, numbers, etc.).
`COUNT(A4:B7)` counts only the cells containing numbers within the range A4:B7.
If all non-empty cells in A4:B7 contain numbers, then `COUNTA(A4:B7)` will be equal to `COUNT(A4:B7)`, and the result of the formula will be 0. If any of the non-empty cells contains text or another non-numerical value, then `COUNTA(A4:B7)` will be greater than `COUNT(A4:B7)`, and the result will be a positive number.
Without knowing the exact contents of the range A4:B7, the exact answer cannot be determined. Assuming the range A4:B7 only contains numbers, then the result is 0. If it contains blank cells and numbers, then the counta will equal the number of number cells, therefore the answer is zero. If it contains text, the answer will be positive.