Question 1

A(n)____________________ row-and-column structure can be used to organize and store a table or database.

Accepted Answer

worksheet

Question 2

Which of the following are guidelines for creating a table in Excel?

Accepted Answer

A) Do not enter more than one table per worksheet 
B) Place column headings (field names)in the first row of the table 
C) Maintain at least one blank row between a table and other worksheet entries 
D) Do not use blank rows or rows with repeating characters to separate the column headings (field names)from the data 
E) None of the above. 
A) Do not enter more than one table per worksheet 
B) Place column headings (field names)in the first row of the table 
C) Maintain at least one blank row between a table and other worksheet entries 
D) Do not use blank rows or rows with repeating characters to separate the column headings (field names)from the data 
E) None of the above.

Question 3

If the criteria range contains a blank row,it means that no comparison criteria have been defined._________________________

Accepted Answer

A) True 
 B)False

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Uses specific criteria to count a number of items.

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 5

Which of the following is the path to the 'Sort & Filter' button?

Accepted Answer

Question 6

Placing more than one table on the same worksheet is recommended.

Accepted Answer

A) True 
 B)False

Question 7

When creating a table,place ____________________ in the first row of the table.

Accepted Answer

column hea

Question 8

Which of the following is NOT a type of conditional formatting?

Accepted Answer

A)  Highlight Cells Rules 
B)  Icon Sets 
C)  Data Bars 
D)  Row Banding 
A)  Highlight Cells Rules 
B)  Icon Sets 
C)  Data Bars 
D)  Row Banding

Question 9

Using a(n)____________________ sometimes is faster than entering criteria through the AutoFilter system because once it is established,you do not have to access any menus or dialog boxes to perform the query.

Accepted Answer

The answer of Using a(n)____________________ sometimes is faster than entering...

Question 10

A check mark in the ____________________ check box on the AutoFilter menu indicates that all values for the selected field are displayed in the table.

Accepted Answer

The answer of A check mark in the ____________________ check...

Question 11

Each row of an Excel worksheet used to create a table can store a record,and each column can store a(n)____.

Accepted Answer

A)  record 
B)  entity 
C)  field 
D)  element 
A)  record 
B)  entity 
C)  field 
D)  element

Question 12

If the table column you choose to sort contains numeric data,the Sort & Filter menu shows the Sort Smallest to Largest and Sort Largest to Smallest commands.

Accepted Answer

A) True 
 B)False

Question 13

A list of all the values that occur in the selected column appear in the AutoFilter menu.

Accepted Answer

A) True 
 B)False

Question 14

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

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

____ cause(s)adjacent rows or columns to have different formatting so that each row or column in the table is distinguished from the surrounding rows or columns.

Accepted Answer

A) Row banding 
B) Row styles 
C) Column banding 
D) Column styles 
A) Row banding 
B) Row styles 
C) Column banding 
D) Column styles

Question 16

The ____ function is used when the table direction is horizontal.

Accepted Answer

A) VLOOKUP 
B) HLOOKUP 
C) MLOOKUP 
D) ZLOOKUP 
A) VLOOKUP 
B) HLOOKUP 
C) MLOOKUP 
D) ZLOOKUP

Question 17

For the VLOOKUP function to work correctly, the table ____ must be in sequence from lowest to highest.

Accepted Answer

A) array 
B) arguments 
C) rows 
D) columns 
A) array 
B) arguments 
C) rows 
D) columns

Question 18

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

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 19

If you deselect an item from the filter menu,it is called the filter ____.

Accepted Answer

A)  factor 
B)  variable 
C)  index 
D)  criterion 
A)  factor 
B)  variable 
C)  index 
D)  criterion

Question 20

Which of the following is the path to the 'Lookup & Reference' button?

Accepted Answer

A(n)____________________ row-and-column structure can be used to organize and store a table or database.

Which of the following are guidelines for creating a table in Excel?

If the criteria range contains a blank row,it means that no comparison criteria have been defined._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Uses specific criteria to count a number of items.

Which of the following is the path to the 'Sort & Filter' button?

Placing more than one table on the same worksheet is recommended.

When creating a table,place ____________________ in the first row of the table.

Which of the following is NOT a type of conditional formatting?

Using a(n)____________________ sometimes is faster than entering criteria through the AutoFilter system because once it is established,you do not have to access any menus or dialog boxes to perform the query.

A check mark in the ____________________ check box on the AutoFilter menu indicates that all values for the selected field are displayed in the table.

Each row of an Excel worksheet used to create a table can store a record,and each column can store a(n)____.

If the table column you choose to sort contains numeric data,the Sort & Filter menu shows the Sort Smallest to Largest and Sort Largest to Smallest commands.

A list of all the values that occur in the selected column appear in the AutoFilter menu.

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

____ cause(s)adjacent rows or columns to have different formatting so that each row or column in the table is distinguished from the surrounding rows or columns.

The ____ function is used when the table direction is horizontal.

For the VLOOKUP function to work correctly, the table ____ must be in sequence from lowest to highest.

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.

If you deselect an item from the filter menu,it is called the filter ____.

Which of the following is the path to the 'Lookup & Reference' button?

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

A(n)____________________ row-and-column structure can be used to organize and store a table or database.

Which of the following are guidelines for creating a table in Excel?

If the criteria range contains a blank row,it means that no comparison criteria have been defined._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Uses specific criteria to count a number of items.

Which of the following is the path to the 'Sort & Filter' button?

Placing more than one table on the same worksheet is recommended.

When creating a table,place ____________________ in the first row of the table.

Which of the following is NOT a type of conditional formatting?

Using a(n)____________________ sometimes is faster than entering criteria through the AutoFilter system because once it is established,you do not have to access any menus or dialog boxes to perform the query.

A check mark in the ____________________ check box on the AutoFilter menu indicates that all values for the selected field are displayed in the table.

Each row of an Excel worksheet used to create a table can store a record,and each column can store a(n)____.

If the table column you choose to sort contains numeric data,the Sort & Filter menu shows the Sort Smallest to Largest and Sort Largest to Smallest commands.

A list of all the values that occur in the selected column appear in the AutoFilter menu.

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

____ cause(s)adjacent rows or columns to have different formatting so that each row or column in the table is distinguished from the surrounding rows or columns.

The ____ function is used when the table direction is horizontal.

For the VLOOKUP function to work correctly, the table ____ must be in sequence from lowest to highest.

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.

If you deselect an item from the filter menu,it is called the filter ____.

Which of the following is the path to the 'Lookup & Reference' button?

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