SimNet Program Exam QUESTIONS WITH |\ |\ |\ |\ |\
ANSWERS
Hide the column showing 2016 data and the bonus rate. -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔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. - CORRECT ANSWERS ✔✔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. - CORRECT ANSWERS ✔✔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. - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔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). - CORRECT ANSWERS ✔✔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. - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔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. -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔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. - CORRECT ANSWERS ✔✔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. -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔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. - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔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. - CORRECT ANSWERS ✔✔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.
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
- CORRECT ANSWERS ✔✔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. - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔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. - CORRECT ANSWERS ✔✔You opened the
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
backstage view, clicked the Print navigation button, clicked the
|\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS
Hide the column showing 2016 data and the bonus rate. -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔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. - CORRECT ANSWERS ✔✔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. - CORRECT ANSWERS ✔✔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. - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔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). - CORRECT ANSWERS ✔✔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. - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔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. -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔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. - CORRECT ANSWERS ✔✔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. -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔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. - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔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. - CORRECT ANSWERS ✔✔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.
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
- CORRECT ANSWERS ✔✔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. - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔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. - CORRECT ANSWERS ✔✔You opened the
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
backstage view, clicked the Print navigation button, clicked the
|\ |\ |\ |\ |\ |\ |\ |\ |\
