BUS 150 EVALUATION TEST ANSWERS AND
QUESTIONS SET A+
✔✔The Visual Basic Editor is a separate application that works with Excel and all of the
Office products to edit and manage VBA code. T/F - ✔✔T
✔✔One way to run a macro is to assign it to a(n) button that is placed directly on the
worksheet. T/F - ✔✔T
✔✔When Excel creates a macro button, the Assign Macro dialog box opens with the
button's default name showing. T/F - ✔✔T
✔✔___ is an error alert that rejects invalid data but allows you to override the rejection -
✔✔warning
✔✔____ is a series of stored commands - ✔✔macro
✔✔____ appears when the cell becomes active and can be used to specify the type of
data the user should enter in that cell - ✔✔input message
✔✔_____ is programming language that allows you to create macros - ✔✔VBA
✔✔A _____ is needed before you can add a digital signature to a workbook - ✔✔digital
certificate
✔✔A(n) ___ is an error alert that accepts the invalid data but still allows you to cancel
the data entry - ✔✔information
✔✔____ defines the criteria for storing data in a cell or range - ✔✔validation rule
✔✔____ is a property that determines whether or not changes can be made to a cell -
✔✔locked
, ✔✔___ is an error alert that prevents you from storing the data in the cell - ✔✔stop
✔✔___ is a word or string of characters associated with a single cell or a range -
✔✔defined name
✔✔Which of the following is NOT a valid defined name?
a.
netincome
c.
Net-Income
b.
Net_Income
d.
NetIncome - ✔✔c
✔✔Range names must begin with _____. - ✔✔a letter or an underscore
✔✔Range names can be up to _____ characters. - ✔✔255
✔✔In the accompanying figure, clicking the New button opens the New _____ dialog
box. - ✔✔name
✔✔In the accompanying figure, the column labeled "Refers To" is the range's _____
(location in the work book) - ✔✔location in the workbook
✔✔Using defined names like those shown in the accompanying figure makes creating
and understanding a(n) _____ easier. - ✔✔formula
✔✔The _____ dialog box displays all of the names in the workbook. - ✔✔name
manager
✔✔Any blanks or parentheses in a row or column label will be changed to _____ in
defined names. - ✔✔underscore characters
✔✔The Excel data _____ feature restricts data entry to follow a defined set of rules. -
✔✔validation
✔✔An input message appears when the cell becomes active, and can be used to
specify the _____ of data the user should enter in that cell. - ✔✔type
✔✔In the Allow list box in the Data Validation dialog box, the _____ option means that
the cell will accept only integers. - ✔✔whole number
QUESTIONS SET A+
✔✔The Visual Basic Editor is a separate application that works with Excel and all of the
Office products to edit and manage VBA code. T/F - ✔✔T
✔✔One way to run a macro is to assign it to a(n) button that is placed directly on the
worksheet. T/F - ✔✔T
✔✔When Excel creates a macro button, the Assign Macro dialog box opens with the
button's default name showing. T/F - ✔✔T
✔✔___ is an error alert that rejects invalid data but allows you to override the rejection -
✔✔warning
✔✔____ is a series of stored commands - ✔✔macro
✔✔____ appears when the cell becomes active and can be used to specify the type of
data the user should enter in that cell - ✔✔input message
✔✔_____ is programming language that allows you to create macros - ✔✔VBA
✔✔A _____ is needed before you can add a digital signature to a workbook - ✔✔digital
certificate
✔✔A(n) ___ is an error alert that accepts the invalid data but still allows you to cancel
the data entry - ✔✔information
✔✔____ defines the criteria for storing data in a cell or range - ✔✔validation rule
✔✔____ is a property that determines whether or not changes can be made to a cell -
✔✔locked
, ✔✔___ is an error alert that prevents you from storing the data in the cell - ✔✔stop
✔✔___ is a word or string of characters associated with a single cell or a range -
✔✔defined name
✔✔Which of the following is NOT a valid defined name?
a.
netincome
c.
Net-Income
b.
Net_Income
d.
NetIncome - ✔✔c
✔✔Range names must begin with _____. - ✔✔a letter or an underscore
✔✔Range names can be up to _____ characters. - ✔✔255
✔✔In the accompanying figure, clicking the New button opens the New _____ dialog
box. - ✔✔name
✔✔In the accompanying figure, the column labeled "Refers To" is the range's _____
(location in the work book) - ✔✔location in the workbook
✔✔Using defined names like those shown in the accompanying figure makes creating
and understanding a(n) _____ easier. - ✔✔formula
✔✔The _____ dialog box displays all of the names in the workbook. - ✔✔name
manager
✔✔Any blanks or parentheses in a row or column label will be changed to _____ in
defined names. - ✔✔underscore characters
✔✔The Excel data _____ feature restricts data entry to follow a defined set of rules. -
✔✔validation
✔✔An input message appears when the cell becomes active, and can be used to
specify the _____ of data the user should enter in that cell. - ✔✔type
✔✔In the Allow list box in the Data Validation dialog box, the _____ option means that
the cell will accept only integers. - ✔✔whole number
