Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

ETM 1030 > EL2 C3 C4 > Flashcards

EL2 C3 C4 Flashcards

(100 cards)

Start Studying
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
What will happen to the link to an external reference if you move the source workbook?
The link will not work
26
How does Chapter 4 suggest that you use Sparklines?
to show high or low values within a range
27
In a formula, a(n) _____ is used to separate a worksheet reference from a cell reference.
exclamation point (!)
28
To create a PivotChart in a worksheet without a PivotTable,
select the data range, click the PivotChart button arrow, and then click PivotChart
29
To permanently remove a linked reference, click the _____ button at the _____ dialog box.
Break Link; Edit Links
30
Insert a check mark in the Header Row check box in the Table Styles Options group to
show or hide the column headings in the table
31
When a table automatically expands to include new entries, the _____ displays.
AutoCorrect Options button
32
Before creating a subtotal for a range of related data, you must first
sort the data by the fields in which the records are to be grouped
33
The Table button is in the
Tables group on the Insert tab
34
The Stop Automatically Expanding Tables option appears when you click the _____ button.
AutoCorrect Options
35
What is the keyboard shortcut for adding a Total row?
Ctrl + Shift + T
36
What is the first step in creating a PivotTable?
Select the source range
37
The point-and-click method of creating a link to another workbook creates an _____ reference to the source cell.
absolute
38
When using a 3-D reference, it is a good idea to set up the data in each worksheet in
identical cells
39
When you create a PivotTable, you can select to place it in the existing worksheet or in
a new worksheet
40
By default, non-numeric fields are added to the _____ box of the PivotTable Field task pane, and numeric fields are added to the _____ box.
Rows; Values
41
Excel’s _____ feature can be used to summarize data from multiple worksheets or another workbook into a master worksheet.
Consolidate
42
As changes are made to the PivotChart,
the PivotTable associated with it also updates
43
The _____ function is active by default when you open the Consolidate dialog box.
Sum
44
The Insert Slicer button is in the _____ group on the PivotTable Tools Analyze tab.
Filter
45
What becomes visible when you activate any Sparkline cell?
the Sparkline Tools Design tab
46
When you open a workbook with an external reference, the _____ feature is disabled and a(n) _____ is displayed.
automatic updates; security warning message
47
Delete the dollar symbols ($) in the cell reference if the formula is to be copied and the source cell needs to be
relative
48
What is the first step in consolidating data?
Make the starting cell active
49
What does a Slicer pane contain?
all the unique values for the specified field
50
A formula that refers to the same cell in a range that includes several worksheets is known as a(n)
3-D reference
51
Creating a PivotTable allows you to do all the following except
delete data
52
When a Total row is added to a table, which of the following does not occur?
The table columns are automatically banded
53
Click the _____ button if you remove duplicate rows by mistake.
undo
54
The method of formatting even-numbered rows in a table differently from odd-numbered rows is called
banding
55
Why would you want to convert a table to a normal range?
to use the Subtotal feature
56
The first row of an Excel table contains
field names
57
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?
Use the Text to Columns feature
58
Which of the following is not one of the banding options available in Excel?
add random bands to columns
59
There are no ____ within an Excel table.
(?) NOT column labels
60
If a cell within a table is referenced in a formula in another cell outside the table, then the _____ is included in the formula.
table name
61
How are subtotals displayed when they have been created for a range of data at the Subtotal dialog box?
using the Outline feature
62
At the Data Validation dialog box, choose the type of data to be validated in the _____ option box on the Settings tab.
Allow
63
When writing a formula, how should you enter the workbook name reference?
enclosed in square brackets: [ ]
64
To begin building a PivotTable, click the PivotTable button in the Tables group on the _____ tab.
Insert
65
_____ Timeline pane(s) can be open at a time, but/and data can be filtered using _____.
More than one; one Timeline at a time
66
Which of the following include the worksheet reference by default?
a range name
67
What happens after you click the Insert Timeline button?
The Insert Timelines dialog box opens
68
When must you include the sheet name in a formula?
when it references a cell in a different worksheet
69
When validating or restricting data entry, _____ the added characters if a custom number format adds punctuation or text that appears in a cell.
ignore
70
Before removing duplicate records from a table, how should you first check to see what records will be deleted?
Click Duplicate Values in the Highlight Cells Rules at the Conditional Formatting drop-down list
71
The Use labels in section of the Consolidate dialog box contains these two options.
Top row and Left column
72
To begin formatting a PivotTable, make active a cell inside it and then click the _____ tab.
PivotTable Tools Design
73
How can you restore a broken link to an external resource?
Recreate the linked formula
74
To move a PivotChart to a new sheet, use the _____ button in the Actions group.
Move Chart
75
A table in Excel is similar in structure to a
database
76
In Excel, a range that can be managed separately from other rows and columns in the worksheet is called a
table
77
Which of these steps should be performed first when creating a table?
Select the range
78
A PivotTable is a(n) _____ table that organizes and summarizes data based on fields and records.
interactive
79
The workbook that contains the data that is linked to the destination workbook is called the _____ workbook.
source
80
Which of these examples shows the correct syntax for a formula that links to a cell in the budget.xlsx workbook?
=[budget.xlsx]January!A3
81
Create a PivotChart with the active cell anywhere in a PivotTable by clicking the PivotChart button in the _____ group.
(?) NOT PivotTable
82
When a PivotTable is filtered using a Timeline, which of the following time periods is not an option?
weeks
83
To create a Sparkline, begin by
selecting the empty cell range in which to insert the Sparklines
84
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.
right-clicking
85
Click the _____ button to change the summary function in a PivotTable.
(?) NOT Number Format Field Settings
86
Using buttons in the Group group on the Sparkline Tools Design tab, you can do each of the following except _____ Sparklines.
copy
87
Before creating subtotals for a range of data, be sure to remove any _____ within the range to be grouped and subtotaled.
blank rows
88
Which of the following is not one of the options in the Table Style Options group on the Table Tools Design tab?
(?) NOT Filter Button
89
To delete duplicate records from a table, click the Remove Duplicates button in the _____ group on the _____ tab.
Data Tools; Data
90
When data in a worksheet is entered as a table, each row is a _____ and each column is a _____.
record; field
91
What two options are presented at the Group dialog box?
Rows and Columns
92
Which of the following is an example of a structured reference formula?
=[@[Billable Hours]]*[@Rate]
93
Which two buttons are common to all three error alert message boxes?
Cancel and Help
94
In a _____, Excel copies the formula from the first cell to the remaining cells in the column immediately after the formula is entered.
calculated column
95
Use this keyboard shortcut to create a table.
CTRL + T
96
What does the Text to Columns feature do?
It takes data from a single column and separates it into multiple columns
97
To change an external reference to link to a different workbook, begin by clicking the _____ button at the _____ dialog box.
Change Source; Edit Links
98
To select more than one item in a Slicer pane,
click the Multi-Select button
99
To filter a PivotTable,
(?) NOT right-click in the report
100
Linking to a cell in another workbook incorporates _____ references and requires adding a workbook name reference to the formula.
external

ETM 1030 (18 decks)

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