You want to create a pivottable that uses fields from

This preview shows page 38 - 41 out of 77 pages.

10. You want to create a PivotTable that uses fields from two Excel tables. What is the first step?a. Create a relationship on a common field between the two tables.b. Create a PivotTable using one table and then add the second table to the PivotTable Fieldstask pane.c. Merge the two tables into on large dataset before creating the PivotTable.d. Create a subtotal for each table, copy and paste the two subtotals together, and then createthe PivotTable.
Ch.6 What-if Analysis1. ______ A constraint that Solver must enforce to reach the target value.2. ______ A cell containing a variable whose value changes until Solver optimizes the value inthe objective cell.3. ______ An add-in application that manipulates variables based on constraints to find theoptimal solution to a problem.4. ______ A data analysis tool that provides various results based on changing a single variable.5. ______ A set of values that represent a possible situation.6. ______ The cell that contains the formula-based value that you want to maximize, minimize,or set to a value in Solver.7. ______ This data analysis technique finds the highest, lowest, or exact value for oneparticular result by adjusting values for selected variables.8. ______ A limitation that does not restrict the target value that Solver finds.9. ______ The process of changing variables to observe how changes affect calculated results.10. ______ An input value that you can change to see how that change affects other values.11. ______ A value that replaces the original value of a variable in a data table.12. ______ A limitation that imposes restrictions on Solver.13. ______ A program that can be added Excel to provide enhanced functionality.14. ______ A worksheet that contains scenario results.15. ______ A data analysis tool that provides results based on changing two variables.16. ______ A tool that identifies the necessary input value to obtain a desired goal.17. ______ A What-if analysis tool that enables you to define and manage scenarios to comparehow they affect results.18. ______ A word or string of characters that represents one or more cells.1. B Binding Constraint11. O Substitution Value2. C Changing Variable Cell12. D Constraint3. N Solver13. A Add-in4. H One-Variable Data Table14. M Scenario Summary Report5. K Scenario15. Two-Variable Data Table6. G Objective Cell16. E Goal Seek7. I Optimization Model17. L Scenario Manager8. F Nonbinding Constraint18. J Range Name9. R What-if Analysis10. Q Variable
Multiple Choice1. Which what-if analysis tool is the best option for complex calculations requiring constrainedoptimization?

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 77 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Summer
Professor
NoProfessor
Tags

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture