Download SimNet Program Exam 2026/2027 STUDY SET WITH VERIFIED SOLUTIONS and more Exams Computer Applications in PDF only on Docsity!
SimNet Program Exam 2026/2027 STUDY SET
WITH VERIFIED SOLUTIONS
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. Change the color of the sheet tab for the Dec 18 worksheet to Green, Accent 6, Lighter 80% (the last option in the second row of theme colors).
You right clicked the Dec 18 tab. In the Tab Right Click menu in the Tab Color menu, you selected the Green, Accent 6, Lighter 80% color option. Center the content in the selected cells horizontally. In the Home Ribbon Tab in the Alignment Ribbon Group, you clicked the Align Center button. Show the tracer arrows from the precedent cells to cell C7. You clicked and dragged the cell C7 fill handle, clicked the Smart Tag Button, and clicked cell E12. In the Formulas Ribbon Tab in the Formula Auditing Ribbon Group, you clicked the Trace Precedents button. Merge the cells so the text appears centered across the merged cells. In the Home Ribbon Tab in the Alignment Ribbon Group, you clicked the Merge & Center button. Apply the Accounting Number Format to the selected cells. In the Home Ribbon Tab in the Number Ribbon Group, you clicked the Number Format drop-down arrow. In the Number Format menu, you selected the Accounting option. Change the width of the selected columns to 14. In the Home Ribbon Tab in the Cells Ribbon Group, you clicked the Format button. In the Format menu, you clicked the Column Width... menu item. Inside the Column Width dialog, you typed 14 in the Column Width: input, clicked the OK button. Modify this worksheet so you can see four different areas of the worksheet at the same time and scroll each area independently of the others. In the View Ribbon Tab in the Window Ribbon Group, you clicked the Split button. Insert the current date in cell A1. Do not include the current time. In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Date & Time button. In the Date & Time menu, you clicked the TODAY menu item. Inside the Function Arguments dialog, you clicked the OK button. Insert a column to the left of the selected cell. You right clicked the column D header. In the Col Header Right-Click menu, you clicked the Insert menu item. Without adjusting the column widths, guarantee that all columns will print on one page.
Clear the print area. 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 Clear Print Area menu item. Delete this row. You clicked on the row 5 header, right-clicked the row 5 header. In the Row Header Right-Click menu, you clicked the Delete menu item. In cell D16, enter a formula using a counting function to count the number of blank cells in the Billable? Column (cells D2:D14). In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the More Functions button, clicked the Math & Trig button, clicked the Logical button, clicked the Financial button, clicked the Lookup & Reference button, and clicked the More Functions button. In the More Functions menu in the Statistical menu, you clicked the COUNTBLANK menu item. Inside the Function Arguments dialog, you typed D2:D14 in the Range input, clicked the OK button. Enter a formula in cell B3 using the VLOOKUP function to find the meaning for the medical abbreviation listed in cell A3. Use the name Abbreviation for the lookup table. The item names are located in column 2 of the lookup table. Be sure to require an exact match. In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the More Functions button, clicked the Lookup & Reference button. In the Lookup & Reference menu, you clicked the VLOOKUP menu item. Inside the Function Arguments dialog, you clicked the DialogHeader view, clicked the dialog undefined button, and clicked the Lookup_value item. Inside the Function Arguments dialog, you clicked the Expand Dialog item. Inside the Function Arguments dialog, you typed A3 in the Lookup_value input, typed Abbreviation in the Table_array input, typed 2 in the Col_index_num input, typed False in the Range_lookup input, and clicked the OK button. Change the font for the selected cell to Cambria. In the Home Ribbon Tab in the Font Ribbon Group, you clicked the Font drop-down arrow. In the Font menu, you clicked the Cambria font. Insert the current date and time in cell A1.
In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Date & Time button. In the Date & Time menu, you clicked the NOW menu item. Inside the Function Arguments dialog, you clicked the OK button. Add a footer that displays the page number in the center section. In the Design Ribbon Tab in the Header & Footer Elements Ribbon Group, you clicked the Page Number button. Wrap the text in the selected cell. In the Home Ribbon Tab in the Alignment Ribbon Group, you clicked the Wrap Text button. Add an element to the center section of the header to display the current date (not Dec 18, which is the worksheet name). In the Mini Toolbar, you clicked the Header & Footer button. In the Design Ribbon Tab in the Header & Footer Elements Ribbon Group, you clicked the Current Date button. Modify the number format so no decimal places are visible after the decimal point. In the Home Ribbon Tab in the Number Ribbon Group, you clicked the Accounting Number Format button arrow. In the Accounting Number Format menu, you clicked the More Accounting Formats... menu item. Inside the Format Cells dialog, you changed the Decimal places input to 3, changed the Decimal places input to 2, changed the Decimal places input to 1, changed the Decimal places input to 0, and clicked the OK button. Enter a formula in cell B10 to return a value of 35000 if the Net Profit After Tax (cell B9) is greater than or equal to 470000 or 1000 if it is not. In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Math & Trig button, clicked the Logical button. In the Logical menu, you clicked the IF menu item. Inside the Function Arguments dialog, you clicked the Cancel button. You clicked cell B10, clicked cell B10, clicked cell B10, typed =If in cell B10, clicked the =IF(B9>=350000,"35000","1000") view, clicked cell B10, clicked the B10 Cell Input, typed =IF(B9>=350000,"35000","1000") in cell B10, and pressed Enter. Use a single command to clear everything (content and formatting) from the selected cell.
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, you clicked the DialogHeader view, clicked the dialog undefined button. You clicked cell C2. Inside the Function Arguments dialog, you clicked the OK button. Sort the data first alphabetically by the values in the Category column and then by the dates in the Date column with the oldest dates first. [...] In the Home Ribbon Tab in the Editing Ribbon Group, you clicked the Sort & Filter button. You clicked cell B1, double-clicked in cell B1, double-clicked in cell B1, clicked cell B1, double-clicked in cell B1, clicked cell B2, clicked cell B1, double-clicked in cell B1, clicked cell B1, double-clicked in cell B1, clicked cell B2, double-clicked in cell B2, clicked cell D2, clicked cell B1, clicked cell B1, double-clicked in cell B1, double-clicked
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, 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.
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 clicked the Cancel button. You opened the backstage view, clicked the Options navigation button, and clicked the Customize Ribbon tab. Inside the Excel Options dialog, you checked the Developer check box, unchecked the Developer check box, checked the Developer check box, and clicked the OK button. Create a Forecast Sheet based on the selected data. Use a line chart and forecast values through 2018. In the Data Ribbon Tab in the Forecast Ribbon Group, you clicked the Forecast Sheet button. Inside the Create Forecast Worksheet dialog, you clicked the Create button. Run the FormatPieChart macro. In the Developer Ribbon Tab in the Code Ribbon Group, you clicked the Macros button. Inside the Macro dialog, you clicked the Run button. Add a calculated field to this PivotTable to calculate the total pay for each employee (=Salary+Bonus). Name the new field Total Pay. In the Analyze Ribbon Tab in the Calculations Ribbon Group, you clicked the Fields, Items, & Sets button. In the Fields, Items, & Sets menu, you clicked the Calculated Field... menu item. Inside the Insert Calculated Field dialog, you typed Total Pay in the Name input, typed = Salary+Bonus in the Formula input, and clicked the OK button. Add a form control button to run the CreateQ1Chart macro. The button should be placed at approximately cell A1. In the Developer Ribbon Tab in the Controls Ribbon Group, you clicked the Insert button. In the Insert menu, you clicked the Button (Form Control) button. You clicked the undefined view. Inside the Assign Macro dialog, you clicked the OK button. Check if this workbook contains elements that are not compatible with earlier versions of Excel. Close the Compatibility Checker without making any changes. You opened the backstage view, clicked the Check for issues button. In the Protect Workbook menu, you clicked the Check Compatibility menu item. Inside the Microsoft Excel - Compatibility Checker dialog, you clicked the OK button. In cells D2:D20, use data validation to display an in-cell drop-down list of values from the Days named range. 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 List. Inside the Data Validation dialog, you typed =Days in the Source: input, unchecked the Ignore blank check box, and clicked the OK button. 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 Data Ribbon Tab in the Analyze Ribbon Group, you clicked the Solver button. Inside the Solver Parameters dialog, you typed B7 in the Set Objective input, typed Optimal in the By Changing Variable Cells input, and clicked the Add button. Inside the Add Constraint dialog, you typed Optimal in the Cell Reference input, typed Max in the Constraint input, clicked the Add button, and 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 Add button, typed Procedures in the Cell Reference input, typed MaxAllowed in the Constraint input, and clicked the OK button. Inside the Solver Parameters dialog, you clicked the Solve button. Inside the Solver Constraints dialog, you clicked the OK button. 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.
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.
