Spreadsheet Software Final

Front 1

A ________ can be used to combine or separate data, change case, and apply formatting to a string of characters.

Back 1

text function

Front 2

A ________ is an XML file that contains the rules for what can and cannot reside in an XML data file.

Back 2

schema

Front 3

A screenshot is a(n) ________ of an active window on your computer that you can insert in your worksheet.

Back 3

image

Front 4

A(n) ________ is a means of finding the records that answer a particular question about the data.

Back 4

query

Front 5

All open windows display in the Available Windows gallery and are available to insert a(n) ________ into your worksheet.

Back 5

screenshot

Front 6

[Ctrl] + [F12] is a shortcut to display the ________ dialog box.

Back 6

Open

Front 7

Custom headers and footers provide ________ sections where you can type your own text or insert header and footer elements.

Back 7

three

Front 8

Functions are predefined formulas that perform calculations by using specific values, called:

Back 8

arguments

Front 9

Having two tables side-by-side in the same worksheet, you can ________ similar sets of data to make comparisons.

Back 9

sort

Front 10

Header & Footer Elements do NOT include which of the following?

Back 10

Workbook Name

Front 11

If a worksheet is slightly wider and taller than the normal margins, use ________ to keep all the information on one page.

Back 11

Scale to Fit

Front 12

In Excel, you can create simple ________, which are collections of data related to a particular topic or purpose.

Back 12

databases

Front 13

In a database, a(n) ________ is a vertical column that stores information that describes a record.

Back 13

field

Front 14

Information that is stored in rows and columns is referred to as a(n):

Back 14

table

Front 15

Records are always displayed in:

Back 15

rows

Front 16

Screenshots are especially useful when you want to insert an image of a(n) ________ into an Excel worksheet.

Back 16

website

Front 17

The Convert to Range command that will convert a table of imported date into a range, is located under Table Tools on the DESIGN tab in the ________ group.

Back 17

Tools

Front 18

The Screenshot button is located in the ________ group on the INSERT tab.

Back 18

Illustrations

Front 19

The ________ function extracts a series of characters from a text string given the location of the beginning character.

Back 19

MID

Front 20

The criteria range for the DAVERAGE function must consist of at least ________ vertical cell(s).

Back 20

two

Front 21

The letter D at the beginning of a function is identification in Excel that a ________ range will be used in the formula.

Back 21

database

Front 22

To bring data from other sources into Excel you ________ the data.

Back 22

imprint

Front 23

To center a page horizontally, use the Margins tab in the ________ dialog box.

Back 23

Page Setup

Front 24

To create a query, first choose the ________ and then indicate the fields you want to include in the query result.

Back 24

data source

Front 25

To display records that meet one or more specific conditions, you must use ________ to limit the data.

Back 25

filters

Front 26

To import information into Excel from a web page, you must first open the page with:

Back 26

an Internet browser.

Front 27

To make sorting and filtering easier, you can separate data into separate fields using:

Back 27

Flash Fill.

Front 28

To open the Create Table dialog box, click on the Table button in the Tables group on the ________ tab.

Back 28

INSERT

Front 29

To print all the worksheets in a workbook at the same time, you can either ________ the worksheets, or under Print Settings, select Print Entire Workbook.

Back 29

group

Front 30

To sort data in an Excel worksheet, you must first ________ the range to a table.

Back 30

convert

Front 31

When you click ________, a Microsoft Excel information box displays indicating that this will permanently remove the query definition from the sheet and convert the table to a normal range.

Back 31

Convert to Range

Front 32

When you convert a data range into a table, a table style is applied and the headings display ________ arrows.

Back 32

filter

Front 33

Which of the following statements is NOT true about side-by-side tables?

Back 33

Side-by-side tables must have the same number of rows and columns.

Front 34

Which of the following is NOT an argument in the majority of database functions?

Back 34

Dialog

Front 35

When you click the ________ button, the filter arrows are removed from the column titles but the color and shading formats applied from the table style remain.

Back 35

Convert to Range

Front 36

With conditional formatting, icons that make your data easier to interpret are placed ________ the cells.

Back 36

inside

Front 37

With conditional formatting, the shape or color of icons indicates the ________ in the cells relative to all other adjacent cells formatted using the same condition.

Back 37

values

Front 38

You use the commands in the ________ group on the DATA tab to bring data from outside Excel into an Excel worksheet.

Back 38

Get External Data

Front 39

________ are sets of three, four, or five small graphic images that make your data visually easier to interpret.

Back 39

Icon sets

Front 40

________ make(s) data easier to interpret by changing the data's appearance based on value.

Back 40

Conditional formatting

Front 41

A collection of VBA declarations, statements, and procedures stored together as one named unit is known as a:

Back 41

module

Front 42

A function key or key combination, such as F5 or CTRL + r that is used to carry out a menu command is called a:

Back 42

shortcut key.

Front 43

A module consists of ________, which are units of computer code that perform some type of action.

Back 43

procedures

Front 44

A named sequence of statements that performs a task is called a(n):

Back 44

procedure

Front 45

A unit of computer code that performs an action is called a(n):

Back 45

procedure

Front 46

ActiveX controls are found under which of the following tabs?

Back 46

DEVELOPER

Front 47

An ActiveX control is a(n) ________, such as a check box or button that is placed on a form to display or enter data, perform an action, or make a form easier to read.

Back 47

graphic object

Front 48

An electronic, encryption-based, secure stamp of authentication on a macro or document is called a:

Back 48

digital signature.

Front 49

An instruction that enables a macro to perform multiple operations on a single object is called a VBA:

Back 49

construct

Front 50

Any macro setting changes made in Excel in the Macro Settings category apply to:

Back 50

Excel only.

Front 51

By using a digital signature, you confirm that the document or macro originated from the signer and has not been:

Back 51

altered

Front 52

Common uses of ActiveX controls are:

Back 52

Command buttons, lists, and dialog boxes.

Front 53

For a macro shortcut key, which of the following is used before the letter?

Back 53

CTR

Front 54

If you share macros with others, you can certify them with a:

Back 54

digital signature.

Front 55

Macros are recorded in ________ language, which is used to write computer programs within the Microsoft Windows environment.

Back 55

Visual Basic for Applications

Front 56

On the Categorized tab, the same properties are listed, but they are organized by ________ groups.

Back 56

Logical

Front 57

The Debug button will return you to the MS VBE Editor window, and the line of code that contains the error will be highlighted in which of the following colors?

Back 57

Yellow

Front 58

The ________ is a location where you can store macros that you want to be able to use in other workbooks.

Back 58

Personal Macro Workbook

Front 59

The action that causes your macro to run is called a(n):

Back 59

event

Front 60

The macro recorder records all the steps required to complete the actions you want your macro to perform - except navigation on the:

Back 60

ribbon

Front 61

The word With denotes the beginning of a ________, an instruction that enables the macro to perform multiple operation on a single object.

Back 61

VBA construct

Front 62

To add a button to the Quick Access Toolbar, you must first go to the:

Back 62

Backstage view.

Front 63

To approve or block files containing macros, your macro security level should be set to:

Back 63

Disable all macros with notification.

Front 64

To be sure that a VBA procedure works as intended, you should verify it by which of the following?

Back 64

Testing the code

Front 65

To create an electronic version of your VBA code window, press the:

Back 65

PrintScreen key.

Front 66

To edit and check VBA code, you would click on View Code from the:

Back 66

Controls group.

Front 67

To enable macros in Excel, you must set the security level on the:

Back 67

DEVELOPER tab.

Front 68

To ensure that a macro works as expected after the macro has been created and assigned a button or menu item, it should be:

Back 68

tested

Front 69

To make it easier to read in the Code window, starting and editing statements are formatted to be:

Back 69

aligned left.

Front 70

To run a macro, you can assign it to an object, such as a:

Back 70

toolbar button, graphic, or control.

Front 71

To work with a macro, which of the following must be done first?

Back 71

Add the DEVELOPER tab to the ribbon

Front 72

Unauthorized macro code is called a:

Back 72

macro virus.

Front 73

When coding in VBA, comments are preceded by a(n):

Back 73

single quote.

Front 74

When naming a macro, the first character of the macro name must be a(n):

Back 74

letter.

Front 75

When recording a macro, the Record Macro command stores the macro in a(n):

Back 75

module

Front 76

When referring to an object in a program, use the ________ field.

Back 76

Name

Front 77

When you add ActiveX controls to your worksheet, you are working in which of the following modes?

Back 77

Design Mode

Front 78

When you assign a shortcut key to a macro, it will take precedence over the shortcut keys that are:

Back 78

built into Excel.

Front 79

Within VBA, you can write a procedure into your form that will insert a(n):

Back 79

ActiveX control.

Front 80

You can activate a macro by adding a button to the:

Back 80

Quick Access Toolbar.

Front 81

A PivotChart displays ________ that you can click to choose a filter and change the data displayed in the chart.

Back 81

field buttons

Front 82

A PivotTable report ________ large amounts of data so you can analyze related totals.

Back 82

combines and compares

Front 83

A ________ can import data from an Excel workbook, from an Access database, or from an external source such as a corporate database, a public data feed, or an analysis service.

Back 83

Data Model

Front 84

A ________ is a method of incorporating data from multiple, related tables into an Excel worksheet.

Back 84

Data Model

Front 85

A field that is being removed from the PivotTable report is indicated by a(n):

Back 85

X

Front 86

An object such as a chart or map on a PowerView sheet is a:

Back 86

data visualization.

Front 87

An optional command or feature that is not immediately available and must be installed and/or activated use is a(n):

Back 87

Add-in.Add-in.

Front 88

By default, when a non-numeric field is added to a PivotTable, it is placed in the ________ area.

Back 88

Row Labels

Front 89

By using a PivotTable Report, you can show the same data in a table in:

Back 89

more than one arrangement.

Front 90

Excel includes several ________ that can be used to perform data analysis and create sophisticated charts and reports.

Back 90

Business Intelligence tools

Front 91

Excel uses the column titles as the ________ for the categories of data.

Back 91

field names

Front 92

If you change the underlying data on which a PivotTable report is based, you must also ________ or update the PivotTable to reflect the new data.

Back 92

refresh

Front 93

In PivotTable Field List, you can rearrange existing fields or reposition fields by using which of the following areas at the bottom of the layout section?

Back 93

Row Labels

Front 94

In a PivotTable or PivotChart report, data is derived from a ________ in the source data.

Back 94

field

Front 95

In the PivotTable field list, you can rearrange existing fields or reposition those fields by using which of the following areas at the bottom of the layout section?

Back 95

Column Labels

Front 96

PowerView can use the ________ map service to generate a map if your data contains location information.

Back 96

Bing

Front 97

Preformatted PivotTables that are arranged in a gallery are called:

Back 97

PivotTable Styles.

Front 98

The ________ tool allows you to drill down through PivotTable data with a single click.

Back 98

Quick Explore

Front 99

The category of slicer items is indicated by the:

Back 99

slicer header.

Front 100

The charts and other objects created on a ________ worksheet are related and can be cross-filtered.

Back 100

PowerView

Front 101

The default summary function for a data fields containing numbers in an Excel PivotTable is:

Back 101

Sum

Front 102

The part of a PowerView worksheet where the data visualization displays is the:

Back 102

PowerView canvas.

Front 103

To create a column chart visualization on a PowerView sheet, first drag the fields to the FIELDS are, and then click the Column Chart arrow in the ________ group.

Back 103

Switch Visualization

Front 104

To format the elements of a PowerView object, select the object and then click the ________ tab.

Back 104

LAYOUT

Front 105

To make changes to PivotTable data, you must:

Back 105

edit cells in the source list and then refresh the PivotTable.

Front 106

When a numeric field is added to a PivotTable, it is placed in the ________ area of the PivotTable field list.

Back 106

Values

Front 107

When creating a PowerView sheet, multiple tables are visible in the:

Back 107

PowerView Fields pane.

Front 108

Which of the following is an interactive Excel report that summarizes and analyzes data, such as database records from various sources, including those that are external to Excel?

Back 108

PivotTable report

Front 109

Which of the following is a report that provides interactive analysis of data, where you can change views of data, see different levels of detail, or reorganize the chart layout by dragging fields and showing or hiding items in fields?

Back 109

PivotTable report

Front 110

Which of the following is a bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a worksheet cell?

Back 110

Data markers

Front 111

Which of the following is a button that identifies a field in a PivotTable or PivotChart report?

Back 111

Field button

Front 112

Which of the following is data that is stored outside of Excel and includes databases created in Access, dBase, SQL Server or on a Web server?

Back 112

External data

Front 113

Which of the following is the method of summarizing values in the data area of a PivotTable report by using the values other cells in the data area?

Back 113

Summary calculation

Front 114

Which of the following areas of a PivotTable field list allows you to display average values?

Back 114

Values

Front 115

With ________ you can analyze data from multiple sources, work with multiple data tables, and create relationships between tables.

Back 115

PowerPivot

Front 116

You can apply a ________ to the entire PivotTable report.

Back 116

PivotTable Style

Front 117

You can limit the display of data to specific information by using:

Back 117

filters

Front 118

You must use ________ to create PivotTables using the data from multiple, related tables.

Back 118

PowerPivot

Front 119

________ is a data visualization tool that can be used to create interactive dashboards and reports.

Back 119

PowerView

Front 120

________ allows you to create and interact with multiple charts, slicers and other data visualizations in a single sheet.

Back 120

PowerView

Front 121

A ________ is a visual representation of information and ideas that you can create by choosing from among many different layouts to communicate your message easily and effectively.

Back 121

SmartArt graphic

Front 122

A group of related data plotted in a chart is called a:

Back 122

data series.

Front 123

All cells are locked by default, but the locking feature is only enabled when ________ is applied.

Back 123

protection

Front 124

By default, Excel displays a chart as a(n) ________ object within the worksheet.

Back 124

embedded

Front 125

Charts can be placed on a separate sheet called a:

Back 125

chart sheet.

Front 126

Column charts present data graphically in ________ columns.

Back 126

vertical

Front 127

Effects can be added to SmartArt diagrams from the ________ tab.

Back 127

FORMAT

Front 128

If the Select locked cells option is selected in the Protect Sheet dialog box, the user can click the locked cells and ________ the formulas.

Back 128

view

Front 129

If there is only one line in a line chart, you should delete the:

Back 129

legend.

Front 130

If you try to enter data in a protected cell, a message appears informing you that the cell is protected and therefore:

Back 130

read-only.

Front 131

If you want all of the forms within an organization to have a uniform appearance and the data organized in the same way, you should use:

Back 131

standardization

Front 132

Objects that make up a chart are called:

Back 132

chart elements.

Front 133

Templates are commonly used to provide ________ of data.

Back 133

standardization and protection

Front 134

Sparklines are:

Back 134

tiny charts that fit within a cell.

Front 135

Templates can have built-in ________ for performing calculations based on the data you enter.

Back 135

formulas

Front 136

The SmartArt organization chart is in the ________ category.

Back 136

Hierarchy

Front 137

The Text Pane displays to the ________ of the SmartArt diagram.

Back 137

left

Front 138

The Text Pane includes ________ in which text can be typed.

Back 138

placeholders

Front 139

The ________ is the range of numbers in the data series that controls the minimum, maximum, and incremental values on the value axis.

Back 139

scale

Front 140

The entire chart with all of its elements is called the:

Back 140

chart area.

Front 141

The key that defines the colors assigned to categories in a chart is called a(n):

Back 141

legend

Front 142

To add a shape to a lower level of an organization chart, click Add Shape, and then click:

Back 142

Add Shape Below.

Front 143

To create a column chart, you must first select the ________ data to be plotted.

Back 143

labels

Front 144

To create a form for others to complete, you should first ________ the cells that will need to be filled in and then protect the workbook.

Back 144

unlock

Front 145

To delete a box from a SmartArt organization chart, you must display a ________ border.

Back 145

solid line

Front 146

To display trends over time, use a ________ chart.

Back 146

line

Front 147

To enhance the appearance of sparklines, use:

Back 147

styles

Front 148

To help choose the best type of chart for your data, use:

Back 148

styles

Front 149

To make comparisons among related data, use a ________ chart.

Back 149

column

Front 150

To prevent others from changing the formulas and formatting of a worksheet, you should use:

Back 150

protection

Front 151

When a template is opened from Windows File Explorer, it is opened as a(n):

Back 151

Excel Workbook (*.xlsx)

Front 152

When a template is opened from the New tab in the Backstage view, it is opened as a(n):

Back 152

workbook

Front 153

When selecting the range for a line chart, you may need to include a(n) ________ to have the same number of cells in each row.

Back 153

empty cell

Front 154

When you create a chart, Excel uses the column and row headings that describe the values as ________ for the data.

Back 154

labels

Front 155

When you create a chart, you must first decide if you are going to plot values representing:

Back 155

totals OR details.

Front 156

When you protect a worksheet, you may add an optional ________ to prevent someone from disabling the worksheet protection.

Back 156

password

Front 157

When you save a template on your own computer to the template folder, it will be available for future use from:

Back 157

My templates.

Front 158

Which of the following SmartArt graphic categories would be used to show a timeline?

Back 158

Process

Front 159

Which of the following is NOT a type of sparkline?

Back 159

Trend

Front 160

________ prevents anyone from changing a workbook.

Back 160

Protection