Question 1

Why is the VLOOKUP function used more often than other lookup functions?

Accepted Answer

A)  Because it has more powerful calculations 
B)  Because most tables are vertical 
C)  Because it is easier to implement 
D)  Because it is the default lookup function 
A)  Because it has more powerful calculations 
B)  Because most tables are vertical 
C)  Because it is easier to implement 
D)  Because it is the default lookup function B

Question 2

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 D

Question 3

A worksheet's row-and-column structure can be used to organize and store a ____.

Accepted Answer

A)  table 
B)  formula 
C)  function 
D)  cell 
A)  table 
B)  formula 
C)  function 
D)  cell A

Question 4

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 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

A ____ should be formatted so that the records are easily distinguished.

Accepted Answer

A)  function 
B)  table 
C)  formula 
D)  recordset 
A)  function 
B)  table 
C)  formula 
D)  recordset

Question 9

Both the HLOOKUP and VLOOKUP functions look up a value in a table and return a corresponding value from the table to the cell containing the function.

Accepted Answer

A) True 
 B)False

Question 10

The DAVERAGE function requires a numeric field from the table range.

Accepted Answer

A) True 
 B)False

Question 11

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 12

Database is the name most often assigned to a table.

Accepted Answer

A) True 
 B)False

Question 13

The process of filtering activity based on one or more filter criteria is called a ____.

Accepted Answer

A)  search 
B)  query 
C)  sort 
D)  calculation 
A)  search 
B)  query 
C)  sort 
D)  calculation

Question 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

You can set up a criteria range on the worksheet and use it to manipulate formulas that pass the comparison criteria._________________________

Accepted Answer

A) True 
 B)False

Question 18

The path to the Percent Style button is (HOME tab | Editing group).

Accepted Answer

A) True 
 B)False

Question 19

____ records allows you to pull data from a table so that you can analyze or manipulate the data further.

Accepted Answer

A)  Sorting 
B)  Filtering 
C)  Extracting 
D)  Formatting 
A)  Sorting 
B)  Filtering 
C)  Extracting 
D)  Formatting

Question 20

When you select a second filter criterion in a table,Excel turns off all previously selected filter criteria.

Accepted Answer

A) True 
 B)False

Why is the VLOOKUP function used more often than other lookup functions?

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

A worksheet's row-and-column structure can be used to organize and store a ____.

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

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

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

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

A ____ should be formatted so that the records are easily distinguished.

Both the HLOOKUP and VLOOKUP functions look up a value in a table and return a corresponding value from the table to the cell containing the function.

The DAVERAGE function requires a numeric field from the table range.

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

Database is the name most often assigned to a table.

The process of filtering activity based on one or more filter criteria is called a ____.

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

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

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

You can set up a criteria range on the worksheet and use it to manipulate formulas that pass the comparison criteria._________________________

The path to the Percent Style button is (HOME tab | Editing group).

____ records allows you to pull data from a table so that you can analyze or manipulate the data further.

When you select a second filter criterion in a table,Excel turns off all previously selected filter criteria.

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 Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

Exam 6: Creating, Sorting, and Querying a Table

Why is the VLOOKUP function used more often than other lookup functions?

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

A worksheet's row-and-column structure can be used to organize and store a ____.

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

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

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

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

A ____ should be formatted so that the records are easily distinguished.

Both the HLOOKUP and VLOOKUP functions look up a value in a table and return a corresponding value from the table to the cell containing the function.

The DAVERAGE function requires a numeric field from the table range.

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

Database is the name most often assigned to a table.

The process of filtering activity based on one or more filter criteria is called a ____.

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

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

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

You can set up a criteria range on the worksheet and use it to manipulate formulas that pass the comparison criteria._________________________

The path to the Percent Style button is (HOME tab | Editing group).

____ records allows you to pull data from a table so that you can analyze or manipulate the data further.

When you select a second filter criterion in a table,Excel turns off all previously selected filter criteria.

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 Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters