MGT 2180- EXAM #4 MULTIPLE CHOICE QUESTIONS
AND ANSWERS
Add a slicer to the pivottable for the State field and use the slicer to show only data
where the value is . VA - Answers - analyze-- insert slicer-- select "State"-- select "VA"
When you run a macro that was recorded with absolute references, where should the
active cell be before running the macro? - Answers - NOT A1
Begin recording a new macro - Answers - developer tab-- record macro (under the
"code" category)
Which of the following is always the first key in a macro shortcut? - Answers - Ctrl
Which of the following shows a preview of data that will be imported when building a
query for a database table? - Answers - Navigator window
When you use the Solver Results dialog box, where are the statistical analysis reports
placed? - Answers - not a separate workbook
Which of the following is not a pane in the VBE program? - Answers - NOT project
explorer pane
Which of the following best describes a Trusted Location in Excel? - Answers - a folder
Which of the following types of workbooks open in Protected View? - Answers - all of
the above
What should you do before you begin to record a macro? - Answers - NOT save the
workbook
In cells D2:D13, use data validation to display an in-cell drop-down list of values from
the medcodes named range. Allow blanks. - Answers -
Which of the following statements is not true when editing a scenario? - Answers - the
cell range cannot be adjusted
Which of the following is a comment message that appears on screen as soon as a cell
with data validation is selected? - Answers - not validation message
Which of the following is not an option on the advanced table of the share workbook
dialog box - Answers - allow changes by more than 1 user
, Turn on track changes to highlight all changes made in this workbook since it was last
saved - Answers - review-- track changes arrow-- highlight changes-- check the box at
the top of the popup--press OK
Which of the following statements related to scenario summary reports is not true? -
Answers - you cannot edit a scenario after creating a summary report
Which of the following statements is not true for a Button form control? - Answers - you
cannot select a button control without running the macro
Which of the following error alerts shows an exclamation point (!) In a yellow triangle -
Answers - warning box
Which of the following is not a concept in code development? - Answers - calling
method
Which of the following concepts in code development is a function, service, or action for
an object? - Answers - methods
Edit the code for the formattable macro in the Visual Basic Editor - Answers -
Which of the following is a term for workbooks in code development? - Answers - not
properties and methods
Which of the following statements . Is true about using comments in macro code? -
Answers - all of the above
Which of the following is not true for Excel templates? - Answers - templates cannot
include formulas
When setting data validation, what is needed to establish criteria? - Answers - a range
of cells
Which of the following statements about working with data tables is not true? - Answers
- you cannot select all results in a cell and delete them
Which of the following is not true when building a one-variable data table? - Answers -
when the data table has multiple formulas, the formulas must be in different rows
Which of the following is a visual filter for a date field in a pivottable? - Answers - NOT
filter by color
Slicer tool?
Create a new scenario to reflect a change in cell B8 to a value of 0.09. Name the
scenario New Bonus - Answers -
AND ANSWERS
Add a slicer to the pivottable for the State field and use the slicer to show only data
where the value is . VA - Answers - analyze-- insert slicer-- select "State"-- select "VA"
When you run a macro that was recorded with absolute references, where should the
active cell be before running the macro? - Answers - NOT A1
Begin recording a new macro - Answers - developer tab-- record macro (under the
"code" category)
Which of the following is always the first key in a macro shortcut? - Answers - Ctrl
Which of the following shows a preview of data that will be imported when building a
query for a database table? - Answers - Navigator window
When you use the Solver Results dialog box, where are the statistical analysis reports
placed? - Answers - not a separate workbook
Which of the following is not a pane in the VBE program? - Answers - NOT project
explorer pane
Which of the following best describes a Trusted Location in Excel? - Answers - a folder
Which of the following types of workbooks open in Protected View? - Answers - all of
the above
What should you do before you begin to record a macro? - Answers - NOT save the
workbook
In cells D2:D13, use data validation to display an in-cell drop-down list of values from
the medcodes named range. Allow blanks. - Answers -
Which of the following statements is not true when editing a scenario? - Answers - the
cell range cannot be adjusted
Which of the following is a comment message that appears on screen as soon as a cell
with data validation is selected? - Answers - not validation message
Which of the following is not an option on the advanced table of the share workbook
dialog box - Answers - allow changes by more than 1 user
, Turn on track changes to highlight all changes made in this workbook since it was last
saved - Answers - review-- track changes arrow-- highlight changes-- check the box at
the top of the popup--press OK
Which of the following statements related to scenario summary reports is not true? -
Answers - you cannot edit a scenario after creating a summary report
Which of the following statements is not true for a Button form control? - Answers - you
cannot select a button control without running the macro
Which of the following error alerts shows an exclamation point (!) In a yellow triangle -
Answers - warning box
Which of the following is not a concept in code development? - Answers - calling
method
Which of the following concepts in code development is a function, service, or action for
an object? - Answers - methods
Edit the code for the formattable macro in the Visual Basic Editor - Answers -
Which of the following is a term for workbooks in code development? - Answers - not
properties and methods
Which of the following statements . Is true about using comments in macro code? -
Answers - all of the above
Which of the following is not true for Excel templates? - Answers - templates cannot
include formulas
When setting data validation, what is needed to establish criteria? - Answers - a range
of cells
Which of the following statements about working with data tables is not true? - Answers
- you cannot select all results in a cell and delete them
Which of the following is not true when building a one-variable data table? - Answers -
when the data table has multiple formulas, the formulas must be in different rows
Which of the following is a visual filter for a date field in a pivottable? - Answers - NOT
filter by color
Slicer tool?
Create a new scenario to reflect a change in cell B8 to a value of 0.09. Name the
scenario New Bonus - Answers -
