nature philo Flashcards

1
Q

relative reference

A

=B2

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

absolute reference

A

=$B$2

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

absolute column reference

A

=$B2

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

absolute row reference

A

=B$2

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

Sum

A

=SUM(range)

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

product

A

=PRODUCT(range)

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

square root

A

=SQRT(number)

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

exponantial

A

=EXP(number)

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

logarithms

A

=LN(number)

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

COUNT

A

a count if the cells containing numbers in a dataset
=COUNT(range)

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

count the number of non-blank cells in a dataset

A

=COUNTA(range)

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

smallest value

A

=MIN(range)

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

largest value

A

=MAX(range)

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

k-th smallest value

A

=SMALL(range, k)

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

k-th largest value

A

=LARGE(range, k)

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

average value

A

=AVERAGE(range)

17
Q

the median value, half the numbers are smaller and half are larger than this value

A

=MEDIAN(range)

18
Q

the variance, a measure of hwo spread out the data is

A

=VAR.S(range)

19
Q

the standard deviation, a measure of how spread out the data is

A

=STEDV.S(range)

20
Q

count the number of empty cells in a range of cells

A

=COUNTBLANK(range)

21
Q

count the number of cells that meet a criterion

A

=COUNTIF(range, criteria)

22
Q

applies criteria to cells across multiple ranges and counts the number of times all criteria are met

A

=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ….)

23
Q

adds all of its arguments that meet mutliple criteria

A

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2]…)

24
Q

returns the average of all the cells in a range that meets a given criteria

A

=AVERAGEIF(range, criteria, [average_range)

25
returns a list of unqiue values in a list of storage
=UNIQUE(array, [by_col], [exactly_once]) by_col: TRUE compare column by column FALSE (or omitted) row by row exactly_once: TRUE will return distinct rows or colums that return exactly once FALSE will return all distinct rows or columns from the range or array
26
returns the most frequently occuring, repetitive value on an array or range of data
=MODE.SNGL(range)
27
returns the sum of the products of corresponding ranges or arrays
=SUMPRODUCT(array_1, [array_2],...)
28
check wether one or more conditions are met and returns a value that corresponds to the first TRUE conditions
=IFS([something is true 1, value if true1, something if true2, value if tru2...])
29
one of the logical fct to determine if all conditions in a test are TRUE
=AND(logical 1, [logical2]
30
determine if any conditions in a test are true
=OR(logical 1, [logical2]...)
31
fidn things in a table or range by row
=XLOOKUP(lookup_value, lookup_array, return array, [if_not_found], [match_mode], [search_mode]) match mode= 0 - exact match or #N/A -1 - exact match if none found find next smaller item 1- exact match, return next larger item 2 - w wildcard match where *, ?, have special meaning search mode: 1- begin searching with first item -1 - perform a reverse research strating last item 2 - binary search with look_uparray in ascending order -2 - binary search that relies on lookup_array being sorted in descending order
32
returns present value of an investment
=PV(rate, nper, pmt, [fv], [type]) rate: interest rate per period nper: total number of payments in an annuity pmt: the payment made at each period fV; the future value or a cash balance you want to attain type: 0: payment due end of period 1: payment due at the beginning of the period
33
calculates the payment for a loan based on constant payments and a constant interest rate
=PMT(rate, nper, pv, [fv], [type])
34
calculates the future value of an investment based on a constant interest rate
=FV(rate, nper, pmt, [pv], [type]) pv: the present valye of the lump-sum amount that a series of future payments is worth rn