MIS Unit 2 Excel

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/8

encourage image

There's no tags or description

Looks like no tags are added yet.

Last updated 2:58 AM on 10/19/26
Name
Mastery
Learn
Test
Matching
Spaced
Call with Kai
Chat

No analytics yet

Send a link to your students to track their progress

9 Terms

1
New cards

What is a relative cell reference?

= A2*B2…Copy down…=A3*B3

Both move

2
New cards

What is an absolute cell reference?

=A2*$M$2…copy down…=A3*$M$2

M2 stays put

3
New cards

What is a mixed cell reference?

=$A2*B$2…copy down…=$A3*B$2

Lock column or row

4
New cards

What does the COUT function do?

NUMBERS

=COUNT(range)

5
New cards

What does the COUNTA function do?

NONBLANK CELLS

=COUNTA(range)

6
New cards

What does COUNTIF function do?

One condition

=COUNTIF(range, criteria)

7
New cards

What does the COUNTIFS function do?

Multiple conditions

=COUNTIFS(range1, criteria1, _)

8
New cards

What does the function MEDIAN do?

Middle value

=MEDIAN(number 1,…)

Sort mentally: half the values fall on each side

9
New cards

What does the function PROB do?

Probability across outcomes

=PROB(x_range, prob_range, lower_limit, upper_limit)

Use matching outcome and probability ranges