Microsoft Excel Flashcards
1
Q
save
A
control+s
2
Q
select all
A
control+a
3
Q
go to last cell in rows
A
control + arrow
4
Q
select cells one by one
A
shift + arrows
5
Q
find blanks
A
f4
6
Q
find and replace
A
f5
7
Q
excel formulas must begin with
A
=
8
Q
add cells
A
=SUM
9
Q
cells in the range E4 TO E11
A
E4:E11
10
Q
multiply
A
*
11
Q
divide
A
/
12
Q
power
A
13
Q
to make an absolute reference
A
$
14
Q
minimum function
A
MIN
15
Q
maximum function
A
MAX
16
Q
average function
A
AVERAGE
17
Q
count function
A
COUNT
18
Q
count non blank cells function
A
COUNTA
19
Q
count blank cells function
A
COUNTBLANK
20
Q
count cells with criteria
A
COUNTIF(s)
21
Q
Examples of logical functions
A
IF, AND, OR
22
Q
Vertical look up function
A
VLOOKUP
23
Q
Horizontal look up function
A
HLOOKUP
24
Q
Why would you include true/false in a look up function
A
false gives you exact, true is approx
25
to return a value in the cell at a certai intersection use
INDEX
26
to return a relative position of an item use the function
MATCH
27
what does match_type=1 give
largest value that is less than or equal to lookup_value
28
what does match_type=0 give
finds the first value which is exactly equal to look up value
29
what does match_type=-1 give
the smallest value that is greater than or equal to the look up value
30
formula for quartiles
=QUARTILE.EXE
| =QUARTILE.INC
31
formula for variance of a populations
=VAR.P
32
formula for variance of populations
=VAR.P
33
formula for standard deviation of population
=STDEV.P
34
formula for standard deviation of sample
=STDEV.S
35
how to get boxplot
select all data
insert
statistical
box + whisker
36
skew formula
=SKEW
37
correlation coefficient formula
=CORREL(arg1, arg2)
38
binomial distribution function
=BINOM.DIST
39
poisson distribution formula
=POISSON.DIST
40
z value formula
=STANDARDIZE(x, mean, stdev)
41
find prob p(
=NORM.DIST(x, mean, stdev, true/false)
42
What does true/false mean in norm.dist formula
true: accumulative
| false; singular probabiiity
43
to find z value given probability
=NORM.S.IV
44
How to get descriptive analysis
data analysis
descriptive stats
summary statstics box
