Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ITE 140 > Exam 2 > Flashcards

Exam 2 Flashcards

1
Q

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

A

Department and Style

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

A ____ is an interactive view of worksheet data.

A

PivotTable report

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

PivotChart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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.

A

TREND

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

trendlines

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

slicers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

category

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

The +/- buttons ____ a field across categories.

A

expand and collapse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

StdDev

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

R-Squared

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

count

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

min

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

summarizes values by

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

PivotTable

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

filtering

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

anywhere in the range that contains data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

(CHART TOOLS DESIGN tab | Chart Layouts group)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

(INSERT tab | Charts group)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

A

(PIVOTTABLE TOOLS ANALYZE tab | Show group)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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

A

(PIVOTTABLE TOOLS ANALYZE tab | Show group)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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

A

(CHART TOOLS DESIGN tab | Location group)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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

A

(PIVOTTABLE TOOLS ANALYZE tab | Tools group)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

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

A

(PIVOTTABLE TOOLS DESIGN tab | PivotTable Styles group)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

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

A

(INSERT tab | Tables group)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

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

A

(PIVOTTABLE TOOLS ANALYZE tab | Data group)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

Which of the following is the path to the Report Layout button?

A

(PIVOTTABLE TOOLS DESIGN tab | Layout group)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

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?

A

slicers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

You can add a trendline to all of the following EXCEPT a(n) ____ chart.

A

pie

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

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.

A

SLICER TOOLS OPTIONS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

You can click the ____ button in the Filter group on the PivotChart Tools Analyze tab to display the Insert Slicer dialog box.

A

Insert Slicer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

You can connect ____ to more than one PivotTable to filter the data.

A

slicers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

You can display the Move Chart dialog box by clicking the Move Chart button in the Location group on the ____.

A

PIVOTCHART TOOLS DESIGN tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

____ are a visual filter used to make PivotCharts and PivotTables easier to interpret.

A

Slicers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

____ reports are visual representations of PivotTables.

A

PivotChart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

Which of the following commonly used Solver parameters sets the number of possible answer value combinations that Solver should try?

A

Iterations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

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?

A

Solver feature

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

____ is a feature of Excel that allows you to restrict access to workbooks.

A

Information Rights Management (IRM)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

A cell whose value relies on another referenced cell is said to be a(n) ____ of that referenced cell.

A

dependent

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

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.

A

Answer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

An Answer Report shows original and final values of the target cell and changing cells plus ____.

A

constraints

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

An Answer Report’s ____ column indicates binding constraints.

A

Status

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

For each model, it is helpful to define a ____ scenario that represents the starting assumptions.

A

Baseline

44
Q

Formula ____ allows you to examine formulas to determine which cells are referenced by those formulas.

A

auditing

45
Q

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.

A

arrow

46
Q

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.

A

Dependents

47
Q

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.

A

Solver

48
Q

The Goal Seek command is located on the ____ menu.

A

What-If Analysis

49
Q

The Scenario Manager command is located on the ____ menu.

A

What-If Analysis

50
Q

The Show Iteration Results check box is located in the ____ dialog box.

A

Solver Parameters

51
Q

The Trace Error button is located in the ____ dialog box.

A

Error Checking

52
Q

The ____ Window button opens a separate window that displays values and formulas for specific cells that you choose to monitor.

A

Watch

53
Q

The ____ allows you to monitor the values and formulas in cells as you work on a worksheet.

A

Watch Window

54
Q

The ____ feature is especially useful when working with very large worksheets.

A

outline

55
Q

The ____ should be used before sharing a workbook publicly.

A

Document Inspector

56
Q

The ____ worksheet generated by the Scenario Manager actually is a worksheet in outline format.

A

Scenario Summary

57
Q

To check for invalid data entered as the result of a formula or automated tools such as Goal Seek, use the ‘____’ command.

A

Circle Invalid Data

58
Q

When a cell contains a(n) ____ reference, it means that one of its defining values is itself.

A

Circular

59
Q

Which of the following is NOT a type of data validation criteria you can assign to a cell?

A

Bold Style Formatting

60
Q

Which of the following is NOT an issue that must be kept in mind when using Solver?

A

Constraint precision is incompatible with most forms of automatic scaling.

61
Q

Which of the following is not a primary use of the Scenario Manager?

A

Find a scenario-style solution to a complex problem by changing a single variable

62
Q

Which of the following is not a valid consideration when creating scenarios?

A

Exclude cells that are input cells for your model

63
Q

Which of the following is the path to the ‘Remove All Arrows’ arrow?

A

FORMULAS tab | Formula Auditing group)

64
Q

Which of the following is the path to the ‘What-If Analysis’ button?

A

(DATA tab | Data Tools group)

65
Q

Which of the following is the path to the Data Validation button?

A

(DATA tab | Data Tools group)

66
Q

Which of the following is the path to the Error Checking button?

A

(FORMULAS tab | Formula Auditing group)

67
Q

Which of the following is the path to the Trace Precedents button?

A

(FORMULAS tab | Formula Auditing group)

68
Q

Which of the following is the path to the Watch Window button? (FORMULAS tab | Formula Auditing group)

A

(FORMULAS tab | Formula Auditing group)

69
Q

You can prepare a workbook for sharing by clicking the ____ tab in Backstage view.

A

Info

70
Q

___ are named combinations of values that are assigned to variables in a model.

A

Scenarios

71
Q

The ____ shown in the accompanying figure is used by all Office applications to enter, modify, and view Visual Basic for Applications code.

A

Visual Basic Editor

72
Q

A ____ ensures that users cannot unprotect a worksheet simply by clicking the Unprotect button.

A

password

73
Q

A ____ is an attachment to a file or email message that vouches for its authenticity.

A

digital certificate

74
Q

A ____ is created by performing a set of steps and recording the steps as they are performed.

A

macro

75
Q

A computer ____ is a potentially damaging computer program designed to affect your computer negatively by altering the way it works.

A

virus

76
Q

A macro name can be up to ____ characters long.

A

255

77
Q

A series of precise instructions for a computer to accomplish a task is called a ____.

A

procedure

78
Q

An Excel ____ is a procedure composed of VBA code.

A

macro

79
Q

Comments can be placed at any of the following positions EXCEPT ____.

A

Before the supplement statement

80
Q

Each ActiveX control available in the Controls gallery has many ____.

A

properties

81
Q

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.

A

Use Relative Reference

82
Q

In which of the following modes can you set the properties that determine a control’s appearance and behavior?

A

Design

83
Q

It is good practice to place comments containing overall documentation and information before the ____ statement.

A

Sub

84
Q

Macros are known carriers of ____ because of the ease with which a person can add programming code to them.

A

viruses

85
Q

Pressing ____ displays formulas in worksheet cells.

A

CTRL+ACCENT MARK (`)

86
Q

Signed macros based on your own digital certificate are called ____.

A

self-signed projects

87
Q

The Protect Sheet button is located on the ____ tab.

A

review

88
Q

Use macros to ensure consistency in all of the following EXCEPT ____.

A

variables

89
Q

When you work with a ____ created by someone else, you should review its content and structure before you make changes to it.

A

workbook

90
Q

Which of the following commands can you use to replace a formula with a text value?

A

paste values

91
Q

Which of the following functions can you use to convert names entered in all uppercase to mixed case?

A

Proper

92
Q

Which of the following functions can you use to determine the position of the space that separates a first and last name?

A

SEARCH

93
Q

Which of the following is the default security option for workbooks containing macros?

A

Disable macro with notification

94
Q

Which of the following is the path to the Macro Security button?

A

(DEVELOPER tab | Code group)

95
Q

Which of the following is the path to the Record Macro button?

A

(DEVELOPER tab | Code group)

96
Q

Which of the following is the path to the Unprotect Sheet button?

A

(REVIEW tab | Changes group)

97
Q

You can add the DEVELOPER tab to the Ribbon with options in the ____ dialog box.

A

Excel Options

98
Q

You can delete a control by pressing and holding or right-clicking the control and selecting ____ on the shortcut menu.

A

cut

99
Q

You can enable or disable macros with options in the ____ dialog box.

A

Trust Center

100
Q

You can open the Properties window by tapping or clicking the Control Properties button ____ in Design mode.

A

(DEVELOPER tab | Controls group)

101
Q

You can open the VBE Immediate window to debug and execute statements during design by pressing ____.

A

CTRL+G

102
Q

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.

A

Excel Options

103
Q

You can use the ____ form control to position a set of option buttons together.

A

Group Box

104
Q

You can use the options in the ____ dialog box to apply colors and patterns to make controls stand out more.

A

Format Object

105
Q

You should test code before you enter it by stepping through the instructions one at a time in a process called ____ checking.

A

desk

106
Q

____ code is created automatically by the macro recorder.

A

VBA

ITE 140 (5 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions