QMB 3200 Dr. Brook Final: Part A (Excel Formula Syntaxes Only)
0.0(0)
Studied by 246 people0.0(0)
Call with Kai
Learn
Practice Test
Spaced Repetition
Match
Flashcards
Knowt PlayCard Sorting
1/15
Earn XP
Description and Tags
A review of all Excel formula syntaxes, as in what each formula needs to work
Study Analytics
Name | Mastery | Learn | Test | Matching | Spaced | Call with Kai |
|---|
No study sessions yet.
16 Terms
1
New cards
Correct Syntax for the "=RAND" Function
=RAND()
2
New cards
Correct Syntax for the "=NORM.DIST" Function
=NORM.DIST(Upper limit ,mean ,STD, TRUE), or =NORM.DIST(Lower limit ,mean ,STD, TRUE)
3
New cards
Correct Syntax for the "=COUNT" Function
=COUNT(Range)
4
New cards
Correct Syntax for the "=CONFIDENCE.NORM" Function
=CONFIDENCE.NORM(Alpha, STD, Sample Size)
5
New cards
Correct Syntax for the "=COUNTIF" Function
=COUNTIF(Range)
6
New cards
Correct Syntax for the "=COUNTA" Function
=COUNTA(Range)
7
New cards
Correct Syntax for the "=NORM.S.INV" Function
=NORM.S.INV(Probability) -> (1-Level of Sig / 2)
8
New cards
Correct Syntax for the "=NORM.S.DIST" Function
=NORM.S.DIST(Test Statistic, TRUE)
9
New cards
Correct Syntax for the "=SQRT" Function
=SQRT(Number)
10
New cards
Correct Syntax for the "=MIN" Function
=MIN(Number)
11
New cards
Correct Syntax for the "=T.DIST" Function
=T.DIST(Test Statistic, Degrees of Freedom, TRUE)
12
New cards
Correct Syntax for the "=T.INV.2T" Function
=T.INV.2T(Level of Sig., Degrees of Freedom)
13
New cards
Correct Syntax for the "=STDEV.S" Function
=STDEV.S(Range)
14
New cards
Correct Syntax for the "=VAR.S" Function
=VAR.S(Range)
15
New cards
Correct Syntax for the "=MEDIAN" Function
=MEDIAN(Range)
16
New cards
Correct Syntax for the "=AVERAGE" Function
=AVERAGE(Range)
Note 
Flashcards (55)