Question 1

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

Accepted Answer

A) PV 
B) FV 
C) NPV 
D) IPMT 
A) PV 
B) FV 
C) NPV 
D) IPMT

Question 2

When using the MATCH function with an exact match lookup_value,the match type must be set to:

Accepted Answer

A) 1) 
B) 0) 
C) -1. 
D) 2) 
A) 1) 
B) 0) 
C) -1. 
D) 2)

Question 3

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 4

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 5

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 6

Which of the following functions will return the interest payment of a loan?

Accepted Answer

A) CUMPRINC 
B) PMT 
C) PPMT 
D) IPMT 
A) CUMPRINC 
B) PMT 
C) PPMT 
D) IPMT

Question 7

The MATCH type should be set to ________ when matching words with the MATCH function.

Accepted Answer

The answer of The MATCH type should be set to...

Question 8

What is the first 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

Question 9

________ will return the total interest paid within a time range on a loan.

Accepted Answer

The answer of ________ will return the total interest paid...

Question 10

Which of the following is not a function for evaluating multiple conditions with only two possible outcomes?

Accepted Answer

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

Question 11

The MATCH function match_type must be set to 0 when matching words.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

If a nested IF statement has 6 possible outcomes it requires ________ logical tests.

Accepted Answer

A) 6 
B) 5 
C) 0 
D) 7 
A) 6 
B) 5 
C) 0 
D) 7

Question 14

If payments are made at the beginning of the month the type argument should be set to ________ when using the IPMT function

Accepted Answer

The answer of If payments are made at the beginning...

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Match between columns
                        Premises: IPMT
CUMPRINC
Loan amortization
CUMIPMT
PPMT

Accepted Answer

The Answer of Calculates the periodic interest for a specified is...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Which of the following functions will calculate the total interest paid between select periods?

Accepted Answer

A) CUMPRINC 
B) PPMT 
C) IPMT 
D) CUMIPMT 
A) CUMPRINC 
B) PPMT 
C) IPMT 
D) CUMIPMT

Question 20

What is the purpose of an amortization table?

Accepted Answer

An amortization table is a schedule that

Exam 24: Excel: Specialized Functions

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

When using the MATCH function with an exact match lookup_value,the match type must be set to:

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

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

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 will return the interest payment of a loan?

The MATCH type should be set to ________ when matching words with the MATCH function.

What is the first argument of the IF function?

________ will return the total interest paid within a time range on a loan.

Which of the following is not a function for evaluating multiple conditions with only two possible outcomes?

The MATCH function match_type must be set to 0 when matching words.

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

If a nested IF statement has 6 possible outcomes it requires ________ logical tests.

If payments are made at the beginning of the month the type argument should be set to ________ when using the IPMT function

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

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

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

Which of the following functions will calculate the total interest paid between select periods?

What is the purpose of an amortization table?

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

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

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

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

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

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

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

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

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters