Exam 17: Specialized Functions: Hands On Exercise Videos

CUMIPMT and CUMPRINC are lookup functions.

Free

(True/False)

4.9/5

(36)

Question 1

Correct Answer:

Verified

False

You would use the ________ function to return the position of a value in a list.

Free

(Multiple Choice)

4.8/5

(39)

Question 2

Correct Answer:

Verified

The ________ function results in a TRUE value only if all conditions are true.

Free

(Multiple Choice)

4.8/5

(25)

Question 3

Correct Answer:

Verified

Which of the following functions would NOT be used to construct an amortization table?

(Multiple Choice)

4.9/5

(36)

Question 4

DMIN is a database function.

(True/False)

4.9/5

(42)

Question 5

A loan amortization table is a schedule that shows the interest,principal repayment,and remaining balance.

(True/False)

4.8/5

(37)

Question 6

Knowing the interest rate,number of payments,and the monthly payments,you would use the ________ function to determine the amount of a loan.

(Multiple Choice)

4.8/5

(28)

Question 7

When constructing an advanced filter,the ________ range is a range of cells containing the filter conditions.

(Multiple Choice)

4.9/5

(37)

Question 8

IF and AND are examples of ________ functions.

(Multiple Choice)

4.8/5

(27)

Question 9

=IF(AND(D7="manager",F7<F$3),"Due for raise","NA")is an example of a compound function.

(True/False)

4.7/5

(40)

Question 10

Entering an IF in the Value_if_true box or in the Value_if_false box,creates a(n)________ function.

(Multiple Choice)

4.7/5

(30)

Question 11

The criteria range is a range of cells that specifies the conditions used to filter a table.

(True/False)

4.8/5

(35)

Question 12

Which of the following is NOT a database function?

(Multiple Choice)

4.8/5

(37)

Question 13

Which of the following is NOT a financial function?

(Multiple Choice)

4.9/5

(42)

Question 14

MATCH and INDEX are logical functions.

(True/False)

4.9/5

(34)

Question 15

When a loan is repaid,the total principal matches the ________ for the final payment.

(Multiple Choice)

4.8/5

(29)

Question 16

Showing 1 - 16 of 16

Exam 17: Specialized Functions: Hands On Exercise Videos

CUMIPMT and CUMPRINC are lookup functions.

You would use the ________ function to return the position of a value in a list.

The ________ function results in a TRUE value only if all conditions are true.

Which of the following functions would NOT be used to construct an amortization table?

DMIN is a database function.

A loan amortization table is a schedule that shows the interest,principal repayment,and remaining balance.

Knowing the interest rate,number of payments,and the monthly payments,you would use the ________ function to determine the amount of a loan.

When constructing an advanced filter,the ________ range is a range of cells containing the filter conditions.

IF and AND are examples of ________ functions.

=IF(AND(D7="manager",F7<F$3),"Due for raise","NA")is an example of a compound function.

Entering an IF in the Value_if_true box or in the Value_if_false box,creates a(n)________ function.

The criteria range is a range of cells that specifies the conditions used to filter a table.

Which of the following is NOT a database function?

Which of the following is NOT a financial function?

MATCH and INDEX are logical functions.

When a loan is repaid,the total principal matches the ________ for the final payment.

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

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

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