Simnet Program Evaluation Exam 2026.Pdf

SIMNET PROGRAM EVALUATION EXAM 2026/2027
QUESTIONS AND SOLUTIONS RATED A+
✔✔Using the Scenario Manager, show the Low COLA scenario. Close the Scenario
Manager when you are through. - ✔✔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 Scenario Manager... menu item. Inside the Scenario Manager dialog, you
clicked the Scenarios: list. Inside the Scenario Manager dialog from the Scenarios: list,
you selected Low COLA. Inside the Scenario Manager dialog, you clicked the Show
button, clicked the Show button, and clicked the Close button.

✔✔Create a new scenario to reflect a change in cell B9 to a value of 0.01 Name the
scenario Low COLA. - ✔✔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
Scenario Manager... menu item. Inside the Scenario Manager dialog, you clicked the
Add... button. Inside the Add Scenario dialog, you typed Low COLA in the Scenario
name: input, clicked the OK button. Inside the Scenario Values dialog, you typed 0.01 in
the text box input, clicked the OK button.

✔✔Complete the one-variable data table in cells E3:F8 to calculate the breakeven sales
point for varying owner withdrawal amounts. The formula has been entered for you in
cell E3. It references the original owner withdrawal value in cell B12. The substitute
values have been entered for you in cells E4:E8. - ✔✔In the Data Ribbon Tab in the
Forecast Ribbon Group, you clicked the What-If Analysis button. In the Data Ribbon
Tab in the Data Tools Ribbon Group, you clicked the Data Validation button arrow. 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 typed B12 in the Column input cell input, clicked the OK
button.

✔✔Add the folder named My Spreadsheets as a new trusted location. - ✔✔You opened
the backstage view, clicked the Options navigation button, and clicked the Trust Center
tab. Inside the Excel Options dialog, you clicked the Trust Center Settings... button.
Inside the Trust Center dialog, you clicked the Add New Location... button. Inside the
Microsoft Office Trusted Location dialog, you clicked the Browse... button. You clicked
My Spreadsheets. Inside the Browse dialog, you clicked the Open button. Inside the
Microsoft Office Trusted Location dialog, you clicked the OK button. Inside the Trust
Center dialog, you clicked the OK button. Inside the Excel Options dialog, you clicked
the OK button.

✔✔Modify the workbook so all changes made since you last saved are highlighted on
screen. - ✔✔In the Review Ribbon Tab in the Changes Ribbon Group, you clicked the
Track Changes button. In the Track Changes menu, you clicked the Highlight
Changes... menu item. Inside the Highlight Changes dialog, you checked the Track

, changes while editing. This also shares your workbook. check box, clicked the OK
button. Inside the Microsoft Excel dialog, you clicked the OK button.

✔✔Add a slicer to the PivotTable for the Employee field and use the slicer to show only
data where the value is Sue Chur. - ✔✔In the Analyze Ribbon Tab in the Filters Ribbon
Group, you clicked the Insert Slicer button. Inside the Insert Slicer dialog, you checked
the Employee check box, clicked the OK button. You clicked the Sue Chur button.

✔✔Begin recording a new macro. - ✔✔In the Developer Ribbon Tab in the Code
Ribbon Group, you clicked the Record Macro button.

✔✔Add GPA must be between 2.5 and 4. as an error alert to the validation rules for the
selected cells. Do not include a title. - ✔✔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. You clicked the Error Alert tab.
Inside the Data Validation dialog, you typed GPA must be between 2.5 and 4. in the
Error message: input, clicked the OK button.

✔✔ Hide the column showing 2016 data and the bonus rate. - ✔✔You clicked cell B1,
right clicked the column B header. In the Col Header Right-Click menu, you clicked the
Hide menu item.

✔✔In cell D15, enter a formula using a counting function to count the number of cells in
the Billable? column (cells D2:D14) that are not blank. - ✔✔In the Formulas Ribbon Tab
in the Function Library Ribbon Group, you clicked the More Functions button, clicked
the Math & Trig button, clicked the Lookup & Reference button, clicked the Date & Time
button, clicked the Text button, clicked the Logical button, clicked the Financial button,
clicked the Recently Used button, and clicked the More Functions button. You clicked
cell D15, clicked cell D15, typed =counta in cell D15, clicked the =counta(D2:D14) view,
clicked the =counta(D2:D14) view, clicked cell D15, clicked the D15 Cell Input, clicked
cell D15, clicked the D15 Cell Input, typed =counta(D2:D14) in cell D15, and pressed
Enter.

✔✔Set row 1 to print on every page. - ✔✔In the Page Layout Ribbon Tab in the Page
Setup Ribbon Group, you clicked the Print Titles button. Inside the Page Setup dialog,
you clicked the Rows to repeat at top: item. Inside the Page Setup dialog, you clicked
the Expand Dialog item. Inside the Page Setup dialog, you clicked the Rows to repeat at
top: item. You clicked on the row 1 header. Inside the Page Setup dialog, you clicked
the Expand Dialog item. Inside the Page Setup dialog, you pressed the Enter key.

✔✔Set the print area so only the selected cells will print. - ✔✔You clicked the back
arrow button. In the Page Layout Ribbon Tab in the Page Setup Ribbon Group, you
clicked the Print Area button. In the Print Area menu, you clicked the Set Print Area
menu item.