Microsoft Excel Tutorial: Working with Count Functions

Microsoft Excel Tutorial: Working with Count Functions

Assessment

Interactive Video

Mathematics

10th Grade - University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial covers the basics of count functions in spreadsheets, focusing on how they count only numbers and ignore text and empty cells. It explains the syntax, limitations, and handling of reference errors when rows or columns are deleted. The tutorial also demonstrates using count with individual cell references versus ranges, providing practical examples and addressing value errors. The session concludes with a demonstration of undoing actions and encourages viewers to ask questions if needed.

Read more

2 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What error is shown when a row or column is deleted in relation to the count function?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

Explain the difference between using individual cell references and a range in the count function.

Evaluate responses using AI:

OFF