University of Cincinnati

BANA 2082

Quiz 10A

1)The company identified in Chapter 10, Analytics in Action, is

 

2. The Analytics in Action example in Chapter 10 concerned

 

 

3. Chapter 10 focuses on__________________

 

4. A(n)                                  is a visual representation that shows which entities affect others in a model.

 

5. In                                       decision making companies have to decide whether they should manufacture a product or outsource its production to another firm.

 

Quiz 10B

1. The SUM function in Excel

 

2. The                        function pairs each element of the first array with its counterpart in the second array, multiplies the elements of the pairs together, and adds the results

 

3. With reference to the SUMPRODUCT function, which of the following statements is true?

 

 

4. Within a given range of cells, the number of times a particular condition is satisfied is computed by using the                                       function

 

5. The condition that VLOOKUP assumes is that

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Quiz 10C

1. Using the diagram below, which of the following would be a likely mathematical expression for Total Cost?

 

 

 

2. With reference to a spreadsheet model, an uncontrollable model input is known as a(n)

 

3. A(n)                                refers to a model input that can be controlled in a spreadsheet model.

 

4. An Excel                                             quantifies the impact of changing the value of a specific input on an output of interest.

 

5. The VLOOKUP with range set to                          takes the first argument and searches the first column of the table for the last row that is strictly less than the first argument.

 

6. Excel searches for an exact match of the first argument in the first column of the data when the range in the VLOOKUP function is

 

7. The                                button, located in the Formula Auditing group, creates arrows pointing to the selected cell from cells that are part of the formula in that cell

 

 

8. Arrows pointing from the selected cell to cells that depend on the selected cell are generated by using the                                        button of the Formula Auditing group

 

9. The following table is used to lookup information on a specific product. The Product ID is entered into cell B2 and the information is returned in the shaded box.There are several formulas

 

in the table. How could I look at the cells that use the value in cell B2?

 

 

10. The calculations of a cell can be investigated in great detail by using the                           button.
11. The Gatson manufacturing company has estimated the following components for a new product.

 

Fixed cost = $50,000 Material cost per unit = $2.15 Labor cost per unit = $2.00 Revenue per unit = $7.50

 

*Construct an Excel model and using the appropriate Excel tool, find the exact breakeven point.

Round your answer to a whole number.*

 

 

 

 

12. Professor Rao would like to accurately calculate the grades for the 58 students in his Operations Planning and Scheduling class (OM 455). He has thus far constructed a spreadsheet. The Course Average is calculated by weighting the Midterm Score and Final Score 50% each. Use the VLOOKUP function with the table shown to generate the Course Grade for each student. Use the COUNTIF function to determine the number of students receiving each letter grade. How many students received a C?