What Excel Formula Should Be Used to Count the Number

question 9

Multiple Choice

What Excel formula should be used to count the number of empty cells in the following dataset?

• A) COUNTIF(A6:H17, "")
• B) COUNTIF(A1:H17, "")
• C) COUNTIF(A6:H17, 0)
• D) COUNTIF(A1:H17, Empty)
• E) COUNT(A6:H17, "")

---

Definitions:

Diplomacy

The art and practice of conducting negotiations between representatives of states, typically to maintain peace and resolve conflicts.

Transatlantic Travel

Transatlantic travel refers to the crossing of the Atlantic Ocean in order to travel between Europe and the Americas, which has been a key route for international movement of people and goods.

16th Century Monarchs

Pertains to the rulers of various kingdoms and countries around the world during the 16th century, a period marked by significant political, cultural, and religious changes including the Renaissance and Reformation.

Mediterranean

A sea connected to the Atlantic Ocean, surrounded by the Mediterranean region and almost completely enclosed by land.