The function used to calculate the average of cells specified by a given set of conditions is ________

A) AVERAGEIFS
B) AVERAGE
C) CRITERIA
D) AVERAGEIF

Answer: A

Computer Science & Information Technology

You might also like to view...

In the Insert For Each In Array Loop dialog box, we can specify the ____ of values we have in our array, (2) specify a(n) ____ for one of the items in the array, and (3) specify the ____ through which we want to iterate.

A. array; generic variable name; type B. list; index; generic array name C. type; generic variable name; array D. index; generic array name; list

Computer Science & Information Technology

Find the error in the code segments, and explain how to correct it:

``` for (k = 0.1; k != 1.0; k += 0.1) { 2 System.out.println(k); 3 } ```

Computer Science & Information Technology