COUNTIF FUNCTION
Counts the number of items in a range that
meet a specific criteria
=COUNTIF(range, criteria)
Range: A continuous range
Criteria: Determines what cells to count
Statistical Functions
1
Criteria Syntax
Text
Criteria Syntax
Number
Statist

SAMPLE EXAM III
DISCLAIMER - PLEASE READ:
These sample exam problems will serve as an excellent review for the actual exam. These questions should
give students a good idea of the format and rigor of problems to be encountered on the exams. The sample
exa

SAMPLE EXAM II
DISCLAIMER - PLEASE READ:
These sample exam problems will serve as an excellent review for the actual exam. These questions should
give students a good idea of the format and rigor of problems to be encountered on the exams. The sample
exam

SAMPLE EXAM I - ANSWERS ARE BOLDED
DISCLAIMER - PLEASE READ:
These sample exam problems will serve as an excellent review for the actual exam. These questions should
give students a good idea of the format and rigor of problems to be encountered on the ex

SAMPLE EXAM III
DISCLAIMER - PLEASE READ:
These sample exam problems will serve as an excellent review for the actual exam. These questions should
give students a good idea of the format and rigor of problems to be encountered on the exams. The sample
exa

SAMPLE EXAM II
DISCLAIMER - PLEASE READ:
These sample exam problems will serve as an excellent review for the actual exam. These questions should
give students a good idea of the format and rigor of problems to be encountered on the exams. The sample
exam

Common Excel Errors
Unusual symbols
Green triangles
Common Excel Errors/Basic Functions/Cell Addressing
1
Common Excel Errors
Numbers that dont add up correctly
(Precision Vs. Formatting)
Common Excel Errors/Basic Functions/Cell Addressing
2
Blank Cells w

IF FUNCTION
Checks to see if a condition is true or false. If true one thing happens,
if false another thing happens
IF this is true, do this,
ELSE do this.
=IF(logical test, value_if_true, [value_if_false])
Logical test must evaluate to True or False
IF

Question 1
The term 'relevant range' refers to the range of activity within which the assumptions
relevant to cost behaviors are valid.
Correct
Response
Answer Choices
a. true
b. false
Explanation:
The relevant range is defined as the range of activity wi