Excel Flashcards

1
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
2
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
3
Q

lookup value

A

.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

column index number

A

.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

range lookup

A

.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

make it absolute

A

.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

spark lines

A

.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

name the range

A

.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

pivot tables

A

.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

source data

A

.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

pivot table field list

A

,

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

values

A

only put numerical info

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

contextual tabs

A

,

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

solver

A

.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly