ADM1370Quiz#2review

# ADM1370Quiz#2review - ADM1370 Module 2 Test Enter the...

• Test Prep
• 4
• 50% (2) 1 out of 2 people found this document helpful

This preview shows pages 1–4. Sign up to view the full content.

This preview has intentionally blurred sections. Sign up to view the full version.

This preview has intentionally blurred sections. Sign up to view the full version.

This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ADM1370 Module 2 Test Enter the letter for the matching Answer 5. Solution: (def and 2 points) 6. Types of Business Intelligence Dashboards 7. Lf OR 8. Solver and requirements 10. CF Nested [F functions 14. Interpretation: (def and two points) A. Analyzing results and implementing solution — Perform sensitivity -Present result & Implement solution B. allows you to search for values in a table that correspond to a lookup value C. A computerized spreadsheet application used to build and manipulate worksheets and workbooks. D. And Or Not E. A visual display of the most important information, arranged on a single screen to achieve business objectives. F. Absolute reference allows the column/row to be fixed \$. Relative reference does not G. Mental (arranging furniture) Visual (blueprints and roadmaps) Physical/Scale (buildings) Mathematical (financial analysis) H. Solving the model to obtain the optimal solution — Analyze Model —Test results 1. enables you to ﬁnd find what it takes to reach a predetermined objective, such as how much you want to sell to make a \$20 million profit this year. reference Relative reference 19. 4 Conditional functions 20. Models J. Summarizes using a singe statistic of row/column — Sum — Average — Total — Max — Min K. Is an [F function that is placed inside another IF function to test an additional condition L. It finds the "best" solution based on constraints/adjustable cells Requires: Target (formula that indirectly/directly affect contraints and adjustable cells) Adjustable cells (until contraints are satisfied) Contraints (restrictions) M. enables you to see how changing one or two variables affect the bottom line. eg. what happens to net profit when tax is 60% from 45% N. Simplified versions of the things they represent, presents accurate and relevant characteristics of the object being studied 0. Returns a TRUE value if any of the logical conditions are true and a FALSE value if all the logical conditions are false. P. Is a named operation that is already predefined which also returns a value Q. Calculates the total salary by location R. Calculates the total employees by location S. Strategic: Excel, static, quick overview Analytical: Sophisticated data Rich comparisons Used to examine the cause Operational: Monitors operations in real time Ensures timely responses T. [F COUNTIF SUMIF AVERAGEIF Type the Question that corresponds to the displayed Answer. 21. Allows you to test more than one condition Returns either true or false I 22. Can be used to duplicate formulas or functions, by dragging down the cell that contains the formula. I I'D 3. A method used to speed up the process of finding a good enough solution. Maximax Maxmin Average I I'D 4. A set of mathematical relationships and logical assumptions implemented in a computer as a representation of a real-world situation I I'D 5. Reverses the value of its argument, to make sure the value is not equal to one particular value. I 26. Calculates the average salary by location I expression that is not predefined I'D as I I'D 8. A broad category of applications and technologies for gathering storing analyzing sharing access to data to help make better decisions. I 29. Offers an easy way to format your cells. eg. applying conditional formatting to a range of cells that contain sales total, specifying if totals drop below 10000, the cell turns red. I— 30. Evaluates whether a condition or a logical test is true or false and returns a value if it is true, and another value if it is false. If true value "a" if false value "b" l— ...
View Full Document

• Fall '12
• Ruhi

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern