2.) Which is not found in a vlookup statement?

Logical Check

Lookup Field

Lookup Table

Return Column

3.) What type of formatting is completed based on a certain criteria/conditions being met?

Conditional Formatting

Bold Formatting

Color Formatting

Criteria Formatting

4.) In a 2 variable data table, which cell location is the formula found?

Northwest Corner

Southwest Corner

Northeast Corner

Southeast Corner

5.) If instructed to create a 1 variable data table using a column input cell starting in cell A5, which cell is the first variable found in?

A6

A5

B5

B6

6.) If instructed to create a 1 variable data table using a column input cell starting in cell A5, which cell is the first formula found in?

B5

A5

B6

A6

7.) How many ifs are found in a nested if statement with 7 outcomes possible?

6

5

7

8

8.) In a vlookup function, which column in the lookup table is the lookup value compared to when the table has 4 columns?

1

2

3

4

9.) In the following formula, which is referring to the rate?

=-PMT(K13/12,K14*12,K15)

K13/12

-PMT

K14*12

K15

10.) In the following formula, which is referring to the principle value of the loan?

=-PMT(K13/12,K14*12,K15)

K15

-PMT

K13/12

K14*12

11.) If instructed to Sort a database by Last Name in Ascending Order, how many levels are used in this sort?

1

2

3

4

12.) What function is used to Average a certain field found in a database?

DAVERAGE

DSUM

AVERAGE

SUM

13.) What function is used to find the largest value in a database field based on certain criteria?

DMAX

SUM

MAX

DSUM

14.) How many ifs are used in a nested if in which there are 5 outcomes?

4

2

3

5

15.) In the following OR statement, what is the minimum that have to be correct to be TRUE?

=OR(A1>1,A2<5.A3=10,A4<20)

1

2

3

4