Question 1

Briefly explain how to search a table using AutoFilter.

Accepted Answer

Using AutoFilter,you can search for spec

Question 2

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Uses specific criteria to add a range of values.

Accepted Answer

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

Question 3

A table also is called a record.

Accepted Answer

A) True 
 B)False

Question 4

The VLOOKUP function uses the left column of the ____ to compare against a particular number in the main table.

Accepted Answer

A) row 
B) able column 
C) worksheet 
D) table array 
A) row 
B) able column 
C) worksheet 
D) table array

Question 5

The field or fields selected for sorting records are called ____ keys.

Accepted Answer

A)  label 
B)  record 
C)  field 
D)  sort 
A)  label 
B)  record 
C)  field 
D)  sort

Question 6

Like the AutoFilter query technique,the ____ command displays a subset of the table.

Accepted Answer

A)  Advanced Filter 
B)  Advanced Sort 
C)  Advanced Formatting 
D)  Advanced Functions 
A)  Advanced Filter 
B)  Advanced Sort 
C)  Advanced Formatting 
D)  Advanced Functions

Question 7

Which of the following is the path to the Format as Table button?

Accepted Answer

Question 8

A(n)____________________ total sums all of the data in a row or column.

Accepted Answer

The answer of A(n)____________________ total sums all of the data...

Question 9

A(n)____________________ is the sum of a subset of data.

Accepted Answer

The answer of A(n)____________________ is the sum of a subset...

Question 10

Excel turns on the outline feature automatically when you create subtotals.

Accepted Answer

A) True 
 B)False

Question 11

Excel includes ____________________ types of conditional formats.

Accepted Answer

The answer of Excel includes ____________________ types of conditional formats....

Question 12

In a table,a column that contains formulas or functions is called a(n)____.

Accepted Answer

A)  calculated column 
B)  mathematical boundary 
C)  algorithmic total 
D)  indexed column 
A)  calculated column 
B)  mathematical boundary 
C)  algorithmic total 
D)  indexed column

Question 13

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

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

Question 14

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

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

Question 15

You can insert a ____ at the bottom of a table.

Accepted Answer

A)  bottom row 
B)  total column 
C)  total row 
D)  none of the above 
A)  bottom row 
B)  total column 
C)  total row 
D)  none of the above

Question 16

The ____ function returns the value or reference of the cell at the intersection of a particular row and column in a table or range.

Accepted Answer

A)  INDEX 
B)  NEXUS 
C)  MATCH 
D)  NODE 
A)  INDEX 
B)  NEXUS 
C)  MATCH 
D)  NODE

Question 17

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Allows you to enter custom criteria,such as multiple options or ranges of numbers.

Accepted Answer

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

Question 18

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

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

Question 19

To remove a filter criterion for a single field,select the Select All option from the column heading AutoFilter menu for that field.

Accepted Answer

A) True 
 B)False

Question 20

The general form of the VLOOKUP function is ____.

Accepted Answer

A) =VLOOKUP(lookup_table, col_index_num) 
B) =VLOOKUP(lookup_value, row_index_num) 
C) =VLOOKUP(lookup_value, lookup_table, col_index_num) 
D) =VLOOKUP(lookup_value) 
A) =VLOOKUP(lookup_table, col_index_num) 
B) =VLOOKUP(lookup_value, row_index_num) 
C) =VLOOKUP(lookup_value, lookup_table, col_index_num) 
D) =VLOOKUP(lookup_value)

Briefly explain how to search a table using AutoFilter.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Uses specific criteria to add a range of values.

A table also is called a record.

The VLOOKUP function uses the left column of the ____ to compare against a particular number in the main table.

The field or fields selected for sorting records are called ____ keys.

Like the AutoFilter query technique,the ____ command displays a subset of the table.

Which of the following is the path to the Format as Table button?

A(n)____________________ total sums all of the data in a row or column.

A(n)____________________ is the sum of a subset of data.

Excel turns on the outline feature automatically when you create subtotals.

Excel includes ____________________ types of conditional formats.

In a table,a column that contains formulas or functions is called a(n)____.

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.

You can insert a ____ at the bottom of a table.

The ____ function returns the value or reference of the cell at the intersection of a particular row and column in a table or range.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Allows you to enter custom criteria,such as multiple options or ranges of numbers.

To remove a filter criterion for a single field,select the Select All option from the column heading AutoFilter menu for that field.

The general form of the VLOOKUP function is ____.

Creating a Worksheet and a Chart

Formulas,Functions,and Formatting

Working With Large Worksheets,Charting,and What-If Analysis

Financial Functions,Data Tables,and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters

Exam 6: Creating,sorting,and Querying a Table

Briefly explain how to search a table using AutoFilter.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Uses specific criteria to add a range of values.

A table also is called a record.

The VLOOKUP function uses the left column of the ____ to compare against a particular number in the main table.

The field or fields selected for sorting records are called ____ keys.

Like the AutoFilter query technique,the ____ command displays a subset of the table.

Which of the following is the path to the Format as Table button?

A(n)____________________ total sums all of the data in a row or column.

A(n)____________________ is the sum of a subset of data.

Excel turns on the outline feature automatically when you create subtotals.

Excel includes ____________________ types of conditional formats.

In a table,a column that contains formulas or functions is called a(n)____.

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.

You can insert a ____ at the bottom of a table.

The ____ function returns the value or reference of the cell at the intersection of a particular row and column in a table or range.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Allows you to enter custom criteria,such as multiple options or ranges of numbers.

To remove a filter criterion for a single field,select the Select All option from the column heading AutoFilter menu for that field.

The general form of the VLOOKUP function is ____.

Creating a Worksheet and a Chart

Formulas,Functions,and Formatting

Working With Large Worksheets,Charting,and What-If Analysis

Financial Functions,Data Tables,and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters