Match the following terms to their meanings:
I. COUNTA function
II. COUNTIF function
III. SUMIF function
IV. SUMIFS function
V. AVERAGEIF function
A. used to count the number of cells in a range that meet one specified criterion
B. used to calculate the average for cells that meet one specified criterion
C. used to count the number of nonblank cells in a range
D. adds the cells in a range that meet one specified criterion
E. adds the cells in a range that meet multiple criteria
Answer: C, A, D, E, B
Computer Science & Information Technology
You might also like to view...
The headers and footers for a chart sheet can be set at the same time as the worksheet pages
Indicate whether the statement is true or false
Computer Science & Information Technology
The result of =LEFT("Dallas, Texas", 9 ) is ________
A) as, Texas B) las,Texas C) Dallas, T D) Dallas,Te
Computer Science & Information Technology