Deck 9: Formula Auditing, data Validation, and Complex Problem Solving

Question 1

To add cells to the Watch Window,select all cells on a worksheet with formulas,then click Home tab > Editing group > Find & Replace > Go To Special > Formulas tab > Formula Auditing group > Watch Window > Add Watch > Add.

Answer 1

True

Question 2

Mila wants to restrict a cell to accept only whole numbers between 1 and 100.What should she select as X in the following clicks/entries/selections: Select cell.Data > Data Validation > Settings tab > Validation Criteria > Allow > X > Data > (select)between > Minimum > (select)1 > Maximum > (select)10 > OK > Enter number between 1 and 100 in cell?

A) Decimal
B) List
C) Text length
D) Whole number

Answer 2

D

Question 3

To display a tracer arrow to each cell providing direct data that is dependent on the active cell,click Formulas tab > Formula Auditing group > Trace Dependents.

Answer 3

True

Question 4

Which of the following can X be in the series of clicks to create a scenario PivotTable report: Data tab > Data Tools > X > Y > Summary button > Scenario Summary dialog box > Report type > Scenario PivotTable report > Enter cell name in Results cells box > OK?

A) X-Consolidate,Y-Consolidate
B) X-What-If Analysis,Y-Goal Seek
C) X-What-If Analysis,Y-Scenario Manager
D) X-Data Validation,Y-Data Validation

Question 5

Which of the following will you click on the Reports list box in Solver Results dialog box to produce an Answer Report?

A) Limits
B) Answer
C) Sensitivity
D) Outline Reports

Question 6

One can manage available Office add-ins by clicking Gear icon > Settings > Mail > Options pane > General > Manage add-ins > Add/ Uninstall/ find more add-ins.

Question 7

Lola wants to install an add-in in Excel.She has to unblock the add-in to allow Excel to open the add-in file automatically.To do this,she right clicks on the add-in file and selects an option from the menu.What could the option be?

A) Copy
B) Delete
C) Rename
D) Properties

Question 8

To display a tracer arrow to each cell providing direct data to the active cell,click Formulas tab > Formula Auditing group > Trace Precedents.

Question 9

While deleting a constraint,which of the following relationships will you click for integer to appear in the Constraint box?

A) bin
B) int
C) >=
D) <=

Question 10

The Error Alert Style,Stop in the dropdown list that opens under Error Alert tab highlights the invalid entry that can be overtyped.

Question 11

If you remove an add-in,the changes are not saved until you exit MS Excel.

Question 12

Martha and Mike are working on a project where Martha is creating a template in MS Excel that Mike will work upon.She wants to insert the message "Select True or False from the drop-down list" in a cell under a column titled "Answer." What should she select as X in the following clicks/entries/selections: (Select)cell > Data > Data Validation > Input Message > (Check box)Show input message when cell is selected > X > (Insert in box)Select True or False form the drop-down list?

A) Title
B) Heading
C) Input message
D) Insert message

Question 13

Xavier wants to use a solver to find optimal solutions for a decision problem.What should he select as X in the series of clicks for this purpose: Data tab > X > Solver > Enter Solver parameters (read on)> Check "Make Unconstrained Variables Non-Negative" > Select "Simplex LP" > Solve?

A) Outline
B) Analyze
C) Forecast
D) Connections

Question 14

To open the add-ins dialog box while activating an Excel add-in,we need to click on the Manage box > Excel Add-ins > Go.

Question 15

Which of the following will you select as X in the series of clicks to circle invalid data in a worksheet: Data tab > Data Tools group > Arrow next to X > Circle Invalid Data?

A) What-If Analysis
B) Data Validation
C) Remove Duplicates
D) Consolidate worksheet data.

Question 16

Which of the following will you select as X in the series of clicks to clear data validation circles in a worksheet: Data tab > Data Tools group > Arrow next to X > Clear Validation Circles?

A) What-If Analysis
B) Data Validation
C) Remove Duplicates
D) Consolidate worksheet data.

Question 17

To remove trace arrows in a cell,select the cell,then click Formulas > Arrow beside Remove Arrows > The type of arrow you want to remove from the list.

Question 18

One can manage available Office add-ins by clicking Gear icon > Settings > Mail > Options pane > General > Manage add-ins > Add/ Uninstall/ find more add-ins.

Question 19

To evaluate a formula,click the following series: Cell you want to evaluate > Formulas tab > Formula Auditing group > Evaluate Formula > Evaluate (Continue until all the parts of the formula have been evaluated)> Close.

Question 20

Which of the following should you select as X after selecting the cell to which the validation rule applies,pressing Ctrl + C,then selecting the cell you want to validate,right clicking it,clicking Paste Special,and then selecting X from the context menu and then clicking OK?

A) All
B) Formats
C) Formulas
D) Validation

Question 21

To create a scenario,one should click on the series: Data tab > Data tools > What-If Analysis > Scenario Manager > Add button > Enter details in the boxes in Edit Scenario dialog box> OK > Close button.

Question 22

While merging scenarios,one should keep both workbooks from which one wants to merge scenarios open,and work from the workbook to which one will add the scenarios.

Question 23

In which of the following dialog boxes will you click Load/Save to save a problem model?

A) Options
B) Solver Results
C) Solver Parameters
D) Show Trial Solution

Question 24

To create a forecast sheet,enter two data series corresponding to each other in a worksheet,select both the data series,then click on the following: Data tab > Forecast group > Forecast Sheet > Create Forecast Worksheet box > Select Line Chart or Column Chart > Pick an end date in Forecast End box > Create.

Question 25

To edit a scenario,click on the series: Tools menu > Scenarios > Scenario Manager > Highlight the name of the scenario whose values you want to change > Edit button > Edit Scenario dialog box > Edit as desired > OK button > Scenario Values dialog box > Change values stored in the scenario as desired > OK.

Question 26

In which of the following dialog boxes,under Subject to the Constraints,will you click the constraint that you want to change and then click Change?

A) Options
B) Solver Results
C) Solver Parameters
D) Show Trial Solution

Question 27

In which of the following dialog boxes will you click "Add" under "Subject to the Constraints" to add constraints to a model?

A) Options
B) Solver Results
C) Solver Parameters
D) Show Trial Solution

Question 28

Johnson wants to load Solver in Microsoft Excel.For this,he clicks the series: File > Options > Add-Ins > Manage Box > X > Go > Add-ins available box > Solver Add-in check box > OK.What can X be in the procedure?

A) COM Add-ins
B) Excel Add-ins
C) Disabled Items
D) XML Expansion Packs

Question 29

To delete a scenario,first close the Document Inspector,then click on the following series: Data > What-If Analysis > Scenario Manager > Select the scenario you want to remove in Scenarios box > Delete.

Question 30

To create a scenario summary report,click on the series: Data tab > Data tools > What-If Analysis > Scenario Manager > Summary button > Scenario Summary dialog box > Select Scenario PivotTable report for Report type > OK.