Exam 2 Flashcards by Linda McNeil

You can filter the PivotTable report shown in the accompanying figure by ____.

Department and Style

How well did you know this?

Not at all

Perfectly

A ____ is an interactive view of worksheet data.

PivotTable report

How well did you know this?

Not at all

Perfectly

A ____ report is an interactive chart that allows users to change the groupings that graphically present data.

PivotChart

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

Charts with ____ are often reformatted to start the vertical axis at a number other than zero.

trendlines

How well did you know this?

Not at all

Perfectly

Excel treats ____ as graphic objects that can be moved, resized, and formatted.

slicers

How well did you know this?

Not at all

Perfectly

In PivotTables, ____ fields correspond to columns in the original data.

category

How well did you know this?

Not at all

Perfectly

In a PivotTable, ____ fields correspond to summary values of original data across categories.

data

How well did you know this?

Not at all

Perfectly

The +/- buttons ____ a field across categories.

expand and collapse

How well did you know this?

Not at all

Perfectly

The ____ summary function estimates the standard deviation of all of the data to be summarized in a PivotTable report.

StdDev

How well did you know this?

Not at all

Perfectly

The ____ value is a number from 0 to 1 that measures the strength of a trend

R-Squared

How well did you know this?

Not at all

Perfectly

The summary function that calculates the number of data values in a PivotTable report is ____.

count

How well did you know this?

Not at all

Perfectly

The summary function that calculates the smallest data value in a PivotTable report is ____.

min

How well did you know this?

Not at all

Perfectly

To change the summary functions in a PivotTable, right-click a cell, point to ____, and click a command on the submenu.

summarizes values by

How well did you know this?

Not at all

Perfectly

To create a PivotChart report directly from data, click the ____ button in the Charts group on the INSERT tab.

PivotTable

How well did you know this?

Not at all

Perfectly

Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____.

filtering

How well did you know this?

Not at all

Perfectly

When creating a PivotTable report, the active cell should be positioned ____.

anywhere in the range that contains data

How well did you know this?

Not at all

Perfectly

Which of the following is the path to the ‘Add Chart Element’ button?

(CHART TOOLS DESIGN tab | Chart Layouts group)

How well did you know this?

Not at all

Perfectly

Which of the following is the path to the ‘Insert Line Chart’ button?

(INSERT tab | Charts group)

How well did you know this?

Not at all

Perfectly

Which of the following is the path to the +/- Buttons button?

(PIVOTTABLE TOOLS ANALYZE tab | Show group)

How well did you know this?

Not at all

Perfectly

Which of the following is the path to the Field List button?

(PIVOTTABLE TOOLS ANALYZE tab | Show group)

How well did you know this?

Not at all

Perfectly

Which of the following is the path to the Move Chart button?

(CHART TOOLS DESIGN tab | Location group)

How well did you know this?

Not at all

Perfectly

Which of the following is the path to the PivotChart button?

(PIVOTTABLE TOOLS ANALYZE tab | Tools group)

How well did you know this?

Not at all

Perfectly

Which of the following is the path to the PivotTable Styles gallery More button?

(PIVOTTABLE TOOLS DESIGN tab | PivotTable Styles group)

How well did you know this?

Not at all

Perfectly

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?

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