The file named Problem13data.xlsx contains sales data on 2,000 companies. Write formulas to count the number of

Question:

The file named Problem13data.xlsx contains sales data on 2,000 companies. Write formulas to count the number of banking firms and calculate the fraction of banking revenue earned by banks making at least $20 billion. Your answers should automatically update if new rows of data are added.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: