Brainscape's Knowledge GenomeTM

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


See full index

ETM 1030 > EL2 C3 C4 > Flashcards

EL2 C3 C4 Flashcards

1
Q

If you type a formula in the first record of a new table column, Excel automatically creates a(n)

A

calculated column

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

The _____ guides you through the steps of separating data into columns.

A

Convert Text to Columns wizard

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

When groups and subtotals are added to a range, Excel automatically adds a _____ at the bottom of the range.

A

grand total

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

By default, where does Excel display filter arrows in a table?

A

next to each label in the header row

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

By inserting a check mark in the First Column or Last Column check box in the Table Style Options group, you can

A

format that column differently

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

What is the first step when splitting text into multiple columns?

A

Insert a blank column(s) next to the source data

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

The Table Tools Design tab contains options for _____ the table.

A

formatting

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

Excel can compare records within a worksheet and automatically delete duplicate rows based on

A

the columns selected that might contain duplicate values

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

On the Table Tools Design tab, which of these boxes contains a check mark by default?

A

Banded Rows

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

Which of the following is not one of the three tabs at the Data Validation dialog box?

A

Add Level

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

To convert a table to a normal range, use the

A

Convert to Range button in the Tools group

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

What happens if you type new data in the row immediately below the last row of a table?

A

The table automatically adds a new row

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

Add a Total row to a table by clicking the

A

Total Row check box on the Table Tools Design tab

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

The Data Tools group on the Data tab does not contain which of the following buttons?

A

Sort & Filter

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

Which of the following is not one of the types of error messages that appears when incorrect data is entered in a cell?

A

Fatal

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

To select only specific subtotals and/or grand totals in a collapsed outline, click the Find & Select button, click the Go to Special option, click the _____ radio button to insert a bullet, and then click OK.

A

Visible cells only

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

_____ is not one of the data validation criteria available in the Allow option box at the Data Validation dialog box.

A

Fraction

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

Use the keyboard shortcut Shift + Alt + Right Arrow key to _____ data.

A

group

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

When groups and subtotals are added to a range, Excel automatically adds a _____ at the bottom of the range.

A

grand total

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

A PivotChart can be created directly from a PivotTable or from

A

the data in a worksheet

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

What are Sparklines?

A

miniature charts embedded in the background of cells

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

Which of the following areas does not appear in the layout section of the PivotTable Fields task pane?

A

Slicers

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

Slicers allow you to

A

filter without using a filter arrow

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

To change a Sparkline chart from a line to a column format, you will use tools in the _____ group.

A

Type

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

What will happen to the link to an external reference if you move the source workbook?

A

The link will not work

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

How does Chapter 4 suggest that you use Sparklines?

A

to show high or low values within a range

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

In a formula, a(n) _____ is used to separate a worksheet reference from a cell reference.

A

exclamation point (!)

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

To create a PivotChart in a worksheet without a PivotTable,

A

select the data range, click the PivotChart button arrow, and then click PivotChart

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

To permanently remove a linked reference, click the _____ button at the _____ dialog box.

A

Break Link; Edit Links

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

Insert a check mark in the Header Row check box in the Table Styles Options group to

A

show or hide the column headings in the table

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

When a table automatically expands to include new entries, the _____ displays.

A

AutoCorrect Options button

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

Before creating a subtotal for a range of related data, you must first

A

sort the data by the fields in which the records are to be grouped

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

The Table button is in the

A

Tables group on the Insert tab

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

The Stop Automatically Expanding Tables option appears when you click the _____ button.

A

AutoCorrect Options

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

What is the keyboard shortcut for adding a Total row?

A

Ctrl + Shift + T

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

What is the first step in creating a PivotTable?

A

Select the source range

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

The point-and-click method of creating a link to another workbook creates an _____ reference to the source cell.

A

absolute

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

When using a 3-D reference, it is a good idea to set up the data in each worksheet in

A

identical cells

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

When you create a PivotTable, you can select to place it in the existing worksheet or in

A

a new worksheet

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

By default, non-numeric fields are added to the _____ box of the PivotTable Field task pane, and numeric fields are added to the _____ box.

A

Rows; Values

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

Excel’s _____ feature can be used to summarize data from multiple worksheets or another workbook into a master worksheet.

A

Consolidate

42
Q

As changes are made to the PivotChart,

A

the PivotTable associated with it also updates

43
Q

The _____ function is active by default when you open the Consolidate dialog box.

A

Sum

44
Q

The Insert Slicer button is in the _____ group on the PivotTable Tools Analyze tab.

A

Filter

45
Q

What becomes visible when you activate any Sparkline cell?

A

the Sparkline Tools Design tab

46
Q

When you open a workbook with an external reference, the _____ feature is disabled and a(n) _____ is displayed.

A

automatic updates; security warning message

47
Q

Delete the dollar symbols ($) in the cell reference if the formula is to be copied and the source cell needs to be

A

relative

48
Q

What is the first step in consolidating data?

A

Make the starting cell active

49
Q

What does a Slicer pane contain?

A

all the unique values for the specified field

50
Q

A formula that refers to the same cell in a range that includes several worksheets is known as a(n)

A

3-D reference

51
Q

Creating a PivotTable allows you to do all the following except

A

delete data

52
Q

When a Total row is added to a table, which of the following does not occur?

A

The table columns are automatically banded

53
Q

Click the _____ button if you remove duplicate rows by mistake.

A

undo

54
Q

The method of formatting even-numbered rows in a table differently from odd-numbered rows is called

A

banding

55
Q

Why would you want to convert a table to a normal range?

A

to use the Subtotal feature

56
Q

The first row of an Excel table contains

A

field names

57
Q

Suppose that you have received a table containing first and last names in one column. What is the easiest way to split the names into separate columns?

A

Use the Text to Columns feature

58
Q

Which of the following is not one of the banding options available in Excel?

A

add random bands to columns

59
Q

There are no ____ within an Excel table.

A

(?)
NOT column labels

60
Q

If a cell within a table is referenced in a formula in another cell outside the table, then the _____ is included in the formula.

A

table name

61
Q

How are subtotals displayed when they have been created for a range of data at the Subtotal dialog box?

A

using the Outline feature

62
Q

At the Data Validation dialog box, choose the type of data to be validated in the _____ option box on the Settings tab.

A

Allow

63
Q

When writing a formula, how should you enter the workbook name reference?

A

enclosed in square brackets: [ ]

64
Q

To begin building a PivotTable, click the PivotTable button in the Tables group on the _____ tab.

A

Insert

65
Q

_____ Timeline pane(s) can be open at a time, but/and data can be filtered using _____.

A

More than one; one Timeline at a time

66
Q

Which of the following include the worksheet reference by default?

A

a range name

67
Q

What happens after you click the Insert Timeline button?

A

The Insert Timelines dialog box opens

68
Q

When must you include the sheet name in a formula?

A

when it references a cell in a different worksheet

69
Q

When validating or restricting data entry, _____ the added characters if a custom number format adds punctuation or text that appears in a cell.

A

ignore

70
Q

Before removing duplicate records from a table, how should you first check to see what records will be deleted?

A

Click Duplicate Values in the Highlight Cells Rules at the Conditional Formatting drop-down list

71
Q

The Use labels in section of the Consolidate dialog box contains these two options.

A

Top row and Left column

72
Q

To begin formatting a PivotTable, make active a cell inside it and then click the _____ tab.

A

PivotTable Tools Design

73
Q

How can you restore a broken link to an external resource?

A

Recreate the linked formula

74
Q

To move a PivotChart to a new sheet, use the _____ button in the Actions group.

A

Move Chart

75
Q

A table in Excel is similar in structure to a

A

database

76
Q

In Excel, a range that can be managed separately from other rows and columns in the worksheet is called a

A

table

77
Q

Which of these steps should be performed first when creating a table?

A

Select the range

78
Q

A PivotTable is a(n) _____ table that organizes and summarizes data based on fields and records.

A

interactive

79
Q

The workbook that contains the data that is linked to the destination workbook is called the _____ workbook.

A

source

80
Q

Which of these examples shows the correct syntax for a formula that links to a cell in the budget.xlsx workbook?

A

=[budget.xlsx]January!A3

81
Q

Create a PivotChart with the active cell anywhere in a PivotTable by clicking the PivotChart button in the _____ group.

A

(?)
NOT PivotTable

82
Q

When a PivotTable is filtered using a Timeline, which of the following time periods is not an option?

A

weeks

83
Q

To create a Sparkline, begin by

A

selecting the empty cell range in which to insert the Sparklines

84
Q

You can change the summary function in a PivotTable by _____ any numeric value in the PivotTable, pointing to Summarize Values By at the shortcut menu, and then clicking a function name.

A

right-clicking

85
Q

Click the _____ button to change the summary function in a PivotTable.

A

(?)
NOT Number Format
Field Settings

86
Q

Using buttons in the Group group on the Sparkline Tools Design tab, you can do each of the following except _____ Sparklines.

A

copy

87
Q

Before creating subtotals for a range of data, be sure to remove any _____ within the range to be grouped and subtotaled.

A

blank rows

88
Q

Which of the following is not one of the options in the Table Style Options group on the Table Tools Design tab?

A

(?)
NOT Filter Button

89
Q

To delete duplicate records from a table, click the Remove Duplicates button in the _____ group on the _____ tab.

A

Data Tools; Data

90
Q

When data in a worksheet is entered as a table, each row is a _____ and each column is a _____.

A

record; field

91
Q

What two options are presented at the Group dialog box?

A

Rows and Columns

92
Q

Which of the following is an example of a structured reference formula?

A

=[@[Billable Hours]]*[@Rate]

93
Q

Which two buttons are common to all three error alert message boxes?

A

Cancel and Help

94
Q

In a _____, Excel copies the formula from the first cell to the remaining cells in the column immediately after the formula is entered.

A

calculated column

95
Q

Use this keyboard shortcut to create a table.

A

CTRL + T

96
Q

What does the Text to Columns feature do?

A

It takes data from a single column and separates it into multiple columns

97
Q

To change an external reference to link to a different workbook, begin by clicking the _____ button at the _____ dialog box.

A

Change Source; Edit Links

98
Q

To select more than one item in a Slicer pane,

A

click the Multi-Select button

99
Q

To filter a PivotTable,

A

(?)
NOT right-click in the report

100
Q

Linking to a cell in another workbook incorporates _____ references and requires adding a workbook name reference to the formula.

A

external

ETM 1030 (18 decks)

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