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.

ABCD

10.

________ measures the worth of a stream of cash flows, taking into account the time value of money.

a.	Accounting rate of return	c.	Internal rate of return
b.	Net present value	d.	Adjusted present value

ABCD

11.

The easiest way to locate a particular function is to select a cell and click on the Insert function button represented by ________ on the Excel ribbon.

a.	fx	c.	$
b.		d.	%

ABCD

12.

Which of the following Lookup functions returns the relative position of an item in an array that equals a specified value in a specified order?

a.	HLOOKUP(lookup_value, table_array, row_index_num.
b.	MATCH(lookup_value, lookup_array, match_type.
c.	INDEX(array, row_num, col_num.
d.	VLOOKUP(lookup_value, table_array, col_index_num.

ABCD

13.

In a MATCH function, if the match_type = 0, then ________.

a.	the function finds the largest value that is less than or equal to lookup_value
b.	the function finds the smallest value that is greater than or equal to lookup_value
c.	MATCH finds the first value that is exactly equal to lookup_value
d.	the values in the lookup_array must be in a particular order

ABCD

14.

For which of the following MATCH functions must the values in the lookup_array be ordered in a descending order?

a.	When match_type = -1	c.	When match_type = 0
b.	When match_type >1	d.	When match_type = 1