Microsoft Excel 2021365 - Beginner to Advanced - Conditional IFs (SUMIF, COUNTIF, AVERAGEIF)

Microsoft Excel 2021365 - Beginner to Advanced - Conditional IFs (SUMIF, COUNTIF, AVERAGEIF)

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

The video tutorial covers the use of Excel functions such as COUNTIF, SUMIF, and AVERAGEIF. It explains how these functions work with single criteria to perform calculations like summing, counting, and averaging data. The tutorial provides examples using a sales dataset, demonstrating how to apply these functions effectively. The next lesson will introduce more complex functions with multiple criteria.

Read more

1 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF