File - New - Spreadsheet
Tools - Solver
Change the Target cell to C3 by
clicking on Cell C3
Change the Target cell by
clicking on the range chooser icon to the right of the target
cell input line, the dialog minimizes, click on D5 and again on
the range chooser icon at the right edge of the input line.
If the target cell does not switch from A1 to C3 in the
first step or from C3 to D5 in the second one, file an Issue
In the Optimize result to
section of the Solver dialog click on the Radiobutton in front of
Minimum, it should be shown as selected when. If not file an
Issue.
Use ALT+V to select Value of
and click into the input line next to the Radio button. Type 1.
If it does not show up, file an Issue.
Click on the range chooser icon
next to the input line for the Value the Solver dialog minimizes.
Click on $A$4 and hit the return key. The dialog maximizes and
shows A4 as Value of. If not, file an Issue.
ALT+M, the Radiobutton in front of Maximum should be
enabled, if not file an Issue.
Click on the Input line next to
the text 'By changing cells'. Type A10:C10. If it does not work,
file an Issue.
Click on the Range Chooser Icon, the dialog minimizes,
select C3:D4 and click on the range chooser again. If the input
line does not contain $C$3:$D$4, file an Issue.
Click on the first line under
the heading 'Cell reference' in the Limiting conditions section
of the Solver dialog. Type F1. Click on the drop down list box
under Operator and choose '='. Type 1 into the first input line
under Value.
If one of these steps doesn't work, file an
Issue.
Click on the second line under
the heading 'Cell reference' in the Limiting conditions section
of the Solver dialog. Click on the range chooser next to it and
after the dialog minimized click on B1 and again on the range
chooser Icon. The input line should show $B$1, if not, file an
Issue.
Click on the second Operator drop down list box and choose
'>='. Click on the second input line, press F2 and select cell
C1. The dialog maximizes and the line shows $C$1. If not, file an
Issue.
Press ALT+T, the Target Cell
input line must be active, if not file an Issue.
Press ALT+U, Minimum in the
'Optimize result to' section must be active, if not file an
Issue.
Press ALT+V, the Radio Button
next to 'Value of' must be active, if not file an Issue.
Press ALT+M, the Radio Button
for Maximum must be active, if not, file an Issue.
Press ALT+B, the Input Line for
'By changing cells' must be active, if not, file an Issue.
Press ALT+C, the first line for
Cell reference must be active, if not, file an Issue.
Press ALT+O, the first Operator
drop down list box must be active, if not, file an Issue.
Press ALT+A, the first input
line for Value must be active, if not, file an Issue.
Press ALT+H, the Help page must be opened, if not, file an
Issue.
Press ALT+P, the Options dialog
must be opened, if not, file an Issue.
Click on Cancel, the
Options dialog must be closed, if not, file an Issue.
Click on Options. The drop down
list box next to 'Solver Engine' must be active, if not, file an
Issue.
Click on the check boxes for
Assume variables as integer, Assume variables as non-negative and
Limit branch-and-bound depth. The states of these check boxes
must be changed to tagged, tagged, un-tagged. If one of these
conditions is not matched, file an Issue.
Reset the check
boxes to the initial values of un-tagged, untagged, tagged.
Click on the line 'Epsilon
level (0-3): 0' and press ALT+E. A new dialog opens. Press
the cursor up key two times, the Spin field should show 2 now.
Click on Ok, the dialog closes and the line reads 2 as Value for
the Epsilon level, if not file an Issue.
Click on the line 'Epsilon
level (0-3): 2' and press ALT+E. A new dialog opens. Press
the cursor up key five times, the Spin field should show 7 now.
Click on Ok. The Epsilon level should show a value of 7, if not
file an Issue.
Click on Solve at the Solver
dialog. You get a dialog saying No Solution. The Epsilon level is
invalid.
Click on Ok
Press ALT+P to open the Options
dialog.
Double Click on the Epsilon
Level line
Click on the spin down button
of the spin field to reset the value to 1. Click on the Ok
Button. The dialog closes and the line shows up as 'Epsilon level
(0-3): 1' If not, file an Issue.
Double click the line showing
'Solving time limit (seconds):100'. A new dialog opens and
the Spin field for Seconds is active. If not, file an Issue.
Change the value to 50 by using
the Spin field buttons and click on Ok. The dialog closes and the
line should read 'Solving time limit (seconds):50'. If
not, file an Issue.
Click on the Help Button, the
Help system must open, if not file an Issue.
Close the Help system
Press the ESC key, the Options dialog must close now. If
not file an Issue.
Next to the second Value input
line is a delete line Icon located. Click on this one. The
limiting cell reference, Operator and Value from this line are
removed, if not, file an Issue.
Click on the Close Button of the Solver dialog, it closes
now. If not, file an Issue.