MS4 EXAM QUESTIONS AND ANSWERS WITH
COMPLETE SOLUTIONS VERIFIED
You should create a ___ when you want to keep others from changing the
worksheet from protected to unprotected
password
You can scale a worksheet so that it will fit on one page with an option on the
____ tab in the Page Setup dialog box.
page
To select noncontiguous ranges, after selecting the first range, hold down the
____ key an drag through the additional ranges of cells to select them.
CTRL
Cell ____ can be used to distinguish the different functional parts of a worksheet.
borders
Which of the following is the path to the Borders button?
(HOME tab | Font group)
The ____ function returns the present value of an annuity.
PV
You can set up a worksheet to print in black and white with an option on the ____
tab in the Page Setup dialog box.
sheet
Names are ____ to the workbook.
, global
Which of the following is the path to the Protect Sheet button?
(REVIEW tab | Changes group)
Which of the following is the maximum number of active data tables per
worksheet?
as many as you want
Cell ____________________ ensures that users do not change values
inadvertently that are critical to the worksheet.
protection
A(n) ____ shows the beginning and ending balances and the amount of payment
that is applied to the principal and interest during each payment period.
amortization schedule
Names are ____ cell references.
absolute
If you wish to allow another worksheet user to be able to manipulate some cells,
leave those cells ____.
unprotected
You can deselect multiple selected sheets beginning with the Sheet1 tab by
pressing the ____ key and clicking the Sheet1 tab.
shift
You can delete a data table by selecting the data table and then ____.`
pressing the DELETE key
COMPLETE SOLUTIONS VERIFIED
You should create a ___ when you want to keep others from changing the
worksheet from protected to unprotected
password
You can scale a worksheet so that it will fit on one page with an option on the
____ tab in the Page Setup dialog box.
page
To select noncontiguous ranges, after selecting the first range, hold down the
____ key an drag through the additional ranges of cells to select them.
CTRL
Cell ____ can be used to distinguish the different functional parts of a worksheet.
borders
Which of the following is the path to the Borders button?
(HOME tab | Font group)
The ____ function returns the present value of an annuity.
PV
You can set up a worksheet to print in black and white with an option on the ____
tab in the Page Setup dialog box.
sheet
Names are ____ to the workbook.
, global
Which of the following is the path to the Protect Sheet button?
(REVIEW tab | Changes group)
Which of the following is the maximum number of active data tables per
worksheet?
as many as you want
Cell ____________________ ensures that users do not change values
inadvertently that are critical to the worksheet.
protection
A(n) ____ shows the beginning and ending balances and the amount of payment
that is applied to the principal and interest during each payment period.
amortization schedule
Names are ____ cell references.
absolute
If you wish to allow another worksheet user to be able to manipulate some cells,
leave those cells ____.
unprotected
You can deselect multiple selected sheets beginning with the Sheet1 tab by
pressing the ____ key and clicking the Sheet1 tab.
shift
You can delete a data table by selecting the data table and then ____.`
pressing the DELETE key
