Multiple Choice
Which of the following is a differentiation between calculating using the functions COUNT and COUNTIF?
A) COUNT does not require a range of cells; COUNTIF requires a range of cells.
B) COUNT only requires a range of cell and can be obtained without a special criteria, COUNTIF requires range and special criteria to be calculated.
C) COUNT requires a range of cells; COUNTIF does not require a range of cells, only special criteria.
D) COUNT calculates the sum of values for a range of cells; COUNTIF finds the largest value in a range of cells.
Correct Answer:
Verified
Correct Answer:
Verified
Q30: Which of the following functions is a
Q31: Which of the following is a difference
Q32: Give the logical function for the following:
Q33: is a logical function that returns one
Q34: The reflects the opportunity costs of spending
Q35: Using a $ sign before both the
Q36: measures the worth of a stream of
Q37: The easiest way to locate a particular
Q38: Use the following scenario to answer
Q39: To use the VLOOKUP(lookup_value, table_array, col_index_num), the