Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Excel > Formulas > Flashcards

Formulas Flashcards

1
Q

SUM

A

=SUM(A1:A2)

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

Product

A

=PRODUCT(A1,A2)

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

SQUARE ROOT

A

SQRT(A1)

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

E^2

A

=EXP(2)

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

LN

A

LN(A1)

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

SUMPRODUCT

A

=SUMPRODUCT(A1:A2,B1:B2)

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

AND

A

=AND(logical 1, ~logical 2~)

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

OR

A

=OR(Logical 1, ~logical 2~)

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

IF

A

=IF(logical, “true”, “false”)

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

COUNT

A

=COUNT(A1:A2)

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

COUNTA

A

=COUNTA(A1:A2)

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

MINIMUM

A

=MIN(A1:A2)

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

MAXIMUM

A

=MAX(A1:A2)

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

SMALLEST

A

=SMALL(A1:A2, K)

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

LARGEST

A

=LARGE(A1:A2, K)

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

RANK EQUAL

A

=RANK.EQ(NUMBER, A1:A2, 0/1)

0 = DESCENDING
1 = ASCENDING

17
Q

RANK AVERAGE

A

=RANK.AVG(NUMBER, A1:A2, 0/1)

18
Q

MEAN

A

=AVERAGE(A1:A2)

19
Q

MEDIAN

A

=MEDIAN(A1:A2)

20
Q

VARIANCE

A

=VAR.S(A1:A2)

21
Q

STANDARD DEVIATION

A

=STDEV.S(A1:A2)

22
Q

COVARIANCE

A

=COVARIANCE.S(A1:A2, B1:B2)

23
Q

CORRELATION

A

=CORREL(A1:A2, B1:B2)

24
Q

COUNT IF

A

=COUNTIF(A1:A2, CRITERIA)

25
Q

MANY COUNT IFS

A

=COUNTIFS(A1:A2, CRITERIA 1, B1:B2, CRITERIA 2)

26
Q

SUM IF

A

=SUMIF(RANGE A1:A2, CRITERIA, NUMBERS TO ADD UP)

27
Q

MANY SUM IFS

A

=SUMIFS(NUMBERS TO ADD UP, Range A1:A2, Criteria 1, Range B1:B2, Criteria 2)

28
Q

AVERAGE IF

A

=AVERAGEIF(RANGE A1:A2, CRITERIA, NUMBERS TO AVG UP)

29
Q

MANY AVERAGE IFS

A

=AVERAGEIFS(NUMBERS TO AVG UP, Range A1:A2, Criteria 1, Range B1:B2, Criteria 2)

30
Q

COUNT BLANK CELLS

A

=COUNTBLANK(A1:A2)

31
Q

UNIQUE

A

=UNIQUE(A1:A2)

32
Q

PERCENTILE

A

=PERCENTILE(A1:A2, K) (K=0.?)

33
Q

ROUND

A

=ROUND(A1, NUM OF DIGITS AFTER .)

34
Q

NOT

A

NOT(ARGUMENT)

35
Q

IF ERROR

A

=IFERROR(VALUE, “0”)

36
Q

LOOK UP VALUES

A

=XLOOKUP(LOOK UP VALUE, LOOK UP ARAY, RETURN ARAY, ~”MESSAGE” IF NOT FOUND, MATCH MODE (0 - exact, -1 smaller, 1 larger), SEARCH MODE (1 first to last, -1 last to first))

37
Q

PRESENT VALUE

A

=PV(rate, # of payments, payment, ~FV, 0 (end) or 1 (start))

38
Q

FUTURE VALUE

A

=FV(Rate, # of payments, payment, ~PV, 0 (end) or 1 (start))

39
Q

PAYMENTS

A

=PMT(rate, # of payments, PV, ~FV, 0 (end) or 1 (start))

Excel (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions