Microsoft Excel

Question 1

save

Answer 1

control+s

Question 2

select all

Answer 2

control+a

Question 3

go to last cell in rows

Answer 3

control + arrow

Question 4

select cells one by one

Answer 4

shift + arrows

Question 5

find blanks

Answer 5

f4

Question 6

find and replace

Answer 6

f5

Question 7

excel formulas must begin with

Answer 7

=

Question 8

add cells

Answer 8

=SUM

Question 9

cells in the range E4 TO E11

Answer 9

E4:E11

Question 10

multiply

Answer 10

*

Question 11

divide

Answer 11

/

Question 12

power

Question 13

to make an absolute reference

Answer 13

$

Question 14

minimum function

Answer 14

MIN

Question 15

maximum function

Answer 15

MAX

Question 16

average function

Answer 16

AVERAGE

Question 17

count function

Answer 17

COUNT

Question 18

count non blank cells function

Answer 18

COUNTA

Question 19

count blank cells function

Answer 19

COUNTBLANK

Question 20

count cells with criteria

Answer 20

COUNTIF(s)

Question 21

Examples of logical functions

Answer 21

IF, AND, OR

Question 22

Vertical look up function

Answer 22

VLOOKUP

Question 23

Horizontal look up function

Answer 23

HLOOKUP

Question 24

Why would you include true/false in a look up function

Answer 24

false gives you exact, true is approx

Question 25

to return a value in the cell at a certai intersection use

Answer 25

INDEX

Question 26

to return a relative position of an item use the function

Answer 26

MATCH

Question 27

what does match_type=1 give

Answer 27

largest value that is less than or equal to lookup_value

Question 28

what does match_type=0 give

Answer 28

finds the first value which is exactly equal to look up value

Question 29

what does match_type=-1 give

Answer 29

the smallest value that is greater than or equal to the look up value

Question 30

formula for quartiles

Answer 30

=QUARTILE.EXE

=QUARTILE.INC

Question 31

formula for variance of a populations

Answer 31

=VAR.P

Question 32

formula for variance of populations

Answer 32

=VAR.P

Question 33

formula for standard deviation of population

Answer 33

=STDEV.P

Question 34

formula for standard deviation of sample

Answer 34

=STDEV.S

Question 35

how to get boxplot

Answer 35

select all data
insert
statistical
box + whisker

Question 36

skew formula

Answer 36

=SKEW

Question 37

correlation coefficient formula

Answer 37

=CORREL(arg1, arg2)

Question 38

binomial distribution function

Answer 38

=BINOM.DIST

Question 39

poisson distribution formula

Answer 39

=POISSON.DIST

Question 40

z value formula

Answer 40

=STANDARDIZE(x, mean, stdev)

Question 41

find prob p(

Answer 41

=NORM.DIST(x, mean, stdev, true/false)

Question 42

What does true/false mean in norm.dist formula

Answer 42

true: accumulative

false; singular probabiiity

Question 43

to find z value given probability

Answer 43

=NORM.S.IV

Question 44

How to get descriptive analysis

Answer 44

data analysis
descriptive stats
summary statstics box