This Is the First 4 Lines of an Excel List

question 76

Multiple Choice

This is the first 4 lines of an excel list of 3082 records. Which formula counts the number of Gold Level Members in the entire list?

• A)=COUNTIF(A2:A3083,"Gold")
• B)=COUNTIFS(A2:A3083,"Gold")
• C)=COUNTIF(E2:E3083,"Gold")
• D)=COUNTIFS(A2:E3083,"Gold")

---

Definitions:

Merchandise Inventory

The total value of a retailer's goods that are available for sale to customers.

Estimated Cost

A prediction or forecast of the future cost of a project, operation, or production based on current data and trends.

Gross Profit Rate

A financial metric that measures the difference between sales and the cost of goods sold, expressed as a percentage of sales.

Merchandise Inventory

The goods a company holds for the purpose of resale to customers.