Question 1

If the criteria of an advanced filter is blank no records will be returned.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following functions should be used to evaluate multiple conditions with only two possible outcomes?

Accepted Answer

A) AND 
B) DSUM 
C) IF 
D) DMAX 
A) AND 
B) DSUM 
C) IF 
D) DMAX

Question 3

The database argument of any database function requires the selection of the entire table.

Accepted Answer

A) True 
 B)False

Question 4

A PMT of zero can be used in the FV function.

Accepted Answer

A) True 
 B)False

Question 5

The RATE function returns the periodic rate for an investment or loan.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following logical functions will return a value if false if one of the arguments is false?

Accepted Answer

A) OR 
B) AND 
C) NOT 
D) IF 
A) OR 
B) AND 
C) NOT 
D) IF

Question 7

Which of the following functions does not support multiple conditions?

Accepted Answer

A) AND 
B) OR 
C) MATCH 
D) NOT 
A) AND 
B) OR 
C) MATCH 
D) NOT

Question 8

When using Advanced Filtering empty cells in the criteria range will return which of the following?

Accepted Answer

A) All records 
B) No records 
C) Select records 
D) NA 
A) All records 
B) No records 
C) Select records 
D) NA

Question 9

Which of the following has the ability to restrict data view to only information that fits predetermined criteria?

Accepted Answer

A) VLOOKUP 
B) Advanced Filter 
C) HLOOKUP 
D) INDEX 
A) VLOOKUP 
B) Advanced Filter 
C) HLOOKUP 
D) INDEX

Question 10

Match between columns
                        Premises: AND
NOT
OR
INDEX
IF

Accepted Answer

The Answer of A function to test if no arguments is...

Question 11

The end_period argument should have the value of ________ if you are calculating cumulative interest using CUMIPMT for the third payment of a loan.

Accepted Answer

The answer of The end_period argument should have the value...

Question 12

Which of the following database functions is best suited to add total salaries from a database that are higher than $30,000?

Accepted Answer

A) DMIN 
B) DSUM 
C) DMAX 
D) DCOUNTA 
A) DMIN 
B) DSUM 
C) DMAX 
D) DCOUNTA

Question 13

Match between columns
                        Premises: Database function
DMAX
DAVERAGE
DSUM
DMIN

Accepted Answer

The Answer of Identifies the lowest value in a database is...

Question 14

The criteria range of a database function must contain at least one column heading and one cell of information.

Accepted Answer

A) True 
 B)False

Question 15

Which function will return the total number of periods on a $20000 loan at 5% interest and a $600 payment?

Accepted Answer

A) NPER 
B) RATE 
C) IPMT 
D) PPMT 
A) NPER 
B) RATE 
C) IPMT 
D) PPMT

Question 16

Which of the following functions has the ability to copy all results to a new location?

Accepted Answer

A) DSUM 
B) DMIN 
C) Advanced Filter 
D) IPMT 
A) DSUM 
B) DMIN 
C) Advanced Filter 
D) IPMT

Question 17

________ will return the principal paid on one specific payment of a loan.

Accepted Answer

The answer of ________ will return the principal paid on...

Question 18

Which of the following functions returns the position of a value in a list?

Accepted Answer

A) INDEX 
B) MATCH 
C) VLOOKUP 
D) HLOOKUP 
A) INDEX 
B) MATCH 
C) VLOOKUP 
D) HLOOKUP

Question 19

If no values exist in the logical argument,the AND function returns the #VALUE! error.

Accepted Answer

A) True 
 B)False

Question 20

What is the second argument of the IF function?

Accepted Answer

A) Value_if_false 
B) Value_if_true 
C) logical_test 
D) lookup_value 
A) Value_if_false 
B) Value_if_true 
C) logical_test 
D) lookup_value

Exam 21: Specialized Functions

If the criteria of an advanced filter is blank no records will be returned.

Which of the following functions should be used to evaluate multiple conditions with only two possible outcomes?

The database argument of any database function requires the selection of the entire table.

A PMT of zero can be used in the FV function.

The RATE function returns the periodic rate for an investment or loan.

Which of the following logical functions will return a value if false if one of the arguments is false?

Which of the following functions does not support multiple conditions?

When using Advanced Filtering empty cells in the criteria range will return which of the following?

Which of the following has the ability to restrict data view to only information that fits predetermined criteria?

The end_period argument should have the value of ________ if you are calculating cumulative interest using CUMIPMT for the third payment of a loan.

Which of the following database functions is best suited to add total salaries from a database that are higher than $30,000?

The criteria range of a database function must contain at least one column heading and one cell of information.

Which function will return the total number of periods on a $20000 loan at 5% interest and a $600 payment?

Which of the following functions has the ability to copy all results to a new location?

________ will return the principal paid on one specific payment of a loan.

Which of the following functions returns the position of a value in a list?

If no values exist in the logical argument,the AND function returns the #VALUE! error.

What is the second argument of the IF function?

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates styles and Macros

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters