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
You might also like to view...
A control’s ____________ property identifies the control in the application’s code and in the Visual Studio environment.
a. Text b. Source c. Tag d. Name
Which OSI layer is responsible for the mechanical connection to the network?
What will be an ideal response?
Like the image control, the logo control allows you to insert a picture anywhere in the form
Indicate whether the statement is true or false
A(n) ________ theme is a coordinating set of fonts, colors, and effects
Fill in the blank(s) with correct word