Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-The field or fields you select to sort records.
A)SUMIF
B)COUNTIF
C)DCOUNT
D)extract range
E)criteria range
F)Custom Filter
G)AutoFilter
H)query
I)sort keys
J)conditional formatting

Accepted Answer

Sort keys are the fields that are selected to sort records.

Question 2

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.
A)SUMIF
B)COUNTIF
C)DCOUNT
D)extract range
E)criteria range
F)Custom Filter
G)AutoFilter
H)query
I)sort keys
J)conditional formatting

Accepted Answer

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

Question 3

Case 6-1
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.
A) deletes the range and reenters the data in a table
B) enters a table
C) prints the range as a table
D) converts the table back to a range

Accepted Answer

By entering the data as a table, Jane can easily manipulate the data in a variety of ways such as adding and deleting product records, sorting the records in a different order, determining subtotals for numeric fields, displaying records that meet comparison criteria, and analyzing data using database functions. Tables in Excel are designed to be user-friendly and offer a variety of features that make working with data easier. Plus, tables automatically expand and contract as new data is added or deleted, making them a more efficient option than deleting and re-entering data in a range. Converting the table back to a range can be done later if necessary.

Question 4

Briefly explain how to search a table using AutoFilter.

Accepted Answer

The answer of Briefly explain how to search a table...

Question 5

Case 6-2
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 ____.
A) purchase date field as the major sort key, the vendor field as the intermediate sort key, and the department field as the minor sort key
B) vendor field as the major sort key, the department field as the intermediate sort key, and the purchase date field as the minor sort key
C) purchase date field as the major sort key, the department field as the intermediate sort key, and the vendor as the minor sort key
D) department field as the major sort key, the vendor field as the intermediate sort key, and the purchase date field as the minor sort key

Accepted Answer

The answer of Case 6-2
Dan is manipulating data in a...

Question 6

Case 6-1
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 _____.
A) Recreate as Table button (DATA tab | Table group)
B) Convert to Table button (HOME tab | Styles group)
C) Format as Table button (HOME tab | Styles group)
D) Apply Table Formatting button (LAYOUT tab | Styles group)

Accepted Answer

The Format as Table button allows Jane to quickly turn her data into a table, which can be easily sorted, filtered, and formatted in a variety of ways. This button is located on the HOME tab in the Styles group. The other buttons listed do not provide the same functionality as the Format as Table button.

Question 7

Describe the HLOOKUP and VLOOKUP functions.

Accepted Answer

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

Question 8

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.
A)SUMIF
B)COUNTIF
C)DCOUNT
D)extract range
E)criteria range
F)Custom Filter
G)AutoFilter
H)query
I)sort keys
J)conditional formatting

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 9

Case 6-2
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 _____.
A) sort first on the department field and then the date purchased field
B) create a duplicate worksheet with the records in their original order as a backup before sorting them in a different order
C) insert a column (field) and use the fill handle to add sequential record numbers in the column; then sort the record numbers in ascending sequence to rearrange the records in their original order whenever necessary
D) sort first on the computer type field and then on the date purchased field

Accepted Answer

Adding sequential record numbers to a newly inserted column before rearranging the data allows for a quick and easy way to get the data back into its original order whenever necessary. Sorting on the department field and then the date purchased field (A) or sorting on the computer type field and then the date purchased field (D) may not result in the original order if the original order was not based on those fields. Creating a duplicate worksheet as a backup (B) is a good practice, but not necessary for quickly getting the data back into its original order.

Question 10

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.
A)SUMIF
B)COUNTIF
C)DCOUNT
D)extract range
E)criteria range
F)Custom Filter
G)AutoFilter
H)query
I)sort keys
J)conditional formatting

Accepted Answer

Criteria range is an area of the worksheet that you use to manipulate records that pass the comparison criteria.

Question 11

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.
A)SUMIF
B)COUNTIF
C)DCOUNT
D)extract range
E)criteria range
F)Custom Filter
G)AutoFilter
H)query
I)sort keys
J)conditional formatting

Accepted Answer

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

Question 12

Describe how to format a table.

Accepted Answer

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

Quiz 7: Creating, Sorting, and Querying a Table

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

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.

Briefly explain how to search a table using AutoFilter.

Describe the HLOOKUP and VLOOKUP functions.

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. -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.

Describe how to format a table.