Question 1

Which of these functions does not support multiple conditions?

Accepted Answer

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

Question 2

When formated as a date, the results of EDATE(Start_Date,3)if the contents of Start_Date is 10/30/2018 would be ________.

Accepted Answer

A) 11/2/2018 
B) 1/31/2019 
C) 1/30/2019 
D) 10/31/2018 
A) 11/2/2018 
B) 1/31/2019 
C) 1/30/2019 
D) 10/31/2018

Question 3

The MONTH function would return 25 when used on a cell containing August 25, 2018.

Accepted Answer

A) True 
 B)False

Question 4

A NOT function reverses the truth of a logical test.

Accepted Answer

A) True 
 B)False

Question 5

The ________ function calculates cumulative principal through a specified payment period.

Accepted Answer

The answer of The ________ function calculates cumulative principal through...

Question 6

The YEAR function would return ________ on the value December 27, 2025.

Accepted Answer

The answer of The YEAR function would return ________ on...

Question 7

Match between columns
                        Premises: NPER
FV
RATE
NPV
PV

Accepted Answer

The Answer of Calculates the periodic rate for an investment is...

Question 8

Which function would calculate a final value of an investment of $250 per month for 5 years at 4% interest?

Accepted Answer

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

Question 9

The DCOUNTA function returns an error if it encounters a blank record.

Accepted Answer

A) True 
 B)False

Question 10

The ________ function calculates the periodic interest for a specified payment period on a loan or an investment.

Accepted Answer

The answer of The ________ function calculates the periodic interest...

Question 11

Which function calculates the total amount of interest paid over a specific number of payments?

Accepted Answer

A) CUMPMT 
B) IPMT 
C) CUMIPMT 
D) PMT 
A) CUMPMT 
B) IPMT 
C) CUMIPMT 
D) PMT

Question 12

Which of the following is not an argument in a Database function?

Accepted Answer

A) Database 
B) Criteria 
C) Filter 
D) Field 
A) Database 
B) Criteria 
C) Filter 
D) Field

Question 13

What effect does paying an extra small bit of principal on a mortgage have on the life of a 30 year loan?

Accepted Answer

A) It has no impact on amount of interest paid but shortens the length of the loan. 
B) It saves money in interest and shortens the length of the loan. 
C) It increases the amount of interest paid and lengthens the length of the loan. 
D) It has no impact on either interest or life span of the loan. 
A) It has no impact on amount of interest paid but shortens the length of the loan. 
B) It saves money in interest and shortens the length of the loan. 
C) It increases the amount of interest paid and lengthens the length of the loan. 
D) It has no impact on either interest or life span of the loan.

Question 14

The EOMONTH function returns the last day of the month of the specified number of months from a given date.

Accepted Answer

A) True 
 B)False

Question 15

Which database function returns the lowest value from the dataset based on your criteria?

Accepted Answer

A) DMIN 
B) DMAX 
C) DLEAST 
D) DCOUNT 
A) DMIN 
B) DMAX 
C) DLEAST 
D) DCOUNT

Question 16

A(n)________ is a group of two or more adjacent cells that specifies the conditions used to control the results of a filter.

Accepted Answer

The answer of A(n)________ is a group of two or...

Question 17

The YEARFRAC calculates ________.

Accepted Answer

A) the year 2018 from a date 
B) the number of years between two dates 
C) the serial number of the year 
D) the fraction of a year in days between two dates 
A) the year 2018 from a date 
B) the number of years between two dates 
C) the serial number of the year 
D) the fraction of a year in days between two dates

Question 18

You can nest AND, OR and NOT functions in an IF function.

Accepted Answer

A) True 
 B)False

Question 19

The ________ function calculates the periodic interest rate of a loan or investment.

Accepted Answer

The answer of The ________ function calculates the periodic interest...

Question 20

When using advanced filtering, leaving a cell empty in the criteria range will return which of the following?

Accepted Answer

A) All records 
B) No records 
C) Empty records 
D) #N/A 
A) All records 
B) No records 
C) Empty records 
D) #N/A

Which of these functions does not support multiple conditions?

When formated as a date, the results of EDATE(Start_Date,3)if the contents of Start_Date is 10/30/2018 would be ________.

The MONTH function would return 25 when used on a cell containing August 25, 2018.

A NOT function reverses the truth of a logical test.

The ________ function calculates cumulative principal through a specified payment period.

The YEAR function would return ________ on the value December 27, 2025.

Which function would calculate a final value of an investment of $250 per month for 5 years at 4% interest?

The DCOUNTA function returns an error if it encounters a blank record.

The ________ function calculates the periodic interest for a specified payment period on a loan or an investment.

Which function calculates the total amount of interest paid over a specific number of payments?

Which of the following is not an argument in a Database function?

What effect does paying an extra small bit of principal on a mortgage have on the life of a 30 year loan?

The EOMONTH function returns the last day of the month of the specified number of months from a given date.

Which database function returns the lowest value from the dataset based on your criteria?

A(n)________ is a group of two or more adjacent cells that specifies the conditions used to control the results of a filter.

The YEARFRAC calculates ________.

You can nest AND, OR and NOT functions in an IF function.

The ________ function calculates the periodic interest rate of a loan or investment.

When using advanced filtering, leaving a cell empty in the criteria range will return which of the following?

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters

Exam 7: Specialized Functions

Which of these functions does not support multiple conditions?

When formated as a date, the results of EDATE(Start_Date,3)if the contents of Start_Date is 10/30/2018 would be ________.

The MONTH function would return 25 when used on a cell containing August 25, 2018.

A NOT function reverses the truth of a logical test.

The ________ function calculates cumulative principal through a specified payment period.

The YEAR function would return ________ on the value December 27, 2025.

Which function would calculate a final value of an investment of $250 per month for 5 years at 4% interest?

The DCOUNTA function returns an error if it encounters a blank record.

The ________ function calculates the periodic interest for a specified payment period on a loan or an investment.

Which function calculates the total amount of interest paid over a specific number of payments?

Which of the following is not an argument in a Database function?

What effect does paying an extra small bit of principal on a mortgage have on the life of a 30 year loan?

The EOMONTH function returns the last day of the month of the specified number of months from a given date.

Which database function returns the lowest value from the dataset based on your criteria?

A(n)________ is a group of two or more adjacent cells that specifies the conditions used to control the results of a filter.

The YEARFRAC calculates ________.

You can nest AND, OR and NOT functions in an IF function.

The ________ function calculates the periodic interest rate of a loan or investment.

When using advanced filtering, leaving a cell empty in the criteria range will return which of the following?

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters