BAT Chapter 6

Question 1

Null!

Answer 1

Error value that indicates the formula refers to an intersection of 2 cell ranges that do not intersect

Question 2

DCOUNTA

Answer 2

Database function counts cells in the fields that are not empty that meets criteria

Question 3

What is an example of a short date format?

Answer 3

10/14/2019

Month, Day, Year

Question 4

Which function is NOT a text function?

Answer 4

MATCH function

Question 5

Ctrl+Shift+Enter

Answer 5

Keystrokes that are considered completion keys when executing functions as array formulas

Question 6

Forecast Error

Answer 6

Difference between actual amounts and predicted values

Question 7

NPV Function

Answer 7

Finds the net present value using positive and negative cash flows at the end of the period

Question 8

REPLACE Function

Answer 8

Replaces old text with new text based on character count

Question 9

EXACT function

Answer 9

Compares 2 things to determine if they are identical

Question 10

Mean Absolute Deviation

Answer 10

Uses absolute value and average to find the standard deviation

Question 11

In the MATCH function, which of the following match type arguments finds the smallest value that is greater than or equal to the look up value? (A number)

Answer 11

-1

Question 12

INDEX Function

Answer 12

Displays the contents of the cell at the intersection of specified column and row

Question 13

Watch Window

Answer 13

Way to monitor changes in formulas when you work in large worksheets or multiple sheets

Question 14

VALUE!

Answer 14

Error value indicates that an incorrect data type is used

Question 15

What is NOT true about the NPV function?

Answer 15

Cash flows are present payments or receipts