MGT 2180 Exam 4 Multiple Choice Questions
Which of the following keyboard shortcuts opens the VBE window? a. Alt+F11 b. Ctrl+F11 c. Shift+F11 d. F11
a. Alt+F11
Which of the following is not true for inserting an Option Button form control? a. An Option Button control is a drop-down list from which you select one option. b. To insert an Option Button, click the Insert Controls button on the Developer tab. c. Drag the pointer to draw the control. d. Right-click the control to edit the default label.
a. An Option Button control is a drop-down list from which you select one option.
Which of the following is not true for inserting an Option Button form control? a. An Option Button control is a drop-down list from which you select one option. b. To insert an Option Button, click the insert Controls button on the developer tab. c. Drag the pointer to draw the control. d. Right-click the control to edit the default label.
a. An Option Button control is a drop-down list from which you select one option.
Which of the following statements is not true when editing a scenario? a. The cell range cannot be adjusted. b. You can change a scenario name. c. A default comment is generated each time the scenario is edited. d. TheScenarios Values dialog box shows the current values for the scenario.
a. The cell range cannot be adjusted.
Which of the following shows a preview of data that will be imported when building a query for a database table? a. Query Editor b. Navigator window c. Workbook Queries pane d. Query Settings pane
b. Navigator window
Which of the following tasks is not performed using the Excel Options dialog box? a. Set whether comments display. b. Set data validation rules. c. Change the default folder for Personal templates. d. Add commands to customize the Quick Access Toolbar.
b. Set data validation rules
Which of the following is not true for a PowerPivot table? a. It resembles an Excel worksheet without row or column headings. b. You can edit data in a PowerPivot sheet. c. You can build calculations and formulas. d. You can sort and filter data.
b. You can edit data in a PowerPivot sheet.
Which of the following is not true when creating a macros-only workbook? a. Delete data and undo commands that were entered as macros were recorded. b. Document the name and description for each macro. c. Save the macro in the macros-only folder. d. Save the macro as an Excel macro-enabled workbook.
c. Save the macro in the macros-only folder.
When typing entries for a data validation list in the Data Validation dialog box, how are items separated? a. pound signs (#) b. semi-colons (;) c. commas (,) d. slashes (/)
c. commas (,)
In VBA code, what is the name of each line that is preceded by an apostrophe and shown in green? a. coding statement b. module c. comment d. sub procedure
c. comment
What should you do before creating a new scenario in Excel? a. open a new workbook b. switch to a new worksheet c. save the current data in a worksheet as a scenario d. insert a few rows at the top of the current worksheet for the new scenario
c. save the current data in a worksheet as a scenario
Which of the following is a pop-up text box attached to a cell? a. Warning b. Error alert c. Form control d. Comment
d. Comment
Which of the following is not true when recording a macro? a. A shortcut is required. b. The description is included as a comment in the VBA code. c. If you make an error, correct it. d. Delete the data or undo commands that were completed while recording the macro.
a. A shortcut is required.
Which of the following is not true regarding the Compatibility Checker dialog box? a. Access the Compatibility Checker by clicking the Review tab. b. The Compatibility Checker describes each unsupported feature. c. You can choose a particular Excel version. d. You can select an option to create a sheet that details issues if the workbook is not shared.
a. Access the Compatibility Checker by clicking the Review tab.
Which of the following methods do not return to the Excel worksheet from the VBE window? a. Click Window on the toolbar and choose Microsoft Excel. b. Click the Close button in the top right corner of the VBE window. c. Click the View Microsoft Excel button at the left of the toolbar. d. Press Alt+F11.
a. Click Window on the toolbar and choose Microsoft Excel.
Which of the following do you use to edit macro actions? a. Code window b. Project Explorer pane c. Record window d. Properties window
a. Code window
Which of the following is not true for a Personal Macro workbook? a. Contains macros and data. b. Opens automatically as a hidden workbook each time you start Excel. c. Macros are always available. d. To edit macros in PERSONAL.xlsb, you must unhide the workbook.
a. Contains macros and data.
Which of the following statements is not true for tracked changes? a. Edits are highlighted with a fill color. b. Triangles display in the upper left corners. c. A comment box displays for each change. d. User name and edits are identified.
a. Edits are highlighted with a fill color.
Which of the following keys displays additional information on a specific error in the VBE? a. F1 b. F2 c. F3 d. F4
a. F1
When troubleshooting a macro, which of the following should you do if macros are automatically disabled without notification when the workbook is open? a. Select Disable all macros with notification from the Macro Security button. b. End the current macro before running or recording another macro. c. Press Enter to end Edit mode, and then run or record a macro. d. Unprotect the workbook before running or recording a macro.
a. Select Disable all macros with notification from the Macro Security button.
When troubleshooting a macro, which of the following should you do if macros are automatically disabled without notification when the workbook is open? a. Select Disable all macros with the notification from the Macro Security button. b. End the current macro before running or recording another macro. c. Press Enter to end Edit mode, and then run or record a macro. d. Unprotect the workbook before running or recording a macro.
a. Select Disable all macros with notification from the Macro Security button.
Which of the following is not a Report Layout for a PivotTable? a. Totals and Filters form b. Tabular form c. Outline form d. Compact format
a. Totals and Filters form
Which of the following statements related to scenario summary reports is not true? a. You cannot edit a scenario after creating a summary report. b. For a large worksheet with many scenarios, you can choose to format a scenario summary report as a PivotTable. c. In a summary report, you can hide or display details about the changing cells and the result cells. d. A scenario summary report is a generated worksheet that describes each scenario in a workbook.
a. You cannot edit a scenario after creating a summary report.
When setting data validation, what is needed to establish criteria? a. a range of cells b. a column or row c. a worksheet d. an entire workbook
a. a range of cells
When you select a state abbreviation from a combo box, how does the form control record your selection? a. as a value b. as an alphanumeric character c. using the characters you selected from the combo box d. as a string of letters and numbers
a. as a value
When is the best time to set data validation? a. before data is entered b. after data is entered c. after building conditions d. after saving the workbook
a. before data is entered
Which of the following are lines of text shown in black between Sub and End Sub? a. coding statement b. module c. comment d. sub procedure
a. coding statement
Which of the following is data that is the same in each query and allows for a relationship between queries? a. common field b. key field c. primary field d. related field
a. common field
Which of the following is defined as a range of cells that shows calculated results for one or more formulas? a. data table b. calculated field c. slicer d. input values
a. data table
Which of the following is defined as a range of cells that shows calculated results for one or more formulas? a. data table b. calculated field c. slicer d. input values
a. data table
When you set data validation, which of the following is a pop-up message that appears after invalid data is entered? a. error alert message b. input message c. validation message d. warning message
a. error alert message
When using Solver, which of the following parameters is a cell with a formula to be calculated to reach a desired result? a. objective cell b. variable cells c. constraint d. algorithm
a. objective cell
Which of the following displays in the upper right corner of a cell after a comment has been added? a. small red triangle b. yellow box c. red highlighting d. blue square
a. small red triangle
How many sets of input values does a two-variable data table use? a. two b. four c. six d. eight
a. two
By default, how is a macro recorded? a. with absolute references b. with relative references c. with mixed references d. all of the above
a. with absolute references
Which of the following extensions identifies a macro-enabled workbook? a. .xlt b. .xlsm c. .xlst d. .xls
b. .xlsm
Which of the following statements is not true about calculated fields? a. A calculated field is one that appears in a PivotTable. b. A calculated field is a field in the source data. c. A calculated field uses a value field from the PivotTable's underlying data in a formula. d. You can move calculated fields in a PivotTable.
b. A calculated field is a field in the source data.
Which of the following is not true when creating a scenario? a. Scenarios are simple what-if analysis tools. b. A worksheet can have up to 24 scenarios. c. Thefirst scenario that you create is a scenario for current data. d. You can select the cell range before starting the scenario Manager command.
b. A worksheet can have up to 24 scenarios.
Which of the following is not true when using Goal Seek? a. Goal Seek solves a formula for one argument. b. An absolute value is typed in the To value box. c. The target value is the result you want the formula to return. d. You can click the By changing cell box and click the cell to be adjusted or key the address.
b. An absolute value is typed in the To value box.
Which of the following identifies commands, features, and other objects that are not supported in earlier versions of Excel? a. Inspect Document command b. Check Compatibility command c. Document Inspector d. Trust Center
b. Check Compatibility command
Which of the following is an Excel add-in? a. Slicer b. Solver c. XML d. Scenario Manager
b. Solver
Which of the following statements about the Developer tab and the Form button are not true? a. The Insert Controls button is located on the Developer tab on the Ribbon. b. The Developer tab is displayed on the Ribbon by default. c. Excel's Form button is used to create a simple data entry form. d. The Form button can be added to the Quick Access toolbar or to another tab on the Ribbon.
b. The Developer tab is displayed on the Ribbon by default.
Which of the following is not true when creating an error alert? a. Click the DataValidation button. b. Type a required title. c. Type the message to appear in the warning box. d. Use capitalization and punctuation as you want it to appear in the warning box.
b. Type a required title.
Which of the following is not true when using a data validation list? a. Enter the data in alphabetical order. b. Type the data in random order. c. Type the data in ascending order. d. Type the data in descending order.
b. Type the data in random order.
Which of the following is a programming language that allows you to expand the abilities of Excel? a. SQL b. VBA c. C++ d. JavaScript
b. VBA
Which of the following is not true when building a one-variable data table? a. A one-variable data table uses one input value in the command. b. When the data table has multiple formulas, the formulas must be in different rows. c. You can edit an input value after the data table is calculated. d. When input values are in a row, the first formula must be one column to the left of the first value and one row below.
b. When the data table has multiple formulas, the formulas must be in different rows.
Which of the following is not true when building a one-variable data table? a. A one-variable data table uses one input value in the command. b. When the data table has multiple formulas, the formulas must be in different rows. c. You can edit an input value after the data table is calculated. d. When input values are in a row, the first formula must be one column to the left of the first value and one row below.
b. When the data table has multiple formulas, the formulas must be in different rows.
Which of the following is a column in which each data piece appears only once? a. common field b. key field c. primary field d. related field
b. key field
Where are macros saved? a. active worksheet b. macro-enabled workbook c. a VBA file d. all of the above
b. macro-enabled workbook
When you use the Solver Results dialog box, where are the statistical analysis reports placed? a. in the same sheet b. on a separate sheet c. in a separate workbook d. in the Clipboard for pasting in an Office document
b. on a separate sheet
Which of the following concepts in code development represents a characteristic or attribute? a. objects b. properties c. methods d. collections
b. properties
In a data input form, how are labels and entry boxes for data displayed? a. left-to-right layout b. vertical layout c. table layout d. horizontal layout
b. vertical layout
Which of the following file extensions provides data scheme information? a. .xsi b. .xst c. .xsd d. .xds
c. .xsd
What happens when you try to save a workbook with macros as a regular Excel workbook? a. The workbook file is saved as usual. b. A message box displays indicating that your VBA work was saved. c. A message box reminds you that your VBA work cannot be saved in a regular workbook. d. A message box reminds you that the workbook¿s file size will be larger as a result of the macros.
c. A message box reminds you that your VBA work cannot be saved in a regular workbook.
Which of the following is not an option on the PivotTable Tools Design tab? a. Insert a blank row after items b. Hide subtotals and grand totals c. AutoFit column widths on update d. Repeat row labels
c. AutoFit column widths on update
Which of the following is not an option in the Allow drop-down list when setting data validation with an operator? a. Any value b. Whole number c. Between d. Decimal
c. Between
Which of the following is not true for saving a workbook as a template? a. You can save templates in any folder, but their names do not appear in the Personal category. b. Change the default folder for Personal templates in the Excel Options dialog box. c. Check the Preview box to include a preview of the template. d. When you save a workbook as an Excel template, it is saved in the Custom Office Templates folder.
c. Check the Preview box to include a preview of the template.
Which of the following keys or keyboard shortcuts moves the active cell to A1? a. Home b. Alt+Home c. Ctrl+Home d. Ctrl+A1
c. Ctrl+Home
Which of the following is a dialog box that lists the properties and data that can be removed from a workbook? a. Inspect Document command b. Check Compatibility command c. Document Inspector d. Trust Center
c. Document Inspector
Which of the following is a worksheet with an Excel table and a chart that illustrates past data and predicts future values generated from data in the worksheet? a. PivotTable b. Slicer sheet c. Forecast sheet d. Goal Seek sheet
c. Forecast sheet
What is the name of the Personal Macro workbook? a. MACRO.XLSB b. PERSONALMACRO.XLSB c. PERSONAL.XLSB d. PERSONALVBA.XLSB
c. PERSONAL.XLSB
What should you do before you begin to record a macro? a. Save the workbook. b. Copy the worksheet. c. Practice what you want to do. d. All of the above
c. Practice what you want to do.
When troubleshooting a macro, which of the following should you do if the worksheet tab is being renamed? a. Select Disable all macros with notification from the Macro Security button. b. End the current macro before running or recording another macro. c. Press Enter to complete renaming the worksheet, and then run or record a macro. d. Unprotect the workbook before running or recording a macro.
c. Press Enter to complete renaming the worksheet, and then run or record a macro.
When troubleshooting a macro, which of the following should you do if the workbook is in Edit mode? a. Select Disable all macros with notification from the Macro Security button. b. End the current macro before running or recording another macro. c. Press Enter to end Edit mode, and then run or record a macro. d. Unprotect the workbook before running or recording a macro.
c. Press Enter to end Edit mode, and then run or record a macro.
Which of the following is a combination of instructions, filters, and formats that establishes a connection to and displays data? a. DataValidation b. Forecast sheet c. Query d. Goal Seek
c. Query
Which of the following is not a pane in the VBE program? a. Code window project b. Explorer pane c. Record window d. Properties window
c. Record window
Which of the following creates a visual filter for a field in a PivotTable? a. Scenario Manager b. Solver add-in c. Slicer tool d. Query Editor
c. Slicer tool
Which of the following statements is not true about running a macro? a. Macros can be saved with keyboard shortcuts. b. If you know the shortcut, you can also run a macro by pressing its shortcut keys. c. The Macro dialog box lists the names of all macros in just the current workbook. d. After a macro is run, you can edit data as usual.
c. The Macro dialog box lists the names of all macros in just the current workbook.
Which of the following is not true when creating a forecast sheet? a. A forecast sheet uses two data series. b. The forecast sheet includes the table, forecast statistics, and the chart. c. The data or time series is not required to follow an interval. d. The generated forecast sheet is formatted as an Excel table.
c. The data or time series is not required to follow an interval.
Which of the following is not true when adding criteria to a data input form? a. Criteria can use wildcard characters. b. Criteria are not case sensitive. c. The last matching record displays in the form. d. Click a field to be used for filtering data.
c. The last matching record displays in the form.
Which of the following is a visual filter for a date field in a PivotTable? a. Text filters b. Number filters c. Timeline d. Filter by color
c. Timeline
Which of the following runs in a window that is separate from Excel? a. VB b. VBA c. VBE d. VBB
c. VBE
Where does Excel automatically save and store the Personal Macro workbook? a. START folder b. MACRO folder c. XLSTART folder d. XLMACRO folder
c. XLSTART folder
Which of the following is not true when assigning a macro to a button? a. Click the Button (Form Control) command and draw a button control. b. When the Assign Macro dialog box opens, choose a macro from any open workbook. c. You can resize a button, but you cannot move the button. d. Type a label for the button.
c. You can resize a button, but you cannot move the button.
Which of the following operators in the Add Constraints dialog box limits the value to a whole number? a. bin b. dif c. int d. dec
c. int
Which of the following are the rules applied to data as it is entered? a. error alert message b. input message c. validation settings d. form
c. validation settings
What is the maximum number of fields or columns that can be displayed in a data input form? a. 26 b. 28 c. 30 d. 32
d. 32
Which of the following statements is true about assigning a macro to a button? a. The Button form control is available from the Insert Controls button on the Developer tab. b. The Button is a form control that is used to run a macro with a single click. c. To use a Button, you assign a macro to the control. d. All of the above
d. All of the above
Which of the following statements is true about macro-enabled templates? a. An Excel macro-enabled template has an .xltm file name extension. b. An Excel macro-enabled template is automatically saved in the default templates folder for your computer. c. You can save an Excel macro-enabled template in any folder. d. All of the above
d. All of the above
Which of the following statements is true about protecting workbooks with a password? a. You can protect workbook structure with a password. b. You can protect workbook structure without a password. c. If you use a password, you must enter that password to remove the protection. d. All of the above
d. All of the above
Which of the following statements is true about recording macros? a. Once you know all the steps for your macro, you can start to record. b. When you record a macro, you actually perform the commands or type the data that will be included in the macro. c. When you are finished, you click the Stop Recording button. d. All of the above
d. All of the above
Which of the following statements is not true for the Moving Average command? a. It analyzes past results and predicts future values. b. It generates a column of averages. c. It creates a chart and list of forecast errors. d. An interval is not required.
d. An interval is not required.
Which of the following is not true for unlocking cells? a. Cells that are editable must be unlocked before setting worksheet protection. b. Use the Format button [Home tab] to toggle the Locked property on and off. c. The Locked property is also available on the Protection tab in the Format Cells dialog box. d. Cells are not locked by default.
d. Cells are not locked by default.
Which of the following statements about customizing PivotTables and PivotCharts is not true? a. You can display a timeline for date fields b. Show values as different ratios or percentages c. Create a calculated field d. Changes you make in a PivotTable do not affect the PivotChart.
d. Changes you make in a PivotTable do not affect the PivotChart.
Which of the following displays warning information yet allows users to make an entry? a. Validation message b. Stop warning c. Input message d. Information message box
d. Information message box
Which of the following calculates a series of averages for a set of values? a. Descriptive Statistics b. Rank and Percentile c. Sampling d. Moving Average
d. Moving Average
Which of the following is not a step when building a query for a database table? a. Use the Import Data dialog box. b. The Navigator window opens and lists the names of tables and queries in the database. c. Database field names are used in the header row. d. Query results do not appear on a new sheet.
d. Query results do not appear on a new sheet.
Which of the following statements is not true about recording a macro with relative references? a. Keyboard movement commands are recorded. b. If the macro starts by moving the active cell two cells down, the macro will include these commands in the code. c. Before running a macro with relative cell addresses, it does not matter where you set the active cell. d. The macro executes commands relative to the starting cell.
d. The macro executes commands relative to the starting cell.
Which of the following statements is not true about recording a macro with relative references? a. Keyboard movement commands are recorded. b. If the macro starts by moving the active cell two cells down, the macro will include these commands in the code. c. Before running a macro with relative cell addresses, it does not matter where you set the active cell. d. The macro executes commands relative to the starting cell.
d. The macro executes commands relative to the starting cell.
When troubleshooting a macro, which of the following should you do if the workbook is protected? a. Select Disable all macros with notification from the Macro Security button. b. End the current macro before running or recording another macro. c. Press Enter to end Edit mode, and then run or record a macro. d. Unprotect the workbook before running or recording a macro.
d. Unprotect the workbook before running or recording a macro.
Which of the following best describes a Trusted Location in Excel? a. a cell b. a worksheet c. a workbook d. a folder
d. a folder
What is the purpose of comments in macros? a. describe the code b. show the shortcut c. separate sections d. all of the above
d. all of the above
When using a relational operator, which of the following can you specify? a. that a value is greater than another value b. that a value is less than another value c. that a value is within a range of values d. all of the above
d. all of the above
Which of the following information is stored in a workbook's change history? a. name of the user b. the date c. a brief description of the change d. all of the above
d. all of the above
Which of the following should you be careful with when editing code? a. punctuation b. spacing c. special characters d. all of the above
d. all of the above
Which of the following types of custom calculations can you use in a PivotTable? a. a percentage b. a ranking c. a ratio d. all of the above
d. all of the above
Which of the following is not a concept in code development? a. objects b. properties and methods c. collections d. calling method
d. calling method
Which of the following concepts in code development is a group of similar objects? a. objects b. properties c. methods d. collections
d. collections
Which of the following is information used by Solver to find a solution? a. constraints b. variable cells c. objective cell d. parameter
d. parameter
