MGT 2180 TEST 4 QUESTIONS AND ANSWERS
As long as the workbook is open where are the macros available? - Answers - any open
workbook
By default how is macro recorded? - Answers - with absolute references
In a two variable data table which of the following is included in the data range? -
Answers - All of the above
What should you do before you begin to record a macro? - Answers - practice
When is the best time to set a data validation - Answers - before data is entered
When setting a data validation, what is needed to establish criteria? - Answers - A range
of cells
When troubleshooting a macro, which of the following should you do if a dialog box is
open? - Answers - Close the dialog box ad run/ record the macros
When troubleshooting a macro, which of the following should you do if the worksheet
tab is being renamed? - Answers - Press enter to complete renaming the worksheet,
and then run or record a macro
When you build a data validation list, what does the user see when he or she selects
the cell on the worksheet? - Answers - Drop down arrow
Where are the macros saved? - Answers -
Which if the following keys displays additional information on a specific error in the
VBE? - Answers - F1
Which of the following commands is not available in a shared workbook? - Answers -
Deleting Cells
Which of the following creates a visual filter for a field in the PivotTable? - Answers -
Slicer tool
Which of the following displays in the upper right corner of a cell after a comment has
been added? - Answers - Small red triangle-
Which of the following displays warning information yet allows users to make an entry? -
Answers - Information message box
As long as the workbook is open where are the macros available? - Answers - any open
workbook
By default how is macro recorded? - Answers - with absolute references
In a two variable data table which of the following is included in the data range? -
Answers - All of the above
What should you do before you begin to record a macro? - Answers - practice
When is the best time to set a data validation - Answers - before data is entered
When setting a data validation, what is needed to establish criteria? - Answers - A range
of cells
When troubleshooting a macro, which of the following should you do if a dialog box is
open? - Answers - Close the dialog box ad run/ record the macros
When troubleshooting a macro, which of the following should you do if the worksheet
tab is being renamed? - Answers - Press enter to complete renaming the worksheet,
and then run or record a macro
When you build a data validation list, what does the user see when he or she selects
the cell on the worksheet? - Answers - Drop down arrow
Where are the macros saved? - Answers -
Which if the following keys displays additional information on a specific error in the
VBE? - Answers - F1
Which of the following commands is not available in a shared workbook? - Answers -
Deleting Cells
Which of the following creates a visual filter for a field in the PivotTable? - Answers -
Slicer tool
Which of the following displays in the upper right corner of a cell after a comment has
been added? - Answers - Small red triangle-
Which of the following displays warning information yet allows users to make an entry? -
Answers - Information message box
