Lab 6

What is the benefit of using custom number formats with one-variable data tables? a) Custom number formats can be used to mask the function or formulas in the table b) Custom number formats can be used in place of absolute references c) Custom number formats can be used in place of relative references d)Custom number formats can be used as range names

a) Custom number formats can be used to mask the function or formulas in the table

Which of the following is not true about two-variable data tables? a) Two-variable data tables can only be used with financial functions b) Two-variable data tables can compare results based on two changing variables c) Two-variable data tables require one formula or function to calculate the results d) All the above are true

a) Two-variable data tables can only be used with financial functions

Which comparison operator would you use when adding a constraint to ensure that a variable mortgage interest rate remain at or under 6%? a) <> b) <= c) = d) >=

b) <=

Goal seek is best suited for which of the following situations? a) Measuring the sensitivity of a car payment based on various interest rates b) Determining the down payment needed to obtain a $600 a month mortgage c) Analyzing outcomes based on multiple scenarios d)Determining the optimal down payment to minimize your mortgage payments while paying the loan off within 15 years

b) Determining the down payment needed to obtain a $600 a month mortgage

Which of the following is not a capability of solver? a) Maximizing output b) Generating data tables c) Minimizing output d)Working within economic constraints

b) Generating data tables

Which of the following is not true about scenario summary reports? a) Scenario summary reports can be edited b) Scenario summary reports are created by default as portable document format (PDF) c) Scenario summary reports can be printed d) Values in scenario summary reports can be used as references in formulas or functions

b) Scenario summary reports are created by default as portable document format (PDF)

What is the purpose of creating substitution values for one-variable data tables? a) Substitution values are used as range names for the data table b) Substitution values are used as references for the formulas used in the table c) Substitution values are used as relative references d)Substitution values aggregate the table

b) Substitution values are used as references for the formulas used in the table

Which of the following is not a benefit of using range names? a)Range names eliminate the need to use absolute referencing b)Range names automatically appear when a worksheet is printed c)Range names simplify complex formula and functions d)Range names can easily be edited

b)Range names automatically appear when a worksheet is printed

Which of the following is a benefit of creating a solver answer report? a) The answer report will automatically create a pivot table b) The answer report is created as a PDF c) Answer reports detail the optimal results and the changes made within the change cells to find the optimal outcome d) Answer reports contain sensitivity tables that display all possible scenarios

c) Answer reports detail the optimal results and the changes made within the change cells to find the optimal outcome

What is the difference between a one-variable and two-variable data table? a) Two-variable data tables require range names, one-variable data tables do not b)One-variable data tables can only contain one reference formula, two variable data tables contain two reference formulas c) One-variable data tables return results based on one changing variable, two-variable tables return results based on two changing variable d) Custom number formats should be used only with one-variable data tables

c) One-variable data tables return results based on one changing variable, two-variable tables return results based on two changing variable

Which of the following actions cannot be completed using the Name Manager? a) Deleting a range name b) Adding a range name c) Paste a list of range names in a worksheet d)Edit a range name

c) Paste a list of range names in a worksheet

Which of the following is not a benefit of using scenario manager? a) Scenario manager can generate reports b) Scenario manager can generate pivot tables c) Scenario manager can be used to maximize a particular outcome based on constrained inputs d)Scenario manager can be used to quickly switch between multiple possible outcomes

c) Scenario manager can be used to maximize a particular outcome based on constrained inputs

Which is true about the input cells in a one-variable data table? a) One variable data tables can only use row input cells b) One variable data tables can only use column input cells c) The row or column input cell must relate to a variable in the formula that is being evaluated in the data table d)The row or column input cell must be formatted as a range name

c) The row or column input cell must relate to a variable in the formula that is being evaluated in the data table

Which of the following is not true about the difference between the objective cell and changing cells? a) The objective cell can be maximized and the changing cells cannot b) There can only be one objective cell but many changing cells c) There can be multiple objective cells and multiple changing cells d) The objective cell can be minimized and the changing cells cannot

c) There can be multiple objective cells and multiple changing cells

In which of the following situations would you choose to paste a list of range names? a) When using a range name in a formula b) When printing a worksheet c) When editing a list or range names d)When creating documentation for future users of a worksheet

d)When creating documentation for future users of a worksheet