PAPER 2 of notes

Question 1

sum of range

Answer 1

=SUM(range)

Question 2

average of range

Answer 2

=AVERAGE(range)

Question 3

smallest of the range

Answer 3

=MIN(range)

Question 4

biggest of the range

Answer 4

=MAX(range)

Question 5

counting amount of numeric values, not summing up

Answer 5

=COUNT(range)

Question 6

rounding up or down a number

Answer 6

=MROUND(value to be rounded;multiplication)

Question 7

automatically rounds up

Answer 7

=CEILING.MATH(value to be rounded up;multiple)

Question 8

automatically rounds down

Answer 8

=FLOOR.MATH(value to be rounded down; multiple)

Question 9

multiplies all the numbers given as arguments

Answer 9

=PRODUCT(range)

Question 10

the integer portion of a division between two numbers

Answer 10

=QUOTIENT(num;division)

Question 11

power of something

Answer 11

=POWER(number;power)

Question 12

a random number in the range

Answer 12

=RANDBETWEEN(bottom;top)

Question 13

count the text and number, non empty cells

Answer 13

=COUNTA(range)

Question 14

allows you to make logical comparisons between a value and what you expect

Answer 14

=IF(expression; result if true; result if false)

Question 15

checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition.

Answer 15

=IFS(expression;resultiftrue;resultiffalse…)

Question 16

returns TRUE if all its arguments evaluate to TRUE, and returns FALSE if one or more arguments evaluate to FALSE

Answer 16

=AND(….)

Question 17

a logical formula that tests multiple conditions to determine if any of them are true.

Answer 17

=OR(…)