SIMNET PROGRAM FINAL EXAM 2026.pdf 1. Document information

SIMNET PROGRAM FINAL EXAM 2026/2027 QUESTIONS
AND SOLUTIONS RATED A+
✔✔The total row for each expense category uses a SUM function to total the costs.
Create an automatic outline from the rows in this data range. - ✔✔In the Data Ribbon
Tab in the Outline Ribbon Group, you clicked the Group button arrow. In the Group
menu, you clicked the Auto Outline menu item.

✔✔Add a total row to this table and display the average for the Cost column instead of
the sum of all the values. - ✔✔In the Design Ribbon Tab in the Table Style Options
Ribbon Group, you checked the Total Row check box. You clicked cell C21, clicked the
Total Row arrow. In the Total Row menu, you clicked the Average menu item.

✔✔Apply the Drop Shadow, Rectangle Quick Style. - ✔✔In the Format Ribbon Tab in
the Picture Styles Ribbon Group, you clicked the Picture Effects button, clicked the
Picture Effects button, and expanded the Quick Styles Gallery. In the Format Ribbon
Tab in the Picture Styles Ribbon Group in the Quick Styles menu, you clicked the Drop
Shadow Rectangle gallery option.

✔✔Remove the hyperlink from cell B3. - ✔✔You clicked cell B3, right clicked cell B3. In
the Right-Click menu, you clicked the Remove Hyperlinks menu item.

✔✔Insert a recommended PivotTable, using the Sum of Bonus by Employee option. -
✔✔In the Insert Ribbon Tab in the Tables Ribbon Group, you clicked the PivotTable
button. You clicked cell D1. Inside the Create PivotTable dialog, you pressed
Backspace. You clicked cell A1. Inside the Create PivotTable dialog, you clicked the OK
button.

✔✔In cell A10, enter a formula using OR to display TRUE if net profit before tax in 2016
(cell B5) are greater than 750000 (seven hundred, fifty thousand) or net profit before tax
in 2016 (cell C5) are greater than 750000 (seven hundred, fifty thousand). Use cell
references where appropriate and enter the arguments exactly as described in this
question. - ✔✔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 OR. Inside the Insert
Function dialog, you clicked the OK button. Inside the Function Arguments dialog, you
typed B5>750000 in the Logical1 input, typed C5>750000 in the Logical2 input, and
clicked the OK button.

✔✔Add slicers to filter the data in this table by Date. - ✔✔In the Insert Ribbon Tab in the
Filters Ribbon Group, you clicked the Slicer button. Inside the Insert Slicer dialog, you
checked the Date check box, clicked the OK button.

, ✔✔Use Consolidate to enter values in the selected cells by summing data from cells
B3:D8 in the worksheets Bob, Cathy, and Mario. Include links to the source data to
display subtotals. - ✔✔In the Data Ribbon Tab in the Data Tools Ribbon Group, you
clicked the Consolidate button. You clicked the Bob tab, clicked cell B3. Inside the
Consolidate dialog, you clicked the Add button. You clicked the Cathy tab. Inside the
Consolidate dialog, you clicked the Add button. You clicked the Mario tab. Inside the
Consolidate dialog, you clicked the Add button, checked the Create links to source data
check box, and clicked the OK button.

✔✔Apply the Intense Effect SmartArt style to the diagram. It is the last option in the
Best Match for Document section of the gallery. - ✔✔In the Design Ribbon Tab in the
SmartArt Styles Ribbon Group, you expanded the SmartArt Styles Gallery. In the
Design Ribbon Tab in the SmartArt Styles Ribbon Group in the SmartArt Styles menu,
you selected the Intense effect option.

✔✔Refresh the PivotTable data. - ✔✔In the Analyze Ribbon Tab in the PivotTable
Ribbon Group, you clicked the Options button, clicked the Options button. In the
Analyze Ribbon Tab in the Data Ribbon Group, you clicked the Refresh button arrow,
clicked the Refresh button.

✔✔Modify the chart so the Owner Draw data series is plotted along the secondary axis.
- ✔✔In the Design Ribbon Tab in the Type Ribbon Group, you clicked the Change Chart
Type button. Inside the Change Chart Type dialog, you checked the Series 2 -
Secondary Axis check box, clicked the OK button.

✔✔Apply the Offset Diagonal Bottom Right shadow effect to the shape. - ✔✔In the
Format Ribbon Tab in the Shape Styles Ribbon Group, you clicked the Shape Effects
button. In the Shape Effects menu in the Shadow menu, you selected the Offset:
Bottom Right option.

✔✔Apply conditional formatting to the selected cells so cells with a value greater than
400 are formatted using a light red fill. - ✔✔In the Home Ribbon Tab in the Styles
Ribbon Group, you clicked the Conditional Formatting button. In the Conditional
Formatting menu in the Highlight Cells Rules menu, you clicked the Greater Than...
menu item. Inside the Greater Than dialog, you typed 400 in the Format cells that are
GREATER THAN: input. Inside the Greater Than dialog in the with drop-down, you
selected Light Red Fill. Inside the Greater Than dialog, you clicked the OK button.

✔✔In cell D2, use CONCAT to combine the text from cell B2 with the text from cell C2,
with a colon in between. The result of the formula should look like this: Rent:Parking -
✔✔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 CONCAT. Inside the Insert Function dialog,
you clicked the OK button. You clicked cell B2. Inside the Function Arguments dialog,