ABCD

1.

Which of the following is an example of a measure of continuous metrics?

a.	four errors revealed in an invoice	c.	weight and volume of a sheet of steel
b.	a delivery delayed by seven days	d.	three incomplete orders on a day

ABCD

2.

Decision variables:

a.	cannot be directly controlled by the decision maker.
b.	are assumed to be constant.
c.	are always uncertain.
d.	can be selected at the discretion of the decision maker.

ABCD

3.

Identify the uncontrollable variable from the following inputs of a decision model.

a.	investment returns	c.	staffing levels
b.	machine capacities	d.	intercity distances

ABCD

4.

Which of the following inputs of a decision model is an example of data?

a.	estimated consumer demand	c.	costs
b.	inflation rates	d.	investment allocations

ABCD

5.

When will a company use a predictive decision model?

a.	when it wishes to determine the best product pricing to maximize revenue
b.	when it wishes to know how best to use advertising strategies to influence sales
c.	when it wishes to know sales patterns to plan inventory levels
d.	when it wishes to ensure that a specified level of customer service is achieved

ABCD

6.

Which of the following ways would /100 - 73 be represented in an Excel spreadsheet?

a.	10(2) * 5(3) / 100 ^ 73	c.	10^2 * 5^3 / 100 - 73
b.	10(2) ^ 5(3) / 100 - 73	d.	10*2 ^ 5*3 / 100 - 73

ABCD

7.

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

8.

The Excel function of ________ is used to find the largest value in a range of cells.

a.	SUM(range.	c.	MAX(range.
b.	COUNT(range.	d.	COUNTIF(range, criteria.

ABCD

9.

The function ________ returns a value or reference of the cell at the intersection of a particular row and column in a given range.

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

ABCD

10.

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.