Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Question 4

____________________ also can be added to a table for averages, sums, and other types of calculations.

Accepted Answer

The answer of ____________________ also can be added to a...

Question 5

You can return sorted records to their original order by clicking the ____________________ button on the Quick Access Toolbar.

Accepted Answer

The answer of You can return sorted records to their...

Question 6

The HLOOKUP and VLOOKUP functions can be inserted by tapping or clicking the 'Lookup & Reference' button (FORMULAS tab | Function Library group).

Accepted Answer

A) True 
 B)False

Question 7

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 8

When you first create a table, Excel automatically enables ____.

Accepted Answer

A)  AutoFunction 
B)  AutoCalculate 
C)  AutoFilter 
D)  AutoFormula 
A)  AutoFunction 
B)  AutoCalculate 
C)  AutoFilter 
D)  AutoFormula

Question 9

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

Question 10

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 11

-In the Sort dialog box, shown in the accompanying figure, the ____ is the Sort by field.

Accepted Answer

A)  minor sort key 
B)  major sort key 
C)  intermediate sort key 
D)  none of the above 
A)  minor sort key 
B)  major sort key 
C)  intermediate sort key 
D)  none of the above

Question 12

____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.

Accepted Answer

A)  Row coloring 
B)  Row shielding 
C)  Row banding 
D)  Row separating 
A)  Row coloring 
B)  Row shielding 
C)  Row banding 
D)  Row separating

Question 13

The ____________________ function will count the number of numeric entries in a table field that pass a test.

Accepted Answer

The answer of The ____________________ function will count the number...

Question 14

Describe the HLOOKUP and VLOOKUP functions.

Accepted Answer

The two most widely

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

You can tap or click the arrow to the right side of a cell in the total row to display a list of available statistical functions.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

Question 20

Data is in ____ sequence if it is in order from lowest to highest.

Accepted Answer

A)  sorting 
B)  ascending 
C)  descending 
D)  reporting 
A)  sorting 
B)  ascending 
C)  descending 
D)  reporting

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

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

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

____________________ also can be added to a table for averages, sums, and other types of calculations.

You can return sorted records to their original order by clicking the ____________________ button on the Quick Access Toolbar.

The HLOOKUP and VLOOKUP functions can be inserted by tapping or clicking the 'Lookup & Reference' button (FORMULAS tab | Function Library group).

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

When you first create a table, Excel automatically enables ____.

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

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

-In the Sort dialog box, shown in the accompanying figure, the ____ is the Sort by field.

____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.

The ____________________ function will count the number of numeric entries in a table field that pass a test.

Describe the HLOOKUP and VLOOKUP functions.

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

You can tap or click the arrow to the right side of a cell in the total row to display a list of available statistical functions.

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

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

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

Data is in ____ sequence if it is in order from lowest to highest.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

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

Filters

Exam 7: Creating, Sorting, and Querying a Table

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

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

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

____________________ also can be added to a table for averages, sums, and other types of calculations.

You can return sorted records to their original order by clicking the ____________________ button on the Quick Access Toolbar.

The HLOOKUP and VLOOKUP functions can be inserted by tapping or clicking the 'Lookup & Reference' button (FORMULAS tab | Function Library group).

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

When you first create a table, Excel automatically enables ____.

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

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

-In the Sort dialog box, shown in the accompanying figure, the ____ is the Sort by field.

____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.

The ____________________ function will count the number of numeric entries in a table field that pass a test.

Describe the HLOOKUP and VLOOKUP functions.

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

You can tap or click the arrow to the right side of a cell in the total row to display a list of available statistical functions.

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

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

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

Data is in ____ sequence if it is in order from lowest to highest.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

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

Filters