Question 1

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 C

Question 2

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 B

Question 3

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

Accepted Answer

Undo

Question 4

Which of the following is an option to distribute a document electronically?

Accepted Answer

A) sending a document via email 
B) posting the file on cloud storage 
C) posting it on a blog 
D) posting it on a social networking site 
E)  None of the above. 
A) sending a document via email 
B) posting the file on cloud storage 
C) posting it on a blog 
D) posting it on a social networking site 
E)  None of the above.

Question 5

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Counts the number of numeric entries in a table field that pass a test.

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

-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,the...

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

A ____ should be formatted so that the records are easily distinguished.

Accepted Answer

A)  function 
B)  table 
C)  formula 
D)  recordset 
A)  function 
B)  table 
C)  formula 
D)  recordset

Question 9

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

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 11

The left column values in a table array are called table ____.

Accepted Answer

A)  text 
B)  arguments 
C)  functions 
D)  dollar signs 
A)  text 
B)  arguments 
C)  functions 
D)  dollar signs

Question 12

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 13

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 14

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 15

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 16

You can sort data in a table by tapping or clicking the Sort A to Z button in the Sort & Filter group on the ____________________ tab.

Accepted Answer

The answer of You can sort data in a table...

Question 17

Describe the HLOOKUP and VLOOKUP functions.

Accepted Answer

The two most widely used looku

Question 18

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

Accepted Answer

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

Question 19

The Conditional Formatting Rules Manager dialog box allows you to change the order in which the rules are applied to a cell or range.

Accepted Answer

A) True 
 B)False

Question 20

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

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

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

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

Which of the following is an option to distribute a document electronically?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Counts the number of numeric entries in a table field that pass a test.

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

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

A ____ should be formatted so that the records are easily distinguished.

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

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

The left column values in a table array are called table ____.

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.

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

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

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

You can sort data in a table by tapping or clicking the Sort A to Z button in the Sort & Filter group on the ____________________ tab.

Describe the HLOOKUP and VLOOKUP functions.

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

The Conditional Formatting Rules Manager dialog box allows you to change the order in which the rules are applied to a cell or range.

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

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

Exam 6: Creating,sorting,and Querying a Table

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

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

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

Which of the following is an option to distribute a document electronically?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Counts the number of numeric entries in a table field that pass a test.

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

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

A ____ should be formatted so that the records are easily distinguished.

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

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

The left column values in a table array are called table ____.

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.

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

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

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

You can sort data in a table by tapping or clicking the Sort A to Z button in the Sort & Filter group on the ____________________ tab.

Describe the HLOOKUP and VLOOKUP functions.

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

The Conditional Formatting Rules Manager dialog box allows you to change the order in which the rules are applied to a cell or range.

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

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