Liam Needs to Count the Cells in the Range B1:B20

question 178

Multiple Choice

Liam needs to count the cells in the range B1:B20 that contain numbers, dates, or text.Which of the following formulas should he use?

• A) '=COUNT(B1:B20)
• B) =COUNTA(B1:B20)
• C) =SUM(B1:B20)
• D) =CALCULATE(B1:B20)

---

Definitions:

Chemical Processes

Involves changes in chemical substances through reactions, leading to the formation of new substances.

Secondary Sewage Treatment

A stage in wastewater treatment involving biological processes to degrade organic matter, following primary treatment which mainly removes solid materials.

Biological Process

Natural processes involving living organisms, such as growth, reproduction, and metabolism.

Detergents

Chemical compounds used to remove dirt, stains, and other substances by lowering the surface tension of water, commonly found in cleaning products.