Exam 6: Creating,sorting,and Querying a Table

Explore all topics

If the function references a(n)range that grows or shrinks,Excel automatically adjusts the first argument if the table grows or shrinks._________________________

(True/False)

4.7/5

(26)

Question 101

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

(Multiple Choice)

4.7/5

(39)

Question 102

The Conditional Formatting ____ dialog box displays all of the rules for the current selection or for the entire workbook.

(Multiple Choice)

4.8/5

(34)

Question 103

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

(True/False)

4.7/5

(36)

Question 104

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.

(Multiple Choice)

4.8/5

(34)

Question 105

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

(True/False)

4.8/5

(31)

Question 106

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

(True/False)

4.9/5

(30)

Question 107

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

(True/False)

4.8/5

(32)

Question 108

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

(Multiple Choice)

4.8/5

(41)

Question 109

Each ____________________ in any given table column should have similar data.

(Short Answer)

4.9/5

(37)

Question 110

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

(True/False)

4.9/5

(37)

Question 111

Showing 101 - 111 of 111

If the function references a(n)range that grows or shrinks,Excel automatically adjusts the first argument if the table grows or shrinks._________________________

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

The Conditional Formatting ____ dialog box displays all of the rules for the current selection or for the entire workbook.

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

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 DAVERAGE function counts the number of numeric entries in a table field that pass a test._________________________

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

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

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

Each ____________________ in any given table column should have similar data.

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

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

Office 2013 and Windows 8 Essential Concepts and Skills

Filters