Question 1

Excel includes ____ database functions that allow you to evaluate numeric data in a table.

Accepted Answer

A)  4 
B)  8 
C)  12 
D)  16 
A)  4 
B)  8 
C)  12 
D)  16

Question 2

The ____ function is useful when you want to add values in a range only if they meet criteria.

Accepted Answer

A)  DCOUNT 
B)  MATCH 
C)  INDEX 
D)  SUMIF 
A)  DCOUNT 
B)  MATCH 
C)  INDEX 
D)  SUMIF

Question 3

A table can have a maximum of 16,384 fields and 1,048,576 records.

Accepted Answer

A) True 
 B)False

Question 4

The left column values in a table array are called table ____.

Accepted Answer

A)  text 
B)  arguments 
C)  functions 
D)  dollar signs 
A)  text 
B)  arguments 
C)  functions 
D)  dollar signs

Question 5

The comparison criteria in the ____ range determine the records that will pass the test when the Advanced Filter dialog box is used.

Accepted Answer

A)  criteria 
B)  extract 
C)  database 
D)  filter 
A)  criteria 
B)  extract 
C)  database 
D)  filter

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

Question 9

Which of the following are database functions?

Accepted Answer

A)  AVERAGE 
B)  DAVERAGE 
C)  SUM 
D)  DSUM 
A)  AVERAGE 
B)  DAVERAGE 
C)  SUM 
D)  DSUM

Question 10

Which of the following are outline symbols?

Accepted Answer

A)  plus sign 
B)  minus sign 
C)  parentheses 
D)  brackets 
A)  plus sign 
B)  minus sign 
C)  parentheses 
D)  brackets

Question 11

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 12

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 13

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

Accepted Answer

A)  Place column headings (field names)in the first row of the table 
B)  Maintain at least one blank row between a table and other worksheet entries 
A)  Place column headings (field names)in the first row of the table 
B)  Maintain at least one blank row between a table and other worksheet entries

Question 14

The DCOUNT function can count either numeric fields or text fields.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A)  Quick 
B)  Conditional 
C)  Styles 
D)  Cell 
A)  Quick 
B)  Conditional 
C)  Styles 
D)  Cell

Question 16

In a multiple-field filter operation,the AND and OR options are interchangeable.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

Question 18

The DAVERAGE function counts the number of numeric entries in a table field that pass a test._________________________

Accepted Answer

A) True 
 B)False

Question 19

The ____ function is used when a table direction is vertical.

Accepted Answer

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

Question 20

In a table,or database,the data related to each person or item is called a ____.

Accepted Answer

A)  formula 
B)  field 
C)  calculation 
D)  record 
A)  formula 
B)  field 
C)  calculation 
D)  record

Excel includes ____ database functions that allow you to evaluate numeric data in a table.

The ____ function is useful when you want to add values in a range only if they meet criteria.

A table can have a maximum of 16,384 fields and 1,048,576 records.

The left column values in a table array are called table ____.

The comparison criteria in the ____ range determine the records that will pass the test when the Advanced Filter dialog box is used.

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

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

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

Which of the following are database functions?

Which of the following are outline symbols?

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

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

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

The DCOUNT function can count either numeric fields or text fields.

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

In a multiple-field filter operation,the AND and OR options are interchangeable.

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

The DAVERAGE function counts the number of numeric entries in a table field that pass a test._________________________

The ____ function is used when a table direction is vertical.

In a table,or database,the data related to each person or item is called a ____.

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

Excel includes ____ database functions that allow you to evaluate numeric data in a table.

The ____ function is useful when you want to add values in a range only if they meet criteria.

A table can have a maximum of 16,384 fields and 1,048,576 records.

The left column values in a table array are called table ____.

The comparison criteria in the ____ range determine the records that will pass the test when the Advanced Filter dialog box is used.

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

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

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

Which of the following are database functions?

Which of the following are outline symbols?

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

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

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

The DCOUNT function can count either numeric fields or text fields.

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

In a multiple-field filter operation,the AND and OR options are interchangeable.

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

The DAVERAGE function counts the number of numeric entries in a table field that pass a test._________________________

The ____ function is used when a table direction is vertical.

In a table,or database,the data related to each person or item is called a ____.

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