× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
s
3
v
3
p
3
m
2
s
2
d
2
N
2
d
2
e
2
s
2
s
2
e
2
New Topic  
JohnAmera JohnAmera
wrote...
Posts: 432
Rep: 0 0
6 years ago
Match each of the following functions to its best description of its purpose:

I.   COUNTIF
II.   COUNTIFS
III.   SUMIFS
IV.    SUMIF
V.   AVERAGEIF

A.   Calculates the average, or arithmetic mean, of all cells in a range that meet a specific condition
B.   Calculates the number of cells in a range when a specified condition is met
C.   Calculates the total of a range of values when a specified condition is met
D.   Calculates the total value of cells in a range that meet multiple criteria
E.   Returns the number of cells in a range that meet multiple criteria
Textbook 
Exploring Microsoft Office Excel 2016 Comprehensive

Exploring Microsoft Office Excel 2016 Comprehensive


Edition: 1st
Authors:
Read 54 times
1 Reply
Exploring Microsoft Office Excel

Related Topics

Replies
wrote...
6 years ago
B, E, D, C, A
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  1534 People Browsing
Related Images
  
 269
  
 303
  
 173
Your Opinion
Which 'study break' activity do you find most distracting?
Votes: 824