BUS 375 Exam 4 Hands on
You right clicked cell B4. In the Right-Click menu, you clicked the Insert... menu item. Inside the Insert Cells dialog,
you clicked the Close button. You right clicked cell B4. In the Right-Click menu, you clicked the Insert Comment
menu item. You clicked the comment balloon, changed the comment in cell B4 to KenDishner: WHy are printing
costs so high?. - ✔✔Add this comment to cell B4: Why are printing costs so high?
In the Review Ribbon Tab in the Changes Ribbon Group, you clicked the Protect Workbook button. - ✔✔Remove
workbook protection so users can add new worksheets.
In the Data Ribbon Tab in the Data Tools Ribbon Group, you clicked the Data Validation button arrow. In the Data
Validation menu, you clicked the Data Validation... menu item. Inside the Data Validation dialog in the Allow
drop-down, you selected Decimal. Inside the Data Validation dialog, you typed 2.5 in the Minimum: input, clicked
the DialogHeader view, clicked the dialog undefined button, clicked the DialogHeader view, clicked the dialog
undefined button, typed 4.0 in the Maximum: input, unchecked the Ignore blank check box, and clicked the OK
button. - ✔✔Apply data validation rules to the selected cells to allow only decimal numbers between 2.5 and 4.0.
Do not allow blanks.
In the Data Ribbon Tab in the Forecast Ribbon Group, you clicked the What-If Analysis button. In the What-If
Analysis menu, you clicked the Data Table... menu item. Inside the Data Table dialog, you clicked the
DialogHeader view, clicked the dialog undefined button, and typed in the Row input cell input. You selected the cell
range A7:E12, selected the cell range A7:E12. Inside the Data Table dialog, you clicked the OK button. -
✔✔Complete the two-variable data table in cells A7:E12. The formula has been entered for you in cell A7. The
substitute values in cells B7:E7 reference the original cost of goods percentage in cell B3, and the substitute
values in cells A8:A12 reference the original owner withdrawal percentage in cell B4.
In the Data Ribbon Tab in the Analyze Ribbon Group, you clicked the Solver button. Inside the Solver Parameters
dialog, you clicked the DialogHeader view, clicked the dialog undefined button. You clicked cell B7. Inside the
Solver Parameters dialog, you typed Optimal in the By Changing Variable Cells input, clicked the Add button.
Inside the Add Constraint dialog, you typed Optimal in the Cell Reference input, typed max in the Constraint input,
and clicked the OK button. Inside the Solver Parameters dialog, you clicked the Add button. Inside the Add
Constraint dialog, you typed optimal in the Cell Reference input. Inside the Add Constraint dialog in the Operator
drop-down, you selected int. Inside the Add Constraint dialog, you clicked the OK button. Inside the Solver
Parameters dialog, you clicked the Add button. Inside the Add Constraint dialog, you typed procedures in the Cell
Reference input, typed MaxAllowed in - ✔✔Use Solver to find the combination of procedures that will result in the
maximum possible profit per week in cell B7. Use the range name Optimal as the variable cells. Add these
constraints in order: values in the named range Optimal are less than or equal to the values in the named range
Max; values in the named range Optimal are whole numbers; values in the named range Procedures are less than
or equal to values in the named range MaxAllowed. Run Solver and accept the solution.
In the Developer Ribbon Tab in the Code Ribbon Group, you clicked the Macros button. Inside the Macro dialog
from the Macro name: list, you selected FormatPieChart. Inside the Macro dialog, you clicked the Edit button. You
edited the macro code, clicked the Save button. - ✔✔Edit the code for the FormatPieChart macro to change the
chart style from 42 to 252. Save your changes.
In the Developer Ribbon Tab in the Code Ribbon Group, you clicked the Macros button. Inside the Macro dialog,
you clicked the Run button. - ✔✔Run the FormatPieChart macro.
