Microsoft Excel Tutorial: Working with Count Functions

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.

What is the primary purpose of the count function?

• To count all types of data in a cell

• To count only numbers in cells

• To count text and numbers in cells

• To count empty cells

How many arguments can the count function accept at maximum?

• 255

• 300

• 200

• 100

What happens when a row or column is deleted in a count function?

• The count function ignores the deletion

• The count function stops working

• The count function gives a reference error but still provides the correct count

• The count function counts text instead

In the example provided, why does the count function return a value error?

• Because it encountered a number

• Because it encountered text

• Because it encountered an empty cell

• Because it encountered a formula

What is the result of the count function when applied to cells with numbers and text?

• It counts both numbers and text

• It counts only the cells with numbers

• It counts only the cells with text

• It counts all cells