Question 1

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 2

A table also is called a record.

Accepted Answer

A) True 
 B)False

Question 3

To change an active table back to a normal range of cells,right-click the table,point to Table on the shortcut menu,and then click ____ on the Table submenu.

Accepted Answer

A)  Change to Range 
B)  Revert to Range 
C)  Convert to Range 
D)  Replace with Range 
A)  Change to Range 
B)  Revert to Range 
C)  Convert to Range 
D)  Replace with Range

Question 4

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 5

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

Question 6

With a database function,if one of your arguments is a field name and the field name is text,rather than a cell reference,number,or range,the argument must be enclosed in ____.

Accepted Answer

A)  quotation marks 
B)  brackets 
C)  ampersands 
D)  asterisks 
A)  quotation marks 
B)  brackets 
C)  ampersands 
D)  asterisks

Question 7

You can 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 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

____ 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

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

A table also is called a record.

To change an active table back to a normal range of cells,right-click the table,point to Table on the shortcut menu,and then click ____ on the Table submenu.

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

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

With a database function,if one of your arguments is a field name and the field name is text,rather than a cell reference,number,or range,the argument must be enclosed in ____.

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

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.

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

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

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

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

A table also is called a record.

To change an active table back to a normal range of cells,right-click the table,point to Table on the shortcut menu,and then click ____ on the Table submenu.

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

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

With a database function,if one of your arguments is a field name and the field name is text,rather than a cell reference,number,or range,the argument must be enclosed in ____.

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

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.

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

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

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