SIMNET EXCEL 2025/2026 Exam 2
Comprehensive Questions and
Verified Answers | Accurate Solutions
| Get it 100% Correct!! | Already
Graded A+
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.
Comprehensive Questions and
Verified Answers | Accurate Solutions
| Get it 100% Correct!! | Already
Graded A+
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.
