Question 1

Press ____ to return to cell A1 in a worksheet.

Accepted Answer

Ctrl+Home takes you to the first cell in the worksheet, which is A1.

Question 2

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

Accepted Answer

The answer of A dark,horizontal line appears ____ the column...

Question 3

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

Accepted Answer

Excel provides the same operations as are available for a structured range of data when a range is designated as a table. Catalogue, index, and roster do not have specific meanings or functions within Excel.

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

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

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 7

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

Accepted Answer

The term "filter" is used in Excel to refer to the process of temporarily hiding records that do not meet certain criteria. This can be done using the Filter command in the Data tab.

Question 8

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

Accepted Answer

Freezing rows and columns allows you to keep headers on the screen as you scroll through a large worksheet. This is particularly useful when working with a lot of data, as it helps you keep track of what information you are looking at. Hiding, showing, and sealing do not provide this functionality.

Question 9

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-The field you use to order your data

Accepted Answer

A sort field is the field used to order or sort the data within a table or database.

Answer: I
 Field name refers to the name given to a specific field or column of data within a table or database.

Answer: K
 A custom list allows the user to define a specific order or sequence for data within a column or field.

Note: While the other options listed may also be used in the context of organizing and managing data, they do not directly relate to the field used for ordering data.

Question 10

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

Accepted Answer

"To rearrange records in a table or range based on the data in one or more fields" is the definition of sorting, and the option that refers specifically to this action is J, "sort".

Question 11

A table name can include all of the following EXCEPT ____

Accepted Answer

Table names should not include spaces as it can cause errors in the code and make it harder to reference the table in queries or scripts. It is best to use underscores or camel case to separate words in the table name. Numbers and letters are allowable in table names.

Question 12

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

Accepted Answer

Any or all of the given options (boldface, change font, use different color) can be used to make the field names stand out and distinguish them from the data in the list. The choice ultimately depends on personal preference and the design aesthetic of the document.

Question 13

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

Accepted Answer

A table in Excel is a range of related data that is managed independently from the data in other rows and columns in the worksheet. Therefore, the best choice is C, which includes both rows and columns. A is incorrect because headers are just one part of a row, and B and D are not accurate descriptions of independent data ranges.

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A range of related data managed independently from the data in other rows and columns in the worksheet

Accepted Answer

A table is a range of related data managed independently from the data in other rows and columns in the worksheet.

Question 15

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

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 16

Using Excel,you can ____.

Accepted Answer

Excel can be used to store large amounts of data, retrieve subsets of that data through filtering and sorting, and create reports and charts based on the data. Therefore, all of the above options are correct.

Question 17

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

Accepted Answer

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

Question 18

Which of the following is NOT a valid table name?

Accepted Answer

Table names cannot start with a number.

Question 19

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

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

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

Press ____ to return to cell A1 in a worksheet.

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

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

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

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

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

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The field you use to order your 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

A table name can include all of the following EXCEPT ____

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A range of related data managed independently from the data in other rows and columns in the worksheet

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

Using Excel,you can ____.

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

Which of the following is NOT a valid table name?

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