Question 1

Match between columns
                        Premises: DSTDEV
DMIN
DSUM
DAVERAGE
DMAX

Accepted Answer

The Answer of Calculates the difference from the median and is...

Question 2

An empty cell in the criteria in an Advanced Filter will display no records.

Accepted Answer

A) True 
 B)False  False

Question 3

Why would you put a negative sign in many financial functions?

Accepted Answer

A) Excel requires a negative interest rate. 
B) Excel interprets these calculations as a negative cash flow (money leaving your account). 
C) Excel uses negatives for all financial functions. 
D) Excel doesn't differentiate between income and outflow. 
A) Excel requires a negative interest rate. 
B) Excel interprets these calculations as a negative cash flow (money leaving your account). 
C) Excel uses negatives for all financial functions. 
D) Excel doesn't differentiate between income and outflow. B

Question 4

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 5

If 9/3/2021 is the contents of B3, what would be the result of =MONTH(B3)?

Accepted Answer

A) 44442 
B) September 
C) 9/30/2021 
D) 9 
A) 44442 
B) September 
C) 9/30/2021 
D) 9

Question 6

A(n)________is a matrix that provides the results (TRUE or FALSE)for every possibility of an AND, OR, or NOT criteria combination.

Accepted Answer

A) AND/OR/NOT tool 
B) truth table 
C) goal table 
D) evaluation matrix 
A) AND/OR/NOT tool 
B) truth table 
C) goal table 
D) evaluation matrix

Question 7

Database functions do not require a Criteria Range.

Accepted Answer

A) True 
 B)False

Question 8

In database functions, , >, =, = and <= are called ________.

Accepted Answer

relational

Question 9

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 10

Which function returns a value at the intersection of a specified row and column?

Accepted Answer

A) MATCH 
B) INDEX 
C) VLOOKUP 
D) IF 
A) MATCH 
B) INDEX 
C) VLOOKUP 
D) IF

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

A(n)________ is a schedule that calculates the interest, principal repayment, and remaining balance of a loan.

Accepted Answer

The answer of A(n)________ is a schedule that calculates the...

Question 13

The ________ function calculates the total number of periods in a loan.

Accepted Answer

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

Question 14

Match between columns
                        Premises: DAY
YEARFRAC
DAYS
YEAR
MONTH

Accepted Answer

The Answer of Returns the day of the month for is...

Question 15

NPER calculates the periodic interest rate of an investment or loan.

Accepted Answer

A) True 
 B)False

Question 16

Which function calculates the Reduction in C2 to be filled through the rest of the reduction column if silver members have a 5% discount, gold 10% and Platinum have 20%?

Accepted Answer

A) =IF(A2="Silver",B2*0.05,IF(A2="Gold",B2*0.1,B2*0.2)) 
B) =IF(A2="Silver",B2*0.1,B2*0.2) 
C) =IF(A2="Silver" B2*0.05,OR(A2="Gold",B2*0.1,OR(B2*0.2)) 
D) ==IF(A2="Silver",B2*0.05,IF(A2="Gold",Platinum=B2*0.1,B2*0.2))) 
A) =IF(A2="Silver",B2*0.05,IF(A2="Gold",B2*0.1,B2*0.2)) 
B) =IF(A2="Silver",B2*0.1,B2*0.2) 
C) =IF(A2="Silver" B2*0.05,OR(A2="Gold",B2*0.1,OR(B2*0.2)) 
D) ==IF(A2="Silver",B2*0.05,IF(A2="Gold",Platinum=B2*0.1,B2*0.2)))

Question 17

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 18

A(n)________ is a schedule that calculates the interest per payment period, principal, repayment, and remaining balance.

Accepted Answer

A) database 
B) financial function 
C) IPMT function 
D) loan amortization table 
A) database 
B) financial function 
C) IPMT function 
D) loan amortization table

Question 19

The criteria range must contain ________ at least rows in Advanced Filtering.

Accepted Answer

The answer of The criteria range must contain ________ at...

Question 20

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

Accepted Answer

The Answer of Greater than and Less than and Not is...

An empty cell in the criteria in an Advanced Filter will display no records.

Why would you put a negative sign in many financial functions?

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

If 9/3/2021 is the contents of B3, what would be the result of =MONTH(B3)?

A(n)________is a matrix that provides the results (TRUE or FALSE)for every possibility of an AND, OR, or NOT criteria combination.

Database functions do not require a Criteria Range.

In database functions, <>, >, =, <, >= and <= are called ________.

The advanced filter tool can ________.

Which function returns a value at the intersection of a specified row and column?

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

A(n)________ is a schedule that calculates the interest, principal repayment, and remaining balance of a loan.

The ________ function calculates the total number of periods in a loan.

NPER calculates the periodic interest rate of an investment or loan.

Which function calculates the Reduction in C2 to be filled through the rest of the reduction column if silver members have a 5% discount, gold 10% and Platinum have 20%?

Why would you nest MATCH in an INDEX function?

A(n)________ is a schedule that calculates the interest per payment period, principal, repayment, and remaining balance.

The criteria range must contain ________ at least rows in Advanced Filtering.

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

An empty cell in the criteria in an Advanced Filter will display no records.

Why would you put a negative sign in many financial functions?

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

If 9/3/2021 is the contents of B3, what would be the result of =MONTH(B3)?

A(n)________is a matrix that provides the results (TRUE or FALSE)for every possibility of an AND, OR, or NOT criteria combination.

Database functions do not require a Criteria Range.

In database functions, <>, >, =, <, >= and <= are called ________.

The advanced filter tool can ________.

Which function returns a value at the intersection of a specified row and column?

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

A(n)________ is a schedule that calculates the interest, principal repayment, and remaining balance of a loan.

The ________ function calculates the total number of periods in a loan.

NPER calculates the periodic interest rate of an investment or loan.

Which function calculates the Reduction in C2 to be filled through the rest of the reduction column if silver members have a 5% discount, gold 10% and Platinum have 20%?

Why would you nest MATCH in an INDEX function?

A(n)________ is a schedule that calculates the interest per payment period, principal, repayment, and remaining balance.

The criteria range must contain ________ at least rows in Advanced Filtering.

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