In order to determine how many cells in a range contain a number, which function do you use?
Count
200
Does this include blank cells?
No
200
Does it include blank cells?
No
200
Your spreadsheet has a column designed to track completed projects, and you want to find out how many projects have a completion date. Which of the following will you use to count only those cells containing data?
Counta
300
True or False: Count function includes letter.
False
300
Would the word "Twelve" be included in this count?
Yes
300
Which of the following entries will the COUNT function disregard?
Cells with text & cells without data
400
When are count functions usually used.
When dealing with large spreadsheets.
400
What is a range?
A group of cells
400
The COUNT and SUM functions are examples of which functions?
Statistical
500
What other function classifies data like the count function?
The SUM function
500
How many sets of data could you include in this function?