Microsoft Excel Tutorial: Working with Average Functions

Microsoft Excel Tutorial: Working with Average Functions

Assessment

Interactive Video

Other

10th Grade - University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial covers the use of average functions in Excel. It begins with an introduction to the purpose and key points of average functions, such as ignoring text and empty cells, and handling up to 255 arguments. The tutorial then demonstrates how to insert the average function in Excel, followed by three methods to calculate averages. It also addresses common errors like reference and division errors, and concludes with a summary and encouragement to practice.

Read more

2 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

Describe the consequences of deleting a row or column that is referenced in an average function.

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

List the three different ways to find the average of data in Excel.

Evaluate responses using AI:

OFF