Quiz 1

Question 1

=counta (value 1[value 2])

Answer 1

Count non blank cells

Question 2

To calculate to nearest whole number need to put =round(…..,_____)?

Answer 2

0

Question 3

To calculate to nearest tenth need to put =round(…..,_____)?

Answer 3

1

Question 4

To calculate to nearest hundreth need to put =round(…..,_____)?

Answer 4

2

Question 5

To calculate to nearest tens need to put =round(…..,_____)?

Answer 5

-1

Question 6

To calculate to nearest hundreds need to put =round(…..,_____)?

Answer 6

-2

Question 7

=count(value, [value 2])

Answer 7

Determine the number of cells in a range that contain numbers

Question 8

What does mean?

Answer 8

Not equal to

Question 9

The syntax for countif (s) and sumif (s)

Number?

Answer 9

=countif(C1:C10, 5)

Question 10

The syntax for countif (s) and sumif (s)

Text?

Answer 10

Surround text in quotes

Question 11

The syntax for countif (s) and sumif (s)

Cell reference?

Answer 11

Type in cell reference.

=countif(G1:G10, A2)

Question 12

The syntax for countif (s) and sumif (s)

“Hard coded” Boolean Expression?

Answer 12

Surround Boolean Expression in quotes

=countif(I1:I10,”>=5”)

Question 13

The syntax for countif (s) and sumif (s)

Cell reference Boolean Expression?

Answer 13

Surround Boolean expression in quotes and type & before the cell reference
=countif(k1:k10, “>=”&A5)

Question 14

The syntax for countif (s) and sumif (s)

Wild card?

Answer 14

use asterik

=countif(M1:M10, “USA”*)

Question 15

The s in averageifs, countifs, sumifs, etc mean that?

Answer 15

AVERAGES A RANGE (MULT CRITERIA & MULTIPLE RANGES) all criterion must be true for the cell to be averaged, counted, or summed.

Question 16

When using the rank.eq function and you want the numbers to be in ascending order you put what under order?
=rank.eq(number, ref, [order])?

Answer 16

1

Question 17

When using the rank.eq function and you want the numbers to be in descending order you put what under order?
=rank.eq(number, ref, [order])?

Answer 17

0 or omit it

Question 18

What does the sumproducts function do?

Answer 18

Multiplies corresponding components in the given arrays and returns the sum of those products
-array arguments must be the same dimension

Question 19

Syntax for if functions?

Number?

Answer 19

Type in number

if(B3>=6)

Question 20

Syntax for if function:

For text?

Answer 20

Surround text in quotes

if(B3”USA”,..)

Question 21

Syntax for if function?

Cell reference?

Answer 21

Type in cell reference

=if(B3=B5,…)

Question 22

What does the Nested if function do?

Answer 22

if this is true do this, else if this is true, do this,

Question 23

If you have five letter grade possibilities in the nested if, use ______functions.

Answer 23

four

Question 24

What is the =AND(logical 1, [logical 2], ) used for?

Answer 24

Returns true if all arguments evaluate to true

Question 25

What does the =OR(logical 1, [logical 2]) do?

Answer 25

Returns true if at least one argument evaluates to true

Question 26

What does the =NOT(logical) do?

Answer 26

changes false to true and true to false

Question 27

What combination of functions would be used to determine if none of the students?

Answer 27

NOT(OR(_______))

Question 28

To determine if only which functions are needed?

Answer 28

AND(check if he passedNOT(OR want to make sure no one else did ))

Question 29

To determine if everyone, if all, passed which function?

Answer 29

AND() or IF(AND(())

Question 30

To determine if at least one which function combination?

Answer 30

IF(OR())

Question 31

To determine “if none” which function should be used?

Answer 31

NOT(OR())

Question 32

When using vlookup/hlookup what would putting true as the [range_lookup] do?

Answer 32

finds the exact match or the next lower value in your table array

Question 33

When using vlookup/hlookup what would putting false as the [range_lookup] do?

Answer 33

finds the exact match in your table array

Question 34

What is simple interest?

Answer 34

Always calculates based on original amount

Question 35

What is compound interest?

Answer 35

Always calculates based on latest amount

Question 36

What is present value?

Answer 36

what you get/pay at the beginning of a financial transaction

Question 37

What is future value?

Answer 37

what you are going to get OR what you will have to pay at the end of a financial transaction

Question 38

What is payment?

Answer 38

Payment made each period-it remains constant over life of annuity

Question 39

What is rate?

Answer 39

Interest rate per period

Question 40

What is NPER?

Answer 40

number of payment periods