Advanced Excel with verified
solutions
A _____ can be destructive and can modify or delete
files that may not be recoverable. - answer macro
virus
A data ___ table describes the fields you plan to
maintain in a table. - answer Definition
A digital ____ is like a seal of approval. - answer
Signature
A table name cannot include _____. - answer Spaces
After the comments, in VBA code the next item is
the ______ of the macro. - answer Body
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. - answer Type
Any blanks or parentheses in a row or column label
will be changed to ____ in defined names. - answer
Underscore characters
, By default, the PivotTable report uses the ____
function for numbers in the Values area. - answer
SUM
Juan tells you that your work in Excel will go a lot
faster if you start using defined names instead of
cell and range addresses. You believe him but you
have been frustrated by defined names in the past
bc you have run into errors. Which of the following
is an example of a valid defined name Juan can
provide to you? - answer FiscalYear2010
Each sub procedure in VBA begins with the
keyword "Sub" followed by the name of the sub
procedure and a set of ______. - answer Parentheses
Excel assigns the name ____ to the first Excel table
created in a workbook. - answer Table1
If a ___ error appears when you run a macro that
has worked in the past, some part of the macro
code no longer makes sense to Excel. - answer
Run-time
solutions
A _____ can be destructive and can modify or delete
files that may not be recoverable. - answer macro
virus
A data ___ table describes the fields you plan to
maintain in a table. - answer Definition
A digital ____ is like a seal of approval. - answer
Signature
A table name cannot include _____. - answer Spaces
After the comments, in VBA code the next item is
the ______ of the macro. - answer Body
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. - answer Type
Any blanks or parentheses in a row or column label
will be changed to ____ in defined names. - answer
Underscore characters
, By default, the PivotTable report uses the ____
function for numbers in the Values area. - answer
SUM
Juan tells you that your work in Excel will go a lot
faster if you start using defined names instead of
cell and range addresses. You believe him but you
have been frustrated by defined names in the past
bc you have run into errors. Which of the following
is an example of a valid defined name Juan can
provide to you? - answer FiscalYear2010
Each sub procedure in VBA begins with the
keyword "Sub" followed by the name of the sub
procedure and a set of ______. - answer Parentheses
Excel assigns the name ____ to the first Excel table
created in a workbook. - answer Table1
If a ___ error appears when you run a macro that
has worked in the past, some part of the macro
code no longer makes sense to Excel. - answer
Run-time
