BUS 150 PRACTICE EXAMS ANSWERS AND
QUESTIONS SET A+
✔✔In the Allow list box in the Data Validation dialog box, the _____ option means that
the cell will accept only text of a specified number of characters. - ✔✔text length
✔✔In the Allow list box in the Data Validation dialog box, the _____ option means that
the cell will accept only times. - ✔✔time
✔✔Sometimes when you build a worksheet for other users, you may decide to add a(n)
_____ message to a cell even if you do not validate the data in that cell. - ✔✔input
✔✔Which of the following tabs in the Data Validation dialog box allows you to set
validation criteria?
a.
Criteria
c.
Error Alert
b.
Input Message
d.
Settings - ✔✔d
✔✔You use the _____ tab in the Data Validation dialog box to enter the validation rules
for the active cell. - ✔✔settings
✔✔_____ messages appear as ScreenTips next to the active cell. - ✔✔input
✔✔The following are Excel-supported error alert types: _____. - ✔✔stop, warning, alert
✔✔The _____ alert accepts the invalid data but still allows you to cancel the data entry.
- ✔✔information
, ✔✔When you _____ a workbook, you control the ability users have to make changes to
the file. - ✔✔protect
✔✔Every cell in a workbook has a(n) _____ property that determines whether or not
changes can be made to that cell. - ✔✔locked
✔✔Usually, you will want to protect a worksheet but leave some cells _____. -
✔✔unlocked
✔✔Protecting the _____ prohibits users from renaming, deleting, hiding, or inserting
worksheets. - ✔✔structure
✔✔To remove workbook protection, click the Unprotect Workbook button in the _____
group on the REVIEW tab. - ✔✔changes
✔✔Comments like those in the accompanying figure are often used to _____. - ✔✔skip
✔✔To keep a comment like the one in the accompanying figure on the screen, in the
Comments group on the _____ tab, click the Show/Hide Comment button. -
✔✔REVIEW
✔✔A _____ can be destructive and can modify or delete files that may not be
recoverable. - ✔✔macro virus
✔✔The _____ Center is a central location for all the security settings in Office. - ✔✔trust
✔✔If content is blocked, the _____ located under the Ribbon appears, notifying you that
some content was disabled. - ✔✔message bar
✔✔A(n) _____ certificate is another name for a digital ID. - ✔✔digital
✔✔A digital _____ is like a seal of approval. - ✔✔signature
✔✔To create a macro, you can enter a series of commands in the _____ programming
language. - ✔✔VBA
✔✔The _____ Macro workbook is a hidden workbook opened whenever you start
Excel, making its macros available anytime you use Excel. - ✔✔personal
✔✔You can turn off the macro recorder by clicking the Stop Recording button in the
Code group on the _____ tab. - ✔✔developer
QUESTIONS SET A+
✔✔In the Allow list box in the Data Validation dialog box, the _____ option means that
the cell will accept only text of a specified number of characters. - ✔✔text length
✔✔In the Allow list box in the Data Validation dialog box, the _____ option means that
the cell will accept only times. - ✔✔time
✔✔Sometimes when you build a worksheet for other users, you may decide to add a(n)
_____ message to a cell even if you do not validate the data in that cell. - ✔✔input
✔✔Which of the following tabs in the Data Validation dialog box allows you to set
validation criteria?
a.
Criteria
c.
Error Alert
b.
Input Message
d.
Settings - ✔✔d
✔✔You use the _____ tab in the Data Validation dialog box to enter the validation rules
for the active cell. - ✔✔settings
✔✔_____ messages appear as ScreenTips next to the active cell. - ✔✔input
✔✔The following are Excel-supported error alert types: _____. - ✔✔stop, warning, alert
✔✔The _____ alert accepts the invalid data but still allows you to cancel the data entry.
- ✔✔information
, ✔✔When you _____ a workbook, you control the ability users have to make changes to
the file. - ✔✔protect
✔✔Every cell in a workbook has a(n) _____ property that determines whether or not
changes can be made to that cell. - ✔✔locked
✔✔Usually, you will want to protect a worksheet but leave some cells _____. -
✔✔unlocked
✔✔Protecting the _____ prohibits users from renaming, deleting, hiding, or inserting
worksheets. - ✔✔structure
✔✔To remove workbook protection, click the Unprotect Workbook button in the _____
group on the REVIEW tab. - ✔✔changes
✔✔Comments like those in the accompanying figure are often used to _____. - ✔✔skip
✔✔To keep a comment like the one in the accompanying figure on the screen, in the
Comments group on the _____ tab, click the Show/Hide Comment button. -
✔✔REVIEW
✔✔A _____ can be destructive and can modify or delete files that may not be
recoverable. - ✔✔macro virus
✔✔The _____ Center is a central location for all the security settings in Office. - ✔✔trust
✔✔If content is blocked, the _____ located under the Ribbon appears, notifying you that
some content was disabled. - ✔✔message bar
✔✔A(n) _____ certificate is another name for a digital ID. - ✔✔digital
✔✔A digital _____ is like a seal of approval. - ✔✔signature
✔✔To create a macro, you can enter a series of commands in the _____ programming
language. - ✔✔VBA
✔✔The _____ Macro workbook is a hidden workbook opened whenever you start
Excel, making its macros available anytime you use Excel. - ✔✔personal
✔✔You can turn off the macro recorder by clicking the Stop Recording button in the
Code group on the _____ tab. - ✔✔developer
