The COUNTA function in MS Excel counts the number of cells in a specified range that are not empty. Therefore, =COUNTA(A1:A5) counts every cell in the range A1 through A5 that contains any value, including text, numbers, dates, logical values, errors, or formulas that return a value. Unlike COUNT, which counts only numeric values, COUNTA counts both text and numeric entries as long as the cells are not empty.
In MS Excel, what will the formula =COUNTA(A1:A5) count?
Review the verified answer and explanation for this ETEA Educational Testing and Evaluation Agency past-paper question on CampusFin.