BAT Chapter 6 Flashcards Preview

jeremy harmon > BAT Chapter 6 > Flashcards

Flashcards in BAT Chapter 6 Deck (15):
1

#Null!

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

2

DCOUNTA

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

3

What is an example of a short date format?

10/14/2019
(Month, Day, Year)

4

Which function is NOT a text function?

MATCH function

5

Ctrl+Shift+Enter

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

6

Forecast Error

Difference between actual amounts and predicted values

7

NPV Function

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

8

REPLACE Function

Replaces old text with new text based on character count

9

EXACT function

Compares 2 things to determine if they are identical

10

Mean Absolute Deviation

Uses absolute value and average to find the standard deviation

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)

-1

12

INDEX Function

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

13

Watch Window

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

14

#VALUE!

Error value indicates that an incorrect data type is used

15

What is NOT true about the NPV function?

Cash flows are present payments or receipts

Decks in jeremy harmon Class (107):