Question 1

Which of the following is the path to the 'Sort & Filter' button?

Accepted Answer

Question 2

The path to the Percent Style button is (HOME tab | Editing group).

Accepted Answer

A) True 
 B)False

Question 3

Match between columns
                        Premises: Counts the number of numeric entries in a table field that pass a test.

Accepted Answer

The Answer of sort keys and Custom Filter and criteria is...

Question 4

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

Question 5

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 6

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 7

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 8

Match between columns
                        Premises: The location to where records that meet the comparison criteria in the criteria range are copied.

Accepted Answer

The Answer of extract range and criteria range and Custom is...

Question 9

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 10

Match between columns
                        Premises: The field or fields you select to sort records.

Accepted Answer

The Answer of SUMIF and COUNTIF and DCOUNT and criteria is...

Question 11

Match between columns
                        Premises: 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

The Answer of query and COUNTIF and DCOUNT and Custom is...

Question 12

In a table, or database, the data related to each person or item is called a ____.

Accepted Answer

A)  formula 
B)  field 
C)  calculation 
D)  record 
A)  formula 
B)  field 
C)  calculation 
D)  record

Question 13

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

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

Modified Multiple Choice ____ cause(s) adjacent rows or columns to have different formatting so that each row or column in the table is distinguished from the surrounding rows or columns.

Accepted Answer

A)  Row banding 
B)  Row styles 
C)  Column banding 
D)  Column styles 
A)  Row banding 
B)  Row styles 
C)  Column banding 
D)  Column styles

Question 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

Why is the VLOOKUP function used more often than other lookup functions?

Accepted Answer

A)  Because it has more powerful calculations 
B)  Because most tables are vertical 
C)  Because it is easier to implement 
D)  Because it is the default lookup function 
A)  Because it has more powerful calculations 
B)  Because most tables are vertical 
C)  Because it is easier to implement 
D)  Because it is the default lookup function

Which of the following is the path to the 'Sort & Filter' button?

The path to the Percent Style button is (HOME tab | Editing group).

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

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.

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

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

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

In a table, or database, the data related to each person or item is called a ____.

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.

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

Modified Multiple Choice ____ cause(s) adjacent rows or columns to have different formatting so that each row or column in the table is distinguished from the surrounding rows or columns.

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

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

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

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

Why is the VLOOKUP function used more often than other lookup functions?

Access: Creating Reports and Forms

Access: Multiple-Table Forms

Access: Advanced Report Techniques

Access: Advanced Form Techniques

Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Excell: Working With Multiple Worksheets and Workbooks

Excell: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots

Outlook : Managing Contacts and Personal Contact Information With Outlook

Powerpoint: Creating and Formatting Information Graphics Question

Powerpoint: Collaborating on and Delivering a Presentation Question

Powerpoint: Navigating Presentations Using Hyperlinks and Action Buttons

Powerpoint: Creating a Self-Running Presentation Containing Animation

Word: Using a Template to Create a Resume and Sharing a Finished Document

Word: Generating Form Letters, Mailing Labels, and a Directory

Word: Creating a Newsletter With a Pull-Quote and Graphics

Filters

Exam 7: Excell: Creating, Sorting, and Querying a Table

Which of the following is the path to the 'Sort & Filter' button?

The path to the Percent Style button is (HOME tab | Editing group).

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

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.

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

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

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

In a table, or database, the data related to each person or item is called a ____.

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.

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

Modified Multiple Choice ____ cause(s) adjacent rows or columns to have different formatting so that each row or column in the table is distinguished from the surrounding rows or columns.

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

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

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

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

Why is the VLOOKUP function used more often than other lookup functions?

Access: Creating Reports and Forms

Access: Multiple-Table Forms

Access: Advanced Report Techniques

Access: Advanced Form Techniques

Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Excell: Working With Multiple Worksheets and Workbooks

Excell: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots

Outlook : Managing Contacts and Personal Contact Information With Outlook

Powerpoint: Creating and Formatting Information Graphics Question

Powerpoint: Collaborating on and Delivering a Presentation Question

Powerpoint: Navigating Presentations Using Hyperlinks and Action Buttons

Powerpoint: Creating a Self-Running Presentation Containing Animation

Word: Using a Template to Create a Resume and Sharing a Finished Document

Word: Generating Form Letters, Mailing Labels, and a Directory

Word: Creating a Newsletter With a Pull-Quote and Graphics

Filters