Identify the letter of the function choice that best matches the description.
A. SUMPRODUCT
B. LOOKUP
C. ROWS
D. INDEX
E. COLUMNS
A. Multiplies corresponding components in the given arrays, and returns the sum of those products
B. Looks in the first row or column of an array for a specified value and return a value from the same position in the last row or column of the array
C. Returns the number of rows in an array
D. Returns a value or the reference to a value from within a table or range
E. Returns the number of columns in an array
You might also like to view...
The base type of an array may be all of the following but:
a. string b. boolean c. long d. all of these may be a base type of an array.
Which of the following are disadvantages of a client/server network? (Select all that apply.)
a. Expensive client/server software and licenses b. Requires a network administrator c. Network bandwidth/resource requirements d. Easy sharing of network resources
Which of the following for-loop headers results in equivalent numbers of iterations:
A. for (int q = 1; q <= 100; q++) B. for (int q = 100; q >= 0; q--) C. for (int q = 99; q > 0; q -= 9) D. for (int q = 990; q > 0; q -= 90) a. A and B. b. C and D. c. A and B have equivalent iterations and C and D have equivalent iterations. d. None of the loops have equivalent iterations.
In a switch statement, the keyword ____ identifies the values that will be compared to the value of the switch expression.
A. if B. break C. case D. default