Question 1

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 2

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 J

Question 3

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 A, B, D

Question 4

The VLOOKUP and HLOOKUP functions provide greater flexibility than the MATCH and INDEX functions.

Accepted Answer

A) True 
 B)False

Question 5

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 6

Briefly explain how to search a table using AutoFilter.

Accepted Answer

Using AutoFilter, you can search for spe

Question 7

You can apply merge and center formatting with the Center button (HOME tab | Alignment group).

Accepted Answer

A) True 
 B)False

Question 8

If the function references a(n) table that changes places on the worksheet, you would have to reenter the function.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

column hea

Question 10

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-The process of filtering activity based on one or more filter 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 11

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 12

With criteria ranges, if you want an AND operator on two different fields, your criteria range must contain two (or more) data rows.

Accepted Answer

A) True 
 B)False

Question 13

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 14

-As shown in the accompanying figure, the ____________________ symbols include plus and minus signs for showing and hiding portions of the spreadsheet, as well as brackets identifying the groups.

Accepted Answer

The answer of  
-As shown in the accompanying figure,...

Question 15

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 16

The ____________________ command on the AutoFilter menu allows you to enter custom criteria, such as multiple options or ranges of numbers.

Accepted Answer

The answer of The ____________________ command on the AutoFilter menu...

Question 17

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 18

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

Accepted Answer

Question 19

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 20

The ____ function tells you the relative position of an item in a range or table, which is the same as a specified value in a specified order.

Accepted Answer

A)  ALIGN 
B)  COMPARE 
C)  MATCH 
D)  LINK 
A)  ALIGN 
B)  COMPARE 
C)  MATCH 
D)  LINK

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

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.

Which of the following are outline symbols?

The VLOOKUP and HLOOKUP functions provide greater flexibility than the MATCH and INDEX functions.

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

Briefly explain how to search a table using AutoFilter.

You can apply merge and center formatting with the Center button (HOME tab | Alignment group).

If the function references a(n) table that changes places on the worksheet, you would have to reenter the function.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The process of filtering activity based on one or more filter criteria.

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

With criteria ranges, if you want an AND operator on two different fields, your criteria range must contain two (or more) data rows.

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.

-As shown in the accompanying figure, the ____________________ symbols include plus and minus signs for showing and hiding portions of the spreadsheet, as well as brackets identifying the groups.

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.

The ____________________ command on the AutoFilter menu allows you to enter custom criteria, such as multiple options or ranges of numbers.

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

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

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

The ____ function tells you the relative position of an item in a range or table, which is the same as a specified value in a specified order.

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

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

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.

Which of the following are outline symbols?

The VLOOKUP and HLOOKUP functions provide greater flexibility than the MATCH and INDEX functions.

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

Briefly explain how to search a table using AutoFilter.

You can apply merge and center formatting with the Center button (HOME tab | Alignment group).

If the function references a(n) table that changes places on the worksheet, you would have to reenter the function.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The process of filtering activity based on one or more filter criteria.

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

With criteria ranges, if you want an AND operator on two different fields, your criteria range must contain two (or more) data rows.

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.

-As shown in the accompanying figure, the ____________________ symbols include plus and minus signs for showing and hiding portions of the spreadsheet, as well as brackets identifying the groups.

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.

The ____________________ command on the AutoFilter menu allows you to enter custom criteria, such as multiple options or ranges of numbers.

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

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

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

The ____ function tells you the relative position of an item in a range or table, which is the same as a specified value in a specified order.

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