Chapter Six

Question 1

What provides a convenient way to monitor changes in formulas when you work in large worksheets or with multiple sheets?

Answer 1

Watch Window

Question 2

What is NOT a TEXT function?
EXACT
CONCAT
MATCH
TEXTJOIN

Answer 2

MATCH

Question 3

In a database function, what does the field argument reference?

Answer 3

column to be used in the calculation

Question 4

What calculates where a particular value appears in the dataset?

Answer 4

RANK.EQ

Question 5

In a SUMIFS formula, what is the maximum number of criteria_rangeN argument?

Answer 5

127

Question 6

What is true when using the NPV function?

Answer 6

for a year with neither a positive or negative cash flow type a zero for the ValueN argument, cash flow amounts can be negative or positive, the NPV function has two required arguments

Question 7

What error value indicates that a value or an argument is missing?

Answer 7

N/A

Question 8

In OR functions and AND functions, how many LogicalN arguments can you use?

Answer 8

255