Deck 5: Working With Excel Tables, Pivot-tables, and Pivot-charts

Question 1

When you delete a record from a table,a dialog box displays to confirm the delete operation.

Answer 1

False

Question 2

Before you complete a sort,you need to decide whether you want to put the list in ascending or descending order.

Answer 2

True

Question 3

You can format cells in a PivotTable the same way as you do cells in the worksheet.

Answer 3

True

Question 4

You can change the alignment of the column headings for better placement and readability.

Question 5

When you create a table,if your data does not contain column headers,Excel adds headers with default names.

Question 6

To show items hidden in a PivotTable,you click the Show tab and check the check box for the item you want to show.

Question 7

You click a filter arrow to open the AutoFilter menu for a field.

Question 8

Excel can summarize data in a range of data by inserting subtotals.

Question 9

You can use a table's sizing handle to add columns or rows to a table.

Question 10

You can create at most one Excel table in a worksheet.

Question 11

To rearrange records in a list,you sort based on the data in one or more of the fields.

Question 12

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.

Question 13

If a column consists of day or month labels,you can sort them in their correct chronological order using one of the predefined custom lists.

Question 14

If you freeze the top row in a worksheet and press Ctrl+Home,you will return to the cell directly above the frozen row.

Question 15

When you filter your data,all records that do not meet your criteria are temporarily hidden from view.

Question 16

When you clear a filter,all filters in the worksheet are cleared.

Question 17

The PivotTable Field List enables you to change,or pivot,the view of the data in the PivotTable by dragging the field buttons to different areas in the layout section.

Question 18

The header row must be row 1.

Question 19

Records have been filtered in the list shown in the accompanying figure.

Question 20

The simplest and most convenient way to add a record to a table is to enter the data in the first blank row below the last record.

Question 21

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.table
g.filter
b.field
h.PivotTable
c.record
i.field name
d.freeze
j.sort
e.sort field
k.custom list
f.data definition table
l.criteria filter
Documentation that lists the fields to be maintained for each record

Question 22

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.table
g.filter
b.field
h.PivotTable
c.record
i.field name
d.freeze
j.sort
e.sort field
k.custom list
f.data definition table
l.criteria filter
A collection of related fields that are grouped together

Question 23

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.table
g.filter
b.field
h.PivotTable
c.record
i.field name
d.freeze
j.sort
e.sort field
k.custom list
f.data definition table
l.criteria filter
Used to group and summarize a list into a concise,tabular format

Question 24

The fields you use to order the data in a list are sort fields._________________________

Question 25

The row of field names across the top of an Excel list is referred to as the header row._________________________

Question 26

To create a custom list,in the Sort & Filter group on the Home tab,click the Sort button.Click the Order arrow,and then click Custom List._________________________

Question 27

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.table
g.filter
b.field
h.PivotTable
c.record
i.field name
d.freeze
j.sort
e.sort field
k.custom list
f.data definition table
l.criteria filter
To keep headings visible as you work with the data in a large worksheet

Question 28

Referring to the figure above,the phrase "is greater than" is the criteria for the first condition.________________

Question 29

The QuickFix button shown in the accompanying figure enables you to undo table formatting if,for example,you had not intended new data to be part of an existing table._________________________

Question 30

Each column represents a record that describes some attribute or characteristic of a person,place,or thing._________________________

Question 31

You can calculate sort statistics (including sum,average,count,maximum,and minimum)on all the columns in an Excel table._________________________

Question 32

The first sort field in a sort is called the major sort field._________________________

Question 33

Table names cannot include underscores._________________________

Question 34

When the Subtotals feature "outlines" your worksheet,by default,the highest level is active._________________________

Question 35

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.table
g.filter
b.field
h.PivotTable
c.record
i.field name
d.freeze
j.sort
e.sort field
k.custom list
f.data definition table
l.criteria filter
A column within an Excel range

Question 36

If a column consists of day or month labels,you can sort them in their correct chronological order using one of the predefined custom lists._________________________

Question 37

Ascending order arranges labels alphabetically from A to Z._________________________

Question 38

The Summary command automatically inserts a subtotal line into the list for each group of data in the list._________________________

Question 39

You can display or hide filter arrows for an Excel table or a range of data by using the Filter button in the Sort & Filter group on the View tab._________________________

Question 40

Custom filters enable you to specify various conditions in addition to those that are based on an "equals" criterion._________________________

Question 41

Press ____ to return to cell A1 in a worksheet.

A) Ctrl+Home
B) Ctrl+Esc
C) F1
D) Alt+Esc

Question 42

A dark,horizontal line appears ____ the column headers to indicate which row is frozen.

A) above
B) below
C) both a.and b.
D) neither a.nor b.

Question 43

When you designate a range as a(n)____,Excel provides the same operations as are available for a structured range of data.

A) table
B) catalogue
C) index
D) roster

Question 44

Excel assigns the name ____ to the first Excel table created in a workbook.

A) 1
B) 1Table
C) NewTable
D) Table1

Question 45

To create a table,click the ____ tab on the Ribbon and then,in the Tables group,click the Table button.

A) Design
B) Home
C) Insert
D) View

Question 46

A data ____ table describes the fields you plan to maintain in a table.

A) structure
B) definition
C) map
D) linked

Question 47

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.table
g.filter
b.field
h.PivotTable
c.record
i.field name
d.freeze
j.sort
e.sort field
k.custom list
f.data definition table
l.criteria filter
To temporarily hide all the records that do not meet your criteria

Question 48

____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.

A) Hiding
B) Freezing
C) Showing
D) Sealing

Question 49

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.table
g.filter
b.field
h.PivotTable
c.record
i.field name
d.freeze
j.sort
e.sort field
k.custom list
f.data definition table
l.criteria filter
The field you use to order your data

Question 50

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.table
g.filter
b.field
h.PivotTable
c.record
i.field name
d.freeze
j.sort
e.sort field
k.custom list
f.data definition table
l.criteria filter
To rearrange records in a table or range based on the data in one or more fields

Question 51

A table name can include all of the following EXCEPT ____

A) numbers
B) spaces
C) underscores
D) letters

Question 52

You should ____ the field names to make it easier to Excel to distinguish between the data in the list and the field names.

A) boldface
B) change the font of
C) use a different color for
D) any of the above

Question 53

In Excel,a table is a range of related data that is managed independently from the data in other ____ in the worksheet.

A) rows and headers
B) grids and columns
C) rows and columns
D) footers and grids

Question 54

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.table
g.filter
b.field
h.PivotTable
c.record
i.field name
d.freeze
j.sort
e.sort field
k.custom list
f.data definition table
l.criteria filter
A range of related data managed independently from the data in other rows and columns in the worksheet

Question 55

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.table
g.filter
b.field
h.PivotTable
c.record
i.field name
d.freeze
j.sort
e.sort field
k.custom list
f.data definition table
l.criteria filter
Enables you to specify various conditions in addition to those that are based on an "equals" criterion

Question 56

Using Excel,you can ____.

A) store data
B) retrieve subsets of data
C) create reports
D) all of the above

Question 57

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.table
g.filter
b.field
h.PivotTable
c.record
i.field name
d.freeze
j.sort
e.sort field
k.custom list
f.data definition table
l.criteria filter
Indicates the sequence in which you want data ordered

Question 58

Which of the following is NOT a valid table name?

A) New_table
B) Table2
C) _Newtable
D) 2Table

Question 59

In Excel,a collection of similar data can be structured in a(n)____ of rows and columns.

A) index
B) glossary
C) list
D) range

Question 60

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.table
g.filter
b.field
h.PivotTable
c.record
i.field name
d.freeze
j.sort
e.sort field
k.custom list
f.data definition table
l.criteria filter
A unique label that describes the contents of data in a column

Question 61

After data is filtered,you can ____ it.

A) sort
B) chart
C) copy
D) all of the above

Question 62

As you type in a cell,____ displays any existing entry in the column that matches the characters you typed.

A) QuickFix
B) AutoComplete
C) Column Checker
D) AutoFill

Question 63

Referring to the figure above,in row 117,in the last full column shown,there is a small triangle shown in the bottom-right corner of the cell.This triangle indicates ____.

A) a frozen cell
B) a sizing handle
C) an AutoCorrect field
D) a sort field

Question 64

When you have more than one sort field,you should use the Sort ____ to specify the sort criteria.

A) menu
B) status bar
C) wizard
D) dialog box

Question 65

You can find fields whose contents match a value exactly by clicking the Options button in the Find & Replace dialog box,and checking the ____ check box.

A) Exact match
B) Match entire cell contents
C) Complete cell
D) Precise match to entire cell

Question 66

The ____ condition requires that only one of the selected criteria be true for a record to be displayed.

A) NAND
B) OR
C) AND
D) IF

Question 67

You can display or hide filter arrows for an Excel table by using the Filter button in the Sort & Filter group on the ____ tab.

A) Category
B) View
C) Data
D) Home

Question 68

You can sort by ____.

A) cell color
B) font color
C) cell icon
D) all of the above

Question 69

____ order arranges labels in reverse alphabetical order,from Z to A.

A) Reverse
B) Major
C) Ascending
D) Descending

Question 70

After you filter a column,the ____ Filter command becomes available so you can remove the filter and redisplay all the records.

A) Remove
B) Clear
C) Delete
D) Archive

Question 71

To delete a sort field in the Sort dialog box,click the ____ button.

A) Remove Level
B) Delete Level
C) Descend Level
D) Delete Field

Question 72

Referring to the figure above,the icon shown in cell B118 is the ____ button.

A) QuickCorrect
B) AutoSort
C) Quick Filter
D) AutoCorrect Options

Question 73

The fields you use to order your data are called sort ____.

A) values
B) fields
C) tags
D) tools

Question 74

You can use up to ____ sort fields in a single sort.

A) 12
B) 24
C) 32
D) 64

Question 75

Excel provides ____ predefined custom sort lists.

A) three
B) four
C) six
D) seven

Question 76

You can access the Sort buttons in the ____ group on the Home tab by clicking the Sort & Filter button and clicking a sort option.

A) Filtering
B) Formatting
C) Editing
D) Text

Question 77

After Excel displays an existing entry in the column that matches the characters you typed,press the ____ key to accept the entry.

A) Shift
B) Tab
C) Esc
D) Alt

Question 78

To add a sort field in the Sort dialog box,click the ____ button.

A) Add Level
B) Add Field
C) New Sort Field
D) New Level

Question 79

The ____ condition requires that all of the selected criteria be true for the record to be displayed.

A) OR
B) NAND
C) AND
D) IF

Question 80

In the accompanying figure,"Installation," "Sculpture," and "Textile" are all part of the list of ____ options.

A) selection
B) filtering
C) custom
D) query