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 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
Q2: Identify the equation for calculating the
Q2: For which of the following columns can
Q9: If, in the spreadsheet, cells B9 and
Q14: Use the data given below to
Q15: Describe the method of calculating the net
Q21: In a MATCH function, the default value
Q22: A positive NPV means that the investment
Q23: Which of the following Lookup functions returns
Q36: measures the worth of a stream of
Q36: Use a modern software tool to