This Is the Top Three Lines in a List of 8200

question 71

Multiple Choice

This is the top three lines in a list of 8200 records.You want an average of the number of speeding tickets for Red Toyota Priuses.Which is the correct formula?

• A)=AVERAGEIFS(A2:A8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius")
• B)=AVERAGEIFS(E2:E8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius")
• C)=AVERAGEIF(E2:E8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius")
• D)=AVERAGEIF(E2:E8201,"Red","Toyota","Prius")

---

Definitions:

Backgrounder

A written document, usually part of a media kit, that provides additional information on an organization and its situation to help a media worker craft a story.

Golden Rule

A moral or ethical principle that suggests treating others as one would wish to be treated themselves, often emphasized in various religious and philosophical traditions.

Inverted Pyramid

A method of writing used in news articles where information is presented in descending order of importance.

Op-Eds

Opinion pieces that usually concern current issues.