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 7
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 "0'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.
 QUESTION 7 What is the difference between the Excel functions Count

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!