Question 1

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 2

A ____ total sums all of the data in a row or column.

Accepted Answer

A)  grand 
B)  global 
C)  master 
D)  value 
A)  grand 
B)  global 
C)  master 
D)  value

Question 3

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 4

The values ____ satisfy a custom filter criteria that displays records in which the Experience field contains a value greater than or equal to 3 and less than or equal to 5.

Accepted Answer

A)  1, 2, 3 
B)  3, 4, 5 
C)  5, 6, 7 
D)  none of the above 
A)  1, 2, 3 
B)  3, 4, 5 
C)  5, 6, 7 
D)  none of the above

Question 5

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-When enabled with hidden records, Excel displays a filter icon on the filter buttons used to establish the filter.

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

Case 6-1
Jane has a worksheet that contains a large amount of data about company products, and she would like to manipulate the data in a variety of ways. She stops by your office and asks if you have any suggestions on an efficient way to do this.
-Next you tell Jane that she can accomplish the task by clicking the _____.

Accepted Answer

A)  Recreate as Table button (DATA tab | Table group) 
B)  Convert to Table button (HOME tab | Styles group) 
C)  Format as Table button (HOME tab | Styles group) 
D)  Apply Table Formatting button (LAYOUT tab | Styles group) 
A)  Recreate as Table button (DATA tab | Table group) 
B)  Convert to Table button (HOME tab | Styles group) 
C)  Format as Table button (HOME tab | Styles group) 
D)  Apply Table Formatting button (LAYOUT tab | Styles group)

Question 8

A table also is called a record.

Accepted Answer

A) True 
 B)False

Question 9

Data in descending sequence is sorted from lowest to highest, earlier to most recent, or alphabetically from A to Z.

Accepted Answer

A) True 
 B)False

Question 10

Individual data items that make up a record are called ____________________.

Accepted Answer

The answer of Individual data items that make up a...

Question 11

Which of the following is the path to the Total Row check box?

Accepted Answer

A)  (TABLE TOOLS FORMAT tab | Table Style Options group) 
B)  (TABLE TOOLS LAYOUT tab | Table Options group) 
C)  (TABLE TOOLS DESIGN tab | Table Style Options group) 
D)  (TABLE TOOLS CONTROL tab | Table Style Options group) 
A)  (TABLE TOOLS FORMAT tab | Table Style Options group) 
B)  (TABLE TOOLS LAYOUT tab | Table Options group) 
C)  (TABLE TOOLS DESIGN tab | Table Style Options group) 
D)  (TABLE TOOLS CONTROL tab | Table Style Options group)

Question 12

Excel does not sort ____________________ records.

Accepted Answer

The answer of Excel does not sort ____________________ records....

Question 13

All of the database functions require a field name as one of the arguments.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

The ____ function returns the value or reference of the cell at the intersection of a particular row and column in a table or range.

Accepted Answer

A)  INDEX 
B)  NEXUS 
C)  MATCH 
D)  NODE 
A)  INDEX 
B)  NEXUS 
C)  MATCH 
D)  NODE

Question 16

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

Accepted Answer

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

Question 17

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 18

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 19

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 20

____ 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

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

A ____ total sums all of the data in a row or column.

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 values ____ satisfy a custom filter criteria that displays records in which the Experience field contains a value greater than or equal to 3 and less than or equal to 5.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -When enabled with hidden records, Excel displays a filter icon on the filter buttons used to establish the filter.

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

A table also is called a record.

Data in descending sequence is sorted from lowest to highest, earlier to most recent, or alphabetically from A to Z.

Individual data items that make up a record are called ____________________.

Which of the following is the path to the Total Row check box?

Excel does not sort ____________________ records.

All of the database functions require a field name as one of the arguments.

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

The ____ function returns the value or reference of the cell at the intersection of a particular row and column in a table or range.

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

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

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

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

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

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 are guidelines for creating a table in Excel?

A ____ total sums all of the data in a row or column.

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 values ____ satisfy a custom filter criteria that displays records in which the Experience field contains a value greater than or equal to 3 and less than or equal to 5.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -When enabled with hidden records, Excel displays a filter icon on the filter buttons used to establish the filter.

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

A table also is called a record.

Data in descending sequence is sorted from lowest to highest, earlier to most recent, or alphabetically from A to Z.

Individual data items that make up a record are called ____________________.

Which of the following is the path to the Total Row check box?

Excel does not sort ____________________ records.

All of the database functions require a field name as one of the arguments.

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

The ____ function returns the value or reference of the cell at the intersection of a particular row and column in a table or range.

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

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

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

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

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

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