Match between columns Premises: NOT OR Nested function IF AND

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

Match between columns Premises: PPMT CUMPRINC Loan amortization CUMIPMT IPMT

The Answer of Calculates the principal payment for a specified is...

Match between columns Premises: RATE NPV FV PV NPER

The Answer of Calculates the number of payment periods for is...

Exam 21: Specialized Functions

The FV function is best suited for calculating the current value of an investment.

Free

(True/False)

4.7/5

(38)

Question 1

Correct Answer:

Verified

False

PPMT should be used to calculate the specific interest paid on one installment of a loan.

Free

(True/False)

4.9/5

(29)

Question 2

Correct Answer:

Verified

False

________ will return the interest paid for one installment of a loan.

Free

(Short Answer)

4.8/5

(36)

Question 3

Correct Answer:

Verified

IPMT

Which of the following is a nested function?

(Multiple Choice)

4.8/5

(35)

Question 4

=IF(E5<J7,F5K7,IF(E5<=J8,F5K8,F5*K9))is an example of a(n):

(Multiple Choice)

4.8/5

(36)

Question 5

The MATCH function can be used to match words.

(True/False)

4.9/5

(47)

Question 6

The NPER function would be best used to determine the periodic interest rate of an investment.

(True/False)

4.8/5

(37)

Question 7

The ________ function is best suited when two or more logical tests are required and at least one condition must be true to return the value_if_true.

(Short Answer)

4.9/5

(36)

Question 8

Match the following terms with the corresponding description.

NOT

A function to test if no arguments are met

OR

A function to test to see if multiple conditions are met

Nested function

A function that tests if one argument is met

Correct Answer:

Verified

NOT

OR

Nested function

IF

AND

(Matching)

4.8/5

(32)

Question 9

Match the following terms with the corresponding description.

PPMT

Calculates the principal payment for a specified payment period on a loan or an investment given a fixed interest rate,term,and periodic payments

CUMPRINC

Calculates the cumulative interest throughout a loan amortization table

Loan amortization

A schedule that calculates the interest,principal repayment,and remaining balance

Correct Answer:

Verified

PPMT

CUMPRINC

Loan amortization

CUMIPMT

IPMT

(Matching)

4.7/5

(36)

Question 10

The ________ function will only trigger the value_if_true if all conditions given are false.

(Short Answer)

4.7/5

(29)

Question 11

In order for the AND function to return a true value,all arguments must be true.

(True/False)

4.8/5

(31)

Question 12

Which function will calculate the final value of an investment of $100 a month that earns 4% interest over 5 years?

(Multiple Choice)

4.8/5

(34)

Question 13

In order for the NOT function to return a true value,all arguments must be false.

(True/False)

4.7/5

(32)

Question 14

The CUMPRINC function requires both starting and ending evaluation dates.

(True/False)

4.7/5

(26)

Question 15

If an IF statement has four outcomes,it will require three logical tests.

(True/False)

4.8/5

(34)

Question 16

Match the following terms with the corresponding description.

RATE

Calculates the number of payment periods for an investment or loan given a fixed interest rate,periodic payment,and present value.

NPV

Calculates the future value of an investment,given a fixed interest rate,term,and periodic payment

FV

Calculates the net present value of an investment,given a fixed discount rate (rate of return)and a set of given cash inflows

Correct Answer:

Verified

RATE

NPV

FV

PV

NPER

(Matching)

4.8/5

(27)

Question 17

Which of the following calculates the net present value of an investment,given a fixed discount rate?

(Multiple Choice)

4.8/5

(30)

Question 18

Which database function will return the largest value from a dataset based on preset criteria?

(Multiple Choice)

4.8/5

(33)

Question 19

When using Advanced Filtering < > is the equivalent of:

(Multiple Choice)

4.8/5

(40)

Question 20

Exam 21: Specialized Functions

The FV function is best suited for calculating the current value of an investment.

PPMT should be used to calculate the specific interest paid on one installment of a loan.

________ will return the interest paid for one installment of a loan.

Which of the following is a nested function?

=IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9))is an example of a(n):

The MATCH function can be used to match words.

The NPER function would be best used to determine the periodic interest rate of an investment.

The ________ function is best suited when two or more logical tests are required and at least one condition must be true to return the value_if_true.

The ________ function will only trigger the value_if_true if all conditions given are false.

In order for the AND function to return a true value,all arguments must be true.

Which function will calculate the final value of an investment of $100 a month that earns 4% interest over 5 years?

In order for the NOT function to return a true value,all arguments must be false.

The CUMPRINC function requires both starting and ending evaluation dates.

If an IF statement has four outcomes,it will require three logical tests.

Which of the following calculates the net present value of an investment,given a fixed discount rate?

Which database function will return the largest value from a dataset based on preset criteria?

When using Advanced Filtering < > is the equivalent of:

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

=IF(E5<J7,F5K7,IF(E5<=J8,F5K8,F5*K9))is an example of a(n):