Question 1

Excel assigns the name ____ to the first Excel table created in a workbook.
A)1
B)1Table
C)NewTable
D)Table1

Accepted Answer

Excel assigns the name "Table1" to the first Excel table created in a workbook by default.

Question 2

____ 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

Accepted Answer

Freezing rows and columns in Excel allows you to keep certain headings or labels visible on the screen as you scroll through a large dataset. This is especially helpful when working with spreadsheets that have many rows or columns and you need to keep track of what each cell represents.

Question 3

Which of the following is a valid table name?
A)%_table
B)$Table2
C)_Newtable
D)2Table

Accepted Answer

The valid characters for a table name are letters, numbers, and underscores. Table names cannot begin with a number or special character, so options A and B are not valid. Option D begins with a number, which is also not allowed. Therefore, option C, "_Newtable," is the only valid table name.

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Indicates the sequence in which you want data ordered
A)custom list
B)field
C)record
D)freeze
E)criteria filter
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Question 5

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-To keep headings visible as you work with the data in a large worksheet
A)custom list
B)field
C)record
D)freeze
E)criteria filter
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort

Accepted Answer

To keep headings visible as you work with the data in a large worksheet, you have to use the freeze option.

Possible alternative answer:
Answer: H
 Another option to keep headings visible is to create a PivotTable. However, this choice may not be the best match to the given phrase or definition.

Question 6

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Documentation that lists the fields to be maintained for each record
A)custom list
B)field
C)record
D)freeze
E)criteria filter
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort

Accepted Answer

A data definition table provides a list of fields that should be included in each record, along with any relevant information about the data type or format for each field.

(Note: None of the other choices specifically fit the definition given in the phrase)

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Used to group and summarize a list into a concise,tabular format
A)custom list
B)field
C)record
D)freeze
E)criteria filter
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort

Accepted Answer

A PivotTable is used to group and summarize a list into a concise, tabular format.

Answer: G
 A filter is used to limit the data that is displayed based on specific criteria.

Answer: J
 Sorting allows you to organize data in a list in ascending or descending order based on a specific column.

Question 8

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A column within an Excel range
A)custom list
B)field
C)record
D)freeze
E)criteria filter
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort

Accepted Answer

A column in Excel is referred to as a field. Options A, D, E, F, G, H, I, and J do not match the definition of a column within an Excel range.

Question 9

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

Accepted Answer

To create a table, we need to go to the Insert tab on the Ribbon and then in the Tables group, click the Table button.

Question 10

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

Accepted Answer

A table is a range of data that is managed independently from the data in other rows and columns in the worksheet. Grids and headers/footers are components of the worksheet, not specific ranges of data. Therefore, option C - rows and columns - is the best choice.

Question 11

____ order arranges labels in reverse alphabetical order,from Z to A.
A)Reverse
B)Major
C)Ascending
D)Descending

Accepted Answer

Descending order arranges labels from highest to lowest, including alphabetical order from Z to A.

Question 12

A table name cannot include ____.
A)numbers
B)spaces
C)underscores
D)letters

Accepted Answer

Table names cannot include spaces. It is recommended to use letters, underscores, and numbers (if necessary) in a table name.

Question 13

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Enables you to specify various conditions in addition to those that are based on an "equals" criterion
A)custom list
B)field
C)record
D)freeze
E)criteria filter
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort

Accepted Answer

A criteria filter allows you to specify criteria for filtering data, including conditions that are not based on an "equals" criterion.

(Note: Some of the other options listed, such as field, record, and sort, are also important terms in the context of data management, but they do not fit the definition provided in the question as well as criteria filter.)

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-To temporarily hide all the records that do not meet your criteria
A)custom list
B)field
C)record
D)freeze
E)criteria filter
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort

Accepted Answer

A filter is used to temporarily hide records that do not meet specified criteria.

Question 15

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A collection of related fields that are grouped together
A)custom list
B)field
C)record
D)freeze
E)criteria filter
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort

Accepted Answer

A collection of related fields that are grouped together is called a record.

Answer: F
 A data definition table is a table that defines the structure of a database, including the names of the tables and the fields within each table.

Answer: I
 A field name is a label or identifier for a particular field in a database.

Note: The other answer choices are not directly related to the definition given, or are not the best match. For example, a custom list is not a collection of related fields, and freeze, criteria filter, filter, pivot table, and sort are all specific database functions or tools, but don't necessarily refer to a group of related fields.

Question 16

A data ____ table describes the fields you plan to maintain in a table.
A)structure
B)definition
C)map
D)linked

Accepted Answer

A data definition table, also known as a data dictionary, describes the fields or attributes that will be included in a database table. It specifies the data type, length, and other characteristics of each field, and provides guidelines for how the data should be entered and manipulated. A structure or map may be used to visualize the relationships between tables, but they do not necessarily provide the same level of detail as a data definition table. A linked table refers to a table that is connected to another table through a common field.

Question 17

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

Accepted Answer

When you designate a range as a table, Excel provides the same operations as are available for a structured range of data, including sorting, filtering, and formulas.

Question 18

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-To rearrange records in a table or range based on the data in one or more fields
A)custom list
B)field
C)record
D)freeze
E)criteria filter
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort

Accepted Answer

Sorting is the process of rearranging records in a table or range based on the data in one or more fields.

Question 19

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

Accepted Answer

A range in Excel refers to a collection of cells that span across rows and columns, which can be used to organize and structure similar data.

Question 20

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A unique label that describes the contents of data in a column
A)custom list
B)field
C)record
D)freeze
E)criteria filter
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort

Accepted Answer

A field name is a unique label that describes the contents of data in a column.

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

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

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

Which of the following is a valid table name?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates the sequence in which you want data ordered

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To keep headings visible as you work with the data in a large worksheet

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Documentation that lists the fields to be maintained for each record

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Used to group and summarize a list into a concise,tabular format

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A column within an Excel range

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

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

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

A table name cannot include ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Enables you to specify various conditions in addition to those that are based on an "equals" criterion

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To temporarily hide all the records that do not meet your criteria

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A collection of related fields that are grouped together

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To rearrange records in a table or range based on the data in one or more fields

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A unique label that describes the contents of data in a column