A Student Is Given the Task of Counting the Number

question 93

Multiple Choice

A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20.Which of the following formulas should he use to do so?

• A) =COUNT(B1:B20)
• B) =COUNTIF(B1:B20)
• C) =COUNTA(B1:B20)
• D) =DCOUNTA(B1:B20)

---

Definitions:

Regulatory Body

A regulatory body is an organization established by the government to oversee and regulate specific industries, ensuring they comply with legal statutes and standards.

FCC Commissioners

Officials appointed to the Federal Communications Commission, responsible for regulating interstate and international communications in the U.S.

Broadcast Media

Forms of media that distribute audio or visual content to a wide audience via television, radio, or other transmission devices.

Public Airwaves

The radio frequency spectrum that is considered public property and is regulated by government agencies to ensure it is used in the public interest.