Excel Flashcards by Paul McGinnis

Q

Nper

A

the total number of payments for the loan

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

table array

A

must be sorted in ascending order

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

lookup value

A

.

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

column index number

A

.

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

range lookup

A

.

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

make it absolute

A

.

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

spark lines

A

.

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

name the range

A

.

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

pivot tables

A

.

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

source data

A

.

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

pivot table field list

A

,

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

values

A

only put numerical info

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

contextual tabs

A

,

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

solver

A

.

How well did you know this?

1

Not at all

2

3

4

5

Perfectly