Question 1

What best describes a criteria range?

Accepted Answer

A) The table upon which a filter is applied 
B) The group of adjacent cells that specifies the conditions used to control the results of a filter 
C) The filtered range of cells 
D) The copied range of cells 
A) The table upon which a filter is applied 
B) The group of adjacent cells that specifies the conditions used to control the results of a filter 
C) The filtered range of cells 
D) The copied range of cells

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

If you need to find out how many days between two dates,which function would you use?

Accepted Answer

A) DAY 
B) DAYS 
C) DAYSBETWEEN 
D) EDATE 
A) DAY 
B) DAYS 
C) DAYSBETWEEN 
D) EDATE

Question 4

DSTDEV calculates the standard deviation of a sample population in a database range.

Accepted Answer

A) True 
 B)False

Question 5

The real functionality of MATCH and INDEX functions comes from nesting them.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

If you need to find the day of the month on which events occurred from a list of dates in the named range of Start_Date,which formula would provide the correct result?

Accepted Answer

A) =DAYS(End_Date,Start_Date) 
B) =DAYMONTH(Start_Date) 
C) =IF(DAYMONTH(Start_Date)<31,Start_Date,1) 
D) =DAY(Start_Date) 
A) =DAYS(End_Date,Start_Date) 
B) =DAYMONTH(Start_Date) 
C) =IF(DAYMONTH(Start_Date)<31,Start_Date,1) 
D) =DAY(Start_Date)

Question 8

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

Accepted Answer

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

Question 9

Why would you nest MATCH in an INDEX function?

Accepted Answer

A) To handle multiple outcomes 
B) To find the highest or lowest value in an array 
C) To use the position returned in the Match function as an argument in the index function 
D) To use the value returned in the Match function as a lookup in the index function 
A) To handle multiple outcomes 
B) To find the highest or lowest value in an array 
C) To use the position returned in the Match function as an argument in the index function 
D) To use the value returned in the Match function as a lookup in the index function

Question 10

The NPV function is used mostly to calculate return rates for IRAs.

Accepted Answer

A) True 
 B)False

Question 11

The ________ function calculates the principal payment for a specified period on a loan or investment.

Accepted Answer

The answer of The ________ function calculates the principal payment...

Question 12

The advanced filter tool can ________.

Accepted Answer

A) delete duplicate records 
B) search for unique records,only 
C) not filter multiple arrays 
D) filter a limit of 256 rows 
A) delete duplicate records 
B) search for unique records,only 
C) not filter multiple arrays 
D) filter a limit of 256 rows

Question 13

You need the same number of logical tests as outcomes in a nested IF function.

Accepted Answer

A) True 
 B)False

Question 14

Which is the Array argument in =INDEX(A2:
B5,MATCH(MAX(B2:
B5),B2:
B5,0),1)?

Accepted Answer

A) MAX(B2:B5) 
B) MATCH(MAX(B2:B5),B2:B5,0) 
C) 1 
D) A2:B5 
A) MAX(B2:B5) 
B) MATCH(MAX(B2:B5),B2:B5,0) 
C) 1 
D) A2:B5

Question 15

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

Accepted Answer

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

Question 16

What is a nested function?

Accepted Answer

A) A function with more than one argument 
B) Any IF function 
C) A function with more than two arguments 
D) A function embedded within an argument of another function 
A) A function with more than one argument 
B) Any IF function 
C) A function with more than two arguments 
D) A function embedded within an argument of another function

Question 17

What is  equivalent to in Advanced Filters?

Accepted Answer

A) Equal to 
B) Not equal to 
C) Greater than 
D) Less than 
A) Equal to 
B) Not equal to 
C) Greater than 
D) Less than

Question 18

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

Accepted Answer

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

Question 19

Match between columns Premises: < >= <> > <=

Accepted Answer

The Answer of Greater than or equal to and Not is...

Question 20

Which financial function calculates the number of payment periods for an investment or loan given fixed interest rate,periodic payment,and present value?

Accepted Answer

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

What best describes a criteria range?

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

If you need to find out how many days between two dates,which function would you use?

DSTDEV calculates the standard deviation of a sample population in a database range.

The real functionality of MATCH and INDEX functions comes from nesting them.

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

If you need to find the day of the month on which events occurred from a list of dates in the named range of Start_Date,which formula would provide the correct result?

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

Why would you nest MATCH in an INDEX function?

The NPV function is used mostly to calculate return rates for IRAs.

The ________ function calculates the principal payment for a specified period on a loan or investment.

The advanced filter tool can ________.

You need the same number of logical tests as outcomes in a nested IF function.

Which is the Array argument in =INDEX(A2: B5,MATCH(MAX(B2: B5),B2: B5,0),1)?

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

What is a nested function?

What is < > equivalent to in Advanced Filters?

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

Which financial function calculates the number of payment periods for an investment or loan given fixed interest rate,periodic payment,and present value?

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Statistical Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters

Exam 7: Specialized Functions

What best describes a criteria range?

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

If you need to find out how many days between two dates,which function would you use?

DSTDEV calculates the standard deviation of a sample population in a database range.

The real functionality of MATCH and INDEX functions comes from nesting them.

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

If you need to find the day of the month on which events occurred from a list of dates in the named range of Start_Date,which formula would provide the correct result?

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

Why would you nest MATCH in an INDEX function?

The NPV function is used mostly to calculate return rates for IRAs.

The ________ function calculates the principal payment for a specified period on a loan or investment.

The advanced filter tool can ________.

You need the same number of logical tests as outcomes in a nested IF function.

Which is the Array argument in =INDEX(A2: B5,MATCH(MAX(B2: B5),B2: B5,0),1)?

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

What is a nested function?

What is < > equivalent to in Advanced Filters?

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

Which financial function calculates the number of payment periods for an investment or loan given fixed interest rate,periodic payment,and present value?

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Statistical Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters