Question 1

Advanced filtering will not copy results to a new location.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Which of the following are not arguments for the IPMT function?

Accepted Answer

A) Rate 
B) Per 
C) Collection 
D) Nper 
A) Rate 
B) Per 
C) Collection 
D) Nper

Question 4

The ________ function calculates the total future value.

Accepted Answer

The answer of The ________ function calculates the total future...

Question 5

What is the purpose of an Excel What-if scenario?

Accepted Answer

A) A two-variable goal seek tool 
B) Any what-if analysis 
C) A tool that changes one variable through several iterations 
D) Detailed set of values that represent different possible situations 
A) A two-variable goal seek tool 
B) Any what-if analysis 
C) A tool that changes one variable through several iterations 
D) Detailed set of values that represent different possible situations

Question 6

Match between columns
                        Premises: IF
INDEX
DCOUNT
IPMT
YEARFRAC

Accepted Answer

The Answer of Logical and Database and Financial and Date is...

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

An INDEX function returns the position of a value.

Accepted Answer

A) True 
 B)False

Question 9

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 10

What is the purpose of the Row_num argument in the following INDEX function? 
=INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1)

Accepted Answer

A) To return the highest value in the range B2:B5 
B) To return the position of the highest value in the range B2:B5 
C) To return the column to the left of the highest values in the range B2:B5 
D) To return the row of the highest value in the range B2:B5 
A) To return the highest value in the range B2:B5 
B) To return the position of the highest value in the range B2:B5 
C) To return the column to the left of the highest values in the range B2:B5 
D) To return the row of the highest value in the range B2:B5

Question 11

Which financial function 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 12

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 13

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 14

The YEARFRAC function returns the number of the month in a year.

Accepted Answer

A) True 
 B)False

Question 15

A MATCH function returns the value of a given position.

Accepted Answer

A) True 
 B)False

Question 16

An OR function evaluates to TRUE only if all of the conditions are true.

Accepted Answer

A) True 
 B)False

Question 17

A Truth Table is a matrix that provides true or false for every possible combination for an OR, NOT, or AND criteria combination.

Accepted Answer

A) True 
 B)False

Question 18

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 19

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

Question 20

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

Advanced filtering will not copy results to a new location.

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

Which of the following are not arguments for the IPMT function?

The ________ function calculates the total future value.

What is the purpose of an Excel What-if scenario?

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?

An INDEX function returns the position of a value.

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

What is the purpose of the Row_num argument in the following INDEX function? =INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1)

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

What best describes a criteria range?

What is < > equivalent to in Advanced Filters?

The YEARFRAC function returns the number of the month in a year.

A MATCH function returns the value of a given position.

An OR function evaluates to TRUE only if all of the conditions are true.

A Truth Table is a matrix that provides true or false for every possible combination for an OR, NOT, or AND criteria combination.

What is a nested function?

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

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

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

Advanced filtering will not copy results to a new location.

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

Which of the following are not arguments for the IPMT function?

The ________ function calculates the total future value.

What is the purpose of an Excel What-if scenario?

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?

An INDEX function returns the position of a value.

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

What is the purpose of the Row_num argument in the following INDEX function? =INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1)

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

What best describes a criteria range?

What is < > equivalent to in Advanced Filters?

The YEARFRAC function returns the number of the month in a year.

A MATCH function returns the value of a given position.

An OR function evaluates to TRUE only if all of the conditions are true.

A Truth Table is a matrix that provides true or false for every possible combination for an OR, NOT, or AND criteria combination.

What is a nested function?

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

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

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