Excel Ch 8.
Which of these is NOT an available level of security in Excel? Disable all macros Disable all macros except digitally signed macros Disable all macros with notification Disable all macros without notification
Disable all macros
Which of these is NOT an available level of protection in Excel? Excel-level protection Workbook-level protection Worksheet-level protection Cell-level protection
Excel-level protection
All worksheet cells are unlocked by default.
F
Cell references CANNOT be used with PV and FV functions.
F
In the PMT, PV, and FV functions, the interest rate argument is always expressed in annual terms.
F
The number 1 represents the default entry for the type argument in PMT, PV, and FV functions.
F
When protecting a worksheet, you must create a password.
F
When the Hidden option on the Protection tab of the Format Cells dialog box is checked, what is NOT displayed in the worksheet? Formulas Labels Values Formula Results
Formulas
For a bond, which formula argument represents a payment and requires the inclusion of a negative sign before the argument to reverse its sign within financial formulas? Rate Future Value Present Value Periods
Future Value
Which of these CANNOT be used to run a macro? Shortcut keys Custom buttons Quick Access toolbar Page Layout tab
Page Layout tab
What is the first argument in the PV function Type Periods Rate Payment
Rate
Which of these is NOT an option in the Protect Sheet dialog box? Select unlocked cells Format rows Select locked sheets Insert hyperlinks
Select locked sheets
In Excel 2016, the Windows protection option has been disabled.
T
Macro names CANNOT include spaces.
T
The PMT, PV, and FV functions are displayed in the Financial section of the Insert Function dialog box.
T
The Protect Sheet command can be accessed on the Review and Home tabs.
T
The [Tab] key can be used to move through unlocked cells in a worksheet.
T
What is the optional argument for PMT, PV, and FV functions? Rate Periods Payment Correct! Type
Type
On what tab is the Record Macro option found? Insert Formulas Data View
View
Interest rates, including the effective interest rate and contract interest rate, are typically expressed in _____ terms. weekly monthly semiannual annual
annual
