Simnet Program Comprehensive Exam 2026.Pdf

SIMNET PROGRAM COMPREHENSIVE EXAM 2026/2027
QUESTIONS AND SOLUTIONS RATED A+
✔✔Insert a Radial Cycle SmartArt diagram. It is the second option in the third row of the
Cycle category. Enter Net Profit as the text for the circle in the middle. Add Returns as
the text for the top circle. Add Expenses as the text for the circle on the right. Add
Salaries as the text for the bottom circle. Add Draws as the text for the circle on the left.
When you are finished, Click outside the diagram. - ✔✔In the Insert Ribbon Tab in the
Illustrations Ribbon Group, you clicked the SmartArt button. Inside the Choose a
SmartArt Graphic dialog from the SmartArt Category list, you clicked the Cycle item.
Inside the Choose a SmartArt Graphic dialog, you clicked the Radial Cycle image,
clicked the OK button. You clicked the [Text] text, typed Net Profit, clicked the [Text]
text, clicked the [Text] text, typed Returns, clicked the [Text] text, clicked the [Text] text,
typed Expenses, clicked the [Text] text, clicked the [Text] text, typed Salaries, clicked
the [Text] text, clicked the [Text] text, typed Draws, and clicked cell J13.

✔✔Ungroup the grouped sheets. - ✔✔You right clicked the Dec 18 tab. In the Tab Right
Click menu, you clicked the Ungroup Sheets menu item.

✔✔Change the gridlines to use the Dash dash style. - ✔✔In the Format Ribbon Tab in
the Shape Styles Ribbon Group, you clicked the Shape Outline button arrow. In the
Shape Outline menu in the Dashes menu, you selected the Dash option.

✔✔Create a new watch in the Watch Window for the selected cells. - ✔✔In the
Formulas Ribbon Tab in the Formula Auditing Ribbon Group, you clicked the Watch
Window button. Inside the Watch Window dialog, you clicked the Add Watch... button.
Inside the Add Watch dialog, you clicked the Add button.

✔✔In cell B9, enter a formula using NPV to calculate the present value of a payment
plan with variable annual payments as shown in cells B11:B14. The interest rate is
stored in cell B2. Use a cell range as a single Value argument. - ✔✔You clicked the
Insert Function launcher button. Inside the Insert Function dialog in the Or select a
category drop-down, you selected All. Inside the Insert Function dialog from the Select a
function list, you selected NPV. Inside the Insert Function dialog, you clicked the OK
button. You clicked cell B2. Inside the Function Arguments dialog, you typed B11:B14 in
the Value1 input, 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 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, typed 4.0 in the Maximum: input,
unchecked the Ignore blank check box, and clicked the OK button.

, ✔✔Use Goal Seek to find the value for cell C2 that will result in a value of $550,000 for
cell B15. Accept the solution. - ✔✔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 Goal Seek... menu item. Inside the Goal Seek dialog, you typed 550000 in
the To value: input, typed C2 in the By changing cell: input, and clicked the OK button.
Inside the Goal Seek Status dialog, you clicked the OK button.

✔✔Add this comment to cell B4: Why are printing costs so high? - ✔✔You right clicked
cell B4. In the Right-Click menu, you clicked the Insert Comment menu item. You
clicked the comment balloon, clicked the comment balloon, changed the comment in
cell B4 to KenDishner: Why are printing costs so high?, pressed the undefined view,
and clicked cell E8.

✔✔Install the Solver add-in. - ✔✔You opened the backstage view, clicked the Options
navigation button, and clicked the Add-Ins tab. Inside the Excel Options dialog, you
clicked the Go... button. Inside the Add-ins dialog, you checked the Solver Add-in check
box, clicked the OK button.

✔✔Data that violate the validation rules in this worksheet have been circled. Remove
the validation circles. - ✔✔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
Clear Validation Circles menu item.

✔✔Create a new file based on the Inventory List template. - ✔✔You opened the
backstage view, clicked the New navigation button, searched for inven in the Template
Search Input, clicked the Inventory list template, and clicked the Create button.

✔✔This workbook includes macros. Save it using the file type that allows macros. -
✔✔You opened the backstage view, clicked the Save As navigation button, clicked the
Save As navigation button, clicked the Save as type drop-down, clicked the Excel
Macro-Enabled Workbook (*.xlsm) item, and clicked the Save button.

✔✔Modify this workbook so users cannot change worksheet names. - ✔✔In the Review
Ribbon Tab in the Changes Ribbon Group, you clicked the Protect Workbook button.
Inside the Protect Structure and Windows dialog, you clicked the OK button.

✔✔Save this workbook as an Excel template. - ✔✔You opened the backstage view,
clicked the Save As navigation button, clicked the Save as type drop-down, clicked the
Excel Template (*.xltx) item, and clicked the Save button.

✔✔Run the Document Inspector and remove any issues found. - ✔✔You opened the
backstage view, clicked the Check for issues button. In the Protect Workbook menu,
you clicked the Inspect Document menu item. Inside the Microsoft Excel dialog, you
clicked the Yes button. Inside the Document Inspector dialog, you clicked the Re-
Inspect button, clicked the Remove All (Document Properties and Personal Information)