Question: QUESTION 7 What is the difference between the Excel functions Count and Counta a . Count includes only numerical values in its count, Counta includes
QUESTION
What is the difference between the Excel functions Count and Counta
a Count includes only numerical values in its count, Counta includes any cell occupied, numeric or text.
b Count includes only occupied cells in its calculation, Counta considers blanks to be s and includes the cells in its calculation.
c Counta considers only numeric values, Count considers both numeric values and text.
d Count is used to determine the number of entries in a file, Counta is used to count entries in an active file.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
