1|Page
Busi 230 Final Exam| Latest Questions
And Verified Answers 2026
Current date - correct-answer -Ctrl+; (Ctrl and semi-colon)
Shows format cells dialog window - correct-answer -Ctrl+1 (Ctrl and 1)
using cell reference is preferred to directly inputting values into a formula -
correct-answer -true
inserts cells - correct-answer -Ctrl+Shift+plus
The Error Alert Style of _____ indicates the entry does not conform to the data
validation rules, and can be canceled, corrected, or accepted. - correct-answer -
warning
,2|Page
To automate repetitive or difficult tasks, use a _____, which is a series of
commands that you store and then run when you need to perform a task. -
correct-answer -macro
The data validation default (list box) option is _____. - correct-answer -any value
A macro can be tested one step at a time by clicking the _____ button in the
Macro dialog box. - correct-answer -step into
Data validation rules can contain formulas. - correct-answer -true
By changing the Error Checking Rules, you can specify that Excel will alert you
about the following: _____. - correct-answer -A. Cells containing years
represented as 2 digits
C. Formulas which omit cells in a region
D. Unlocked cells containing formulas
A validation rule can specify _____. - correct-answer -dates, values such as
between 1 and 100, decimal number
,3|Page
When a worksheet is protected, by default, all cells in the worksheet are unlocked.
- correct-answer -false
By choosing Protect Sheet, you can prevent a worksheet from being deleted from
a workbook. - correct-answer -False
_____ prevents inserting, deleting, or renaming worksheets. - correct-answer -
workbook protection
A _____ specifies the type of data that is appropriate/allowed as content in a cell
(...for example, whole numbers, decimal numbers, dates, time, or text). - correct-
answer -validation rule
_____ are items that are, in fact, incorrect, but are not flagged as such. - correct-
answer -false negatives
To unlock cells in a protected workbook, click the Locked box to remove the check
mark on the Protection tab of the __________. - correct-answer -format cells
menu/window
, 4|Page
The name of a macro can contain letters, numbers, spaces, and the underscore
symbol. - correct-answer -false
The name of a macro can contain letters, numbers, spaces, and the underscore
symbol. - correct-answer -hiding cells so that users cannot see them
specifying which actions users can perform
locking cells so that users cannot change their contents
A(n) _____ cell uses the value in the active cell in its formula. - correct-answer -
dependent
After you create and test a macro, you can attach a _____ to vouch for its
authenticity. - correct-answer -D. digital certificat
the Error Alert Style of _____ indicates the entry is incorrect and must be canceled
or corrected before continuing. - correct-answer -stop
The data validation tool restricts the _____. - correct-answer -data being entered
Busi 230 Final Exam| Latest Questions
And Verified Answers 2026
Current date - correct-answer -Ctrl+; (Ctrl and semi-colon)
Shows format cells dialog window - correct-answer -Ctrl+1 (Ctrl and 1)
using cell reference is preferred to directly inputting values into a formula -
correct-answer -true
inserts cells - correct-answer -Ctrl+Shift+plus
The Error Alert Style of _____ indicates the entry does not conform to the data
validation rules, and can be canceled, corrected, or accepted. - correct-answer -
warning
,2|Page
To automate repetitive or difficult tasks, use a _____, which is a series of
commands that you store and then run when you need to perform a task. -
correct-answer -macro
The data validation default (list box) option is _____. - correct-answer -any value
A macro can be tested one step at a time by clicking the _____ button in the
Macro dialog box. - correct-answer -step into
Data validation rules can contain formulas. - correct-answer -true
By changing the Error Checking Rules, you can specify that Excel will alert you
about the following: _____. - correct-answer -A. Cells containing years
represented as 2 digits
C. Formulas which omit cells in a region
D. Unlocked cells containing formulas
A validation rule can specify _____. - correct-answer -dates, values such as
between 1 and 100, decimal number
,3|Page
When a worksheet is protected, by default, all cells in the worksheet are unlocked.
- correct-answer -false
By choosing Protect Sheet, you can prevent a worksheet from being deleted from
a workbook. - correct-answer -False
_____ prevents inserting, deleting, or renaming worksheets. - correct-answer -
workbook protection
A _____ specifies the type of data that is appropriate/allowed as content in a cell
(...for example, whole numbers, decimal numbers, dates, time, or text). - correct-
answer -validation rule
_____ are items that are, in fact, incorrect, but are not flagged as such. - correct-
answer -false negatives
To unlock cells in a protected workbook, click the Locked box to remove the check
mark on the Protection tab of the __________. - correct-answer -format cells
menu/window
, 4|Page
The name of a macro can contain letters, numbers, spaces, and the underscore
symbol. - correct-answer -false
The name of a macro can contain letters, numbers, spaces, and the underscore
symbol. - correct-answer -hiding cells so that users cannot see them
specifying which actions users can perform
locking cells so that users cannot change their contents
A(n) _____ cell uses the value in the active cell in its formula. - correct-answer -
dependent
After you create and test a macro, you can attach a _____ to vouch for its
authenticity. - correct-answer -D. digital certificat
the Error Alert Style of _____ indicates the entry is incorrect and must be canceled
or corrected before continuing. - correct-answer -stop
The data validation tool restricts the _____. - correct-answer -data being entered
