Exam 2 Flashcards
You can filter the PivotTable report shown in the accompanying figure by ____.
Department and Style
A ____ is an interactive view of worksheet data.
PivotTable report
A ____ report is an interactive chart that allows users to change the groupings that graphically present data.
PivotChart
A(n) ____ is most often thought about in terms of how a value changes over time, but can also describe the relationship between two variables.
TREND
Charts with ____ are often reformatted to start the vertical axis at a number other than zero.
trendlines
Excel treats ____ as graphic objects that can be moved, resized, and formatted.
slicers
In PivotTables, ____ fields correspond to columns in the original data.
category
In a PivotTable, ____ fields correspond to summary values of original data across categories.
data
The +/- buttons ____ a field across categories.
expand and collapse
The ____ summary function estimates the standard deviation of all of the data to be summarized in a PivotTable report.
StdDev
The ____ value is a number from 0 to 1 that measures the strength of a trend
R-Squared
The summary function that calculates the number of data values in a PivotTable report is ____.
count
The summary function that calculates the smallest data value in a PivotTable report is ____.
min
To change the summary functions in a PivotTable, right-click a cell, point to ____, and click a command on the submenu.
summarizes values by
To create a PivotChart report directly from data, click the ____ button in the Charts group on the INSERT tab.
PivotTable
Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____.
filtering
When creating a PivotTable report, the active cell should be positioned ____.
anywhere in the range that contains data
Which of the following is the path to the ‘Add Chart Element’ button?
(CHART TOOLS DESIGN tab | Chart Layouts group)
Which of the following is the path to the ‘Insert Line Chart’ button?
(INSERT tab | Charts group)
Which of the following is the path to the +/- Buttons button?
(PIVOTTABLE TOOLS ANALYZE tab | Show group)
Which of the following is the path to the Field List button?
(PIVOTTABLE TOOLS ANALYZE tab | Show group)
Which of the following is the path to the Move Chart button?
(CHART TOOLS DESIGN tab | Location group)
Which of the following is the path to the PivotChart button?
(PIVOTTABLE TOOLS ANALYZE tab | Tools group)
Which of the following is the path to the PivotTable Styles gallery More button?
(PIVOTTABLE TOOLS DESIGN tab | PivotTable Styles group)
Which of the following is the path to the PivotTable button?
(INSERT tab | Tables group)
Which of the following is the path to the Refresh button?
(PIVOTTABLE TOOLS ANALYZE tab | Data group)
Which of the following is the path to the Report Layout button?
(PIVOTTABLE TOOLS DESIGN tab | Layout group)
With which of the following are any selected subgroups immediately identifiable, and able to be changed with the tap or click of a button or buttons?
slicers
You can add a trendline to all of the following EXCEPT a(n) ____ chart.
pie
You can change the height of a slicer by clicking the Height text box in the Buttons group on the ____ tab and then entering the desired height.
SLICER TOOLS OPTIONS
You can click the ____ button in the Filter group on the PivotChart Tools Analyze tab to display the Insert Slicer dialog box.
Insert Slicer
You can connect ____ to more than one PivotTable to filter the data.
slicers
You can display the Move Chart dialog box by clicking the Move Chart button in the Location group on the ____.
PIVOTCHART TOOLS DESIGN tab
____ are a visual filter used to make PivotCharts and PivotTables easier to interpret.
Slicers
____ reports are visual representations of PivotTables.
PivotChart
Which of the following commonly used Solver parameters sets the number of possible answer value combinations that Solver should try?
Iterations
Which of the following complex problem solving methods, features, or options allows you to provide Excel with all of the known rules of your problem as well as the goal you are seeking, and then attempts as many different solutions to the problem as possible?
Solver feature
____ is a feature of Excel that allows you to restrict access to workbooks.
Information Rights Management (IRM)
A cell whose value relies on another referenced cell is said to be a(n) ____ of that referenced cell.
dependent
A(n) ____ Report shows the answer that Solver found, which constraints were in place, and which values in the worksheet Solver manipulated in order to solve the problem within those constraints.
Answer
An Answer Report shows original and final values of the target cell and changing cells plus ____.
constraints
An Answer Report’s ____ column indicates binding constraints.
Status
For each model, it is helpful to define a ____ scenario that represents the starting assumptions.
Baseline
Formula ____ allows you to examine formulas to determine which cells are referenced by those formulas.
auditing
Formula auditing tools include a tracer ____, which is drawn from a cell that appears in a formula in another cell or from a cell that contains a formula with cell references.
arrow
Identifying ____ highlights where changes will occur in the worksheet as a result of changing the value in the cell you are identifying as a referenced cell.
Dependents
One of the tools that Excel provides to solve complex problems is ____, which allows you to specify up to 200 cells that can be adjusted to find a solution to a problem.
Solver
The Goal Seek command is located on the ____ menu.
What-If Analysis
The Scenario Manager command is located on the ____ menu.
What-If Analysis
The Show Iteration Results check box is located in the ____ dialog box.
Solver Parameters
The Trace Error button is located in the ____ dialog box.
Error Checking
The ____ Window button opens a separate window that displays values and formulas for specific cells that you choose to monitor.
Watch
The ____ allows you to monitor the values and formulas in cells as you work on a worksheet.
Watch Window
The ____ feature is especially useful when working with very large worksheets.
outline
The ____ should be used before sharing a workbook publicly.
Document Inspector
The ____ worksheet generated by the Scenario Manager actually is a worksheet in outline format.
Scenario Summary
To check for invalid data entered as the result of a formula or automated tools such as Goal Seek, use the ‘____’ command.
Circle Invalid Data
When a cell contains a(n) ____ reference, it means that one of its defining values is itself.
Circular
Which of the following is NOT a type of data validation criteria you can assign to a cell?
Bold Style Formatting
Which of the following is NOT an issue that must be kept in mind when using Solver?
Constraint precision is incompatible with most forms of automatic scaling.
Which of the following is not a primary use of the Scenario Manager?
Find a scenario-style solution to a complex problem by changing a single variable
Which of the following is not a valid consideration when creating scenarios?
Exclude cells that are input cells for your model
Which of the following is the path to the ‘Remove All Arrows’ arrow?
FORMULAS tab | Formula Auditing group)
Which of the following is the path to the ‘What-If Analysis’ button?
(DATA tab | Data Tools group)
Which of the following is the path to the Data Validation button?
(DATA tab | Data Tools group)
Which of the following is the path to the Error Checking button?
(FORMULAS tab | Formula Auditing group)
Which of the following is the path to the Trace Precedents button?
(FORMULAS tab | Formula Auditing group)
Which of the following is the path to the Watch Window button? (FORMULAS tab | Formula Auditing group)
(FORMULAS tab | Formula Auditing group)
You can prepare a workbook for sharing by clicking the ____ tab in Backstage view.
Info
___ are named combinations of values that are assigned to variables in a model.
Scenarios
The ____ shown in the accompanying figure is used by all Office applications to enter, modify, and view Visual Basic for Applications code.
Visual Basic Editor
A ____ ensures that users cannot unprotect a worksheet simply by clicking the Unprotect button.
password
A ____ is an attachment to a file or email message that vouches for its authenticity.
digital certificate
A ____ is created by performing a set of steps and recording the steps as they are performed.
macro
A computer ____ is a potentially damaging computer program designed to affect your computer negatively by altering the way it works.
virus
A macro name can be up to ____ characters long.
255
A series of precise instructions for a computer to accomplish a task is called a ____.
procedure
An Excel ____ is a procedure composed of VBA code.
macro
Comments can be placed at any of the following positions EXCEPT ____.
Before the supplement statement
Each ActiveX control available in the Controls gallery has many ____.
properties
If you will be using keyboard navigation when creating a macro, you must ensure that the ‘____’ button in the Code group on the DEVELOPER tab is selected so that the macro works properly.
Use Relative Reference
In which of the following modes can you set the properties that determine a control’s appearance and behavior?
Design
It is good practice to place comments containing overall documentation and information before the ____ statement.
Sub
Macros are known carriers of ____ because of the ease with which a person can add programming code to them.
viruses
Pressing ____ displays formulas in worksheet cells.
CTRL+ACCENT MARK (`)
Signed macros based on your own digital certificate are called ____.
self-signed projects
The Protect Sheet button is located on the ____ tab.
review
Use macros to ensure consistency in all of the following EXCEPT ____.
variables
When you work with a ____ created by someone else, you should review its content and structure before you make changes to it.
workbook
Which of the following commands can you use to replace a formula with a text value?
paste values
Which of the following functions can you use to convert names entered in all uppercase to mixed case?
Proper
Which of the following functions can you use to determine the position of the space that separates a first and last name?
SEARCH
Which of the following is the default security option for workbooks containing macros?
Disable macro with notification
Which of the following is the path to the Macro Security button?
(DEVELOPER tab | Code group)
Which of the following is the path to the Record Macro button?
(DEVELOPER tab | Code group)
Which of the following is the path to the Unprotect Sheet button?
(REVIEW tab | Changes group)
You can add the DEVELOPER tab to the Ribbon with options in the ____ dialog box.
Excel Options
You can delete a control by pressing and holding or right-clicking the control and selecting ____ on the shortcut menu.
cut
You can enable or disable macros with options in the ____ dialog box.
Trust Center
You can open the Properties window by tapping or clicking the Control Properties button ____ in Design mode.
(DEVELOPER tab | Controls group)
You can open the VBE Immediate window to debug and execute statements during design by pressing ____.
CTRL+G
You can reset the Quick Access Toolbar to its installation default by tapping or clicking the Reset button in the Customize Quick Access Toolbar options in the ____ dialog box.
Excel Options
You can use the ____ form control to position a set of option buttons together.
Group Box
You can use the options in the ____ dialog box to apply colors and patterns to make controls stand out more.
Format Object
You should test code before you enter it by stepping through the instructions one at a time in a process called ____ checking.
desk
____ code is created automatically by the macro recorder.
VBA