Question 1

Dan is manipulating data in a table containing records on computer equipment purchases for the past year. Each record in the table contains the date purchased, the type of computer equipment, the vendor’s name, the cost of the equipment, and the department in which the equipment is installed. The records were originally entered in order by month of purchase. Dan sends you an e-mail asking how he can rearrange the table’s records to see all the purchases from each vendor in date order within each department. He also wants to know a quick way to get the data back into its original order, whenever necessary.
-To rearrange the data,you suggest that Dan create a custom sort by setting the ____.

Accepted Answer

The answer of Dan is manipulating data in a table...

Question 2

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-An area of the worksheet that you use to manipulate records that pass the comparison criteria.

Accepted Answer

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

Question 3

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Counts the number of numeric entries in a table field that pass a test.

Accepted Answer

DCOUNT is a database function in Excel that counts the number of numeric entries in a table field that meet specified criteria.

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-The process of filtering activity based on one or more filter criteria.

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.
-Allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.

Accepted Answer

Conditional formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.

Question 6

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-The field or fields you select to sort records.

Accepted Answer

Sort keys are the field or fields that you select to sort records.

Answer: D 
 The extract range is the range from which you want to extract data.

Answer: E 
 The criteria range is the range that contains the conditions you want to use to filter data in a list or database.

Answer: G 
 AutoFilter is a tool that allows you to filter data based on certain criteria.

Answer: H 
 A query is a request to retrieve data from one or more tables or other data sources.

Note: None of the other choices match the definition given.

Question 7

Describe the HLOOKUP and VLOOKUP functions.

Accepted Answer

The answer of Describe the HLOOKUP and VLOOKUP functions....

Question 8

Jane has a worksheet that contains a large amount of data about company products, and she would like to manipulate the data in a variety of ways. She stops by your office and asks if you have any suggestions on an efficient way to do this.
-You tell Jane that if she ____,then she can easily add and delete product records,change the values of fields in records,sort the records in a different order,determine subtotals for numeric fields,display records that meet comparison criteria,and analyze data using database functions.

Accepted Answer

By entering the data into a table, Jane can efficiently manage and manipulate the data using various features like sorting, filtering, and using database functions.

Question 9

Jane has a worksheet that contains a large amount of data about company products, and she would like to manipulate the data in a variety of ways. She stops by your office and asks if you have any suggestions on an efficient way to do this.
-Next you tell Jane that she can accomplish the task by clicking the _____.

Accepted Answer

The "Format as Table" button in the HOME tab under the Styles group allows Jane to convert her data range into a table, enabling her to easily manipulate and analyze the data with features like sorting, filtering, and automatic formatting.

Question 10

Describe how to format a table.

Accepted Answer

The answer of Describe how to format a table....

Question 11

Dan is manipulating data in a table containing records on computer equipment purchases for the past year. Each record in the table contains the date purchased, the type of computer equipment, the vendor’s name, the cost of the equipment, and the department in which the equipment is installed. The records were originally entered in order by month of purchase. Dan sends you an e-mail asking how he can rearrange the table’s records to see all the purchases from each vendor in date order within each department. He also wants to know a quick way to get the data back into its original order, whenever necessary.
-As a quick way to get all the records back into their original order,when necessary,you suggest that before he begins to rearrange the records,Dan should _____.

Accepted Answer

Adding a sequential record number column allows Dan to easily revert to the original order by sorting on this new column.

Quiz 6: Creating,sorting,and Querying a Table

MATCHING Identify the letter of the choice that best matches the phrase or definition. -An area of the worksheet that you use to manipulate records that pass the comparison criteria.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Counts the number of numeric entries in a table field that pass a test.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The process of filtering activity based on one or more filter criteria.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The field or fields you select to sort records.

Describe the HLOOKUP and VLOOKUP functions.

Describe how to format a table.