BUSINESSEDUCATIONNY
  • Home
  • CPU Applications
  • Marketing
    • Marketing Introduction
    • Module 1: Marketing Today & Tomorrow
    • Module 2 Socially Responsive Marketing
    • Module 3: Marketing Begins With Economics
    • Module 4: The Basics Of Marketing
    • Module 5: Marketing Information & Research
    • Module 6: Marketing Starts With Customers
    • Module 7: Competition Is Everywhere
    • Module 8: E-Commerce And Virtual Marketing
    • Module 9: Developing A Marketing Strategy & Marketing Plan
  • Desktop Publishing
  • CFM 25-26
  • CPU APP COLLEGE
    • Part 1 Excel 200
    • Part 2 Excel 201 Advanced
    • Part 3: Microsoft Access 500
    • Part 4: Mr. Kazanjian's Tips & Tricks

​Post Assessment Excel 201 Domain 3

Totals with a Single Criterion
Totals with Multiple Criteria
Average with a Single Criterion
Average with Multiple Criteria
Count with Criteria
Count with Multiple Criteria
Multiple Conditions in Formulas
Partial Condition Match
Opposites of Matches
Conditional Functions
Functions with Two Conditions
Functions with Multiple Conditions
Highest Amount Based on a Condition
Lowest Amount Based on a Condition


Finish Test

Mr. Kazanjian's Business Class
Hempstead High School
Room A112
​[email protected]

  • Home
  • CPU Applications
  • Marketing
    • Marketing Introduction
    • Module 1: Marketing Today & Tomorrow
    • Module 2 Socially Responsive Marketing
    • Module 3: Marketing Begins With Economics
    • Module 4: The Basics Of Marketing
    • Module 5: Marketing Information & Research
    • Module 6: Marketing Starts With Customers
    • Module 7: Competition Is Everywhere
    • Module 8: E-Commerce And Virtual Marketing
    • Module 9: Developing A Marketing Strategy & Marketing Plan
  • Desktop Publishing
  • CFM 25-26
  • CPU APP COLLEGE
    • Part 1 Excel 200
    • Part 2 Excel 201 Advanced
    • Part 3: Microsoft Access 500
    • Part 4: Mr. Kazanjian's Tips & Tricks