SIMNET PROGRAM EXAMS SCRIPT 2026.pdf 1. Document information

SIMNET PROGRAM EXAMS SCRIPT 2026/2027
QUESTIONS AND SOLUTIONS RATED A+
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. - ✔✔You opened the backstage view, clicked the Print navigation button, clicked
the Print Orientation button, clicked the Print Orientation button, clicked the Print
Orientation button, clicked the Print Selection button, clicked the Print Selection button,
clicked the Print Orientation button, and clicked the Scaling button. In the Scaling menu,
you clicked the Fit All Columns on One Page menu item.

✔✔Enter a formula in cell B1 using the SUMPRODUCT function to calculate the total
value of the current leases by multiplying the current monthly rents by the remaining
months on each lease. Use the range names Rents and Leases. - ✔✔In the Formulas
Ribbon Tab in the Function Library Ribbon Group, you clicked the Math & Trig button. In
the Math & Trig menu, you clicked the SUMPRODUCT menu item. Inside the Function
Arguments dialog, you typed Rents in the Array1 input, typed Leases in the Array2
input, and clicked the OK button.

✔✔Enter a formula in the selected cell using SUMIF to calculate the total expenses for
the category Office Expense. Use the range name Category for the Range argument,
the text string "Office Expense" for the Criteria argument, and Cost for the Sum_range
argument. - ✔✔You typed in cell F2. In the Formulas Ribbon Tab in the Function Library
Ribbon Group, you clicked the More Functions button, clicked the Math & Trig button. In
the Math & Trig menu, you clicked the SUMIF menu item. Inside the Function
Arguments dialog, you typed Category in the Range input, typed "Office Expense" in the
Criteria input, typed Cost in the Sum_range input, and clicked the OK button.

✔✔Using cell references, enter a formula in cell B6 to calculate monthly payments for
the loan described in this worksheet. Omit the optional arguments. Use a negative value
for the Pv argument. - ✔✔In the Formulas Ribbon Tab in the Function Library Ribbon
Group, you clicked the Financial button. In the Financial menu, you clicked the PMT
menu item. Inside the Function Arguments dialog, you typed B3/12 in the Rate input,
typed B4 in the Nper input, typed -B2 in the Pv input, and clicked the OK button.

, ✔✔Display the formulas in this worksheet. - ✔✔In the Formulas Ribbon Tab in the
Formula Auditing Ribbon Group, you clicked the Show Formulas button.

✔✔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.