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 B C D E
1 Level Last Purchase First Name Last Name Market
2 Silver 12/1/2016 Tanya Smith Tupelo
3 Gold 12/3/2018 Martha Forester Minneapolis
4 Platinum 12/8/2019 Thomas Cord Lakeland
A) =COUNTIFS(A2:E3083,"Gold") B) =COUNTIF(A2:A3083,"Gold")
C) =COUNTIF(E2:E3083,"Gold") D) =COUNTIFS(A2:A3083,"Gold")
Answer is B) =COUNTIF(A2:A3083,"Gold")
You might also like to view...
The tab in Backstage view that displays information about the current file is the:
a. Info tab b. contextual tab c. left tab
What is not true about opening a database in exclusive mode?
A. It ensures that you are the only one using the database at the moment. B. It is the default mode when opening a database. C. It must be used to add a password to a database. D. It must be used to add encryption to a database.