Final answer:Use theMINIFSfunction in Excel to find the minimum value based on criteria. Replace the ranges in the formula with actual ranges from the data. This will output the minimum number of participants for events costing $10 in Atlanta.Explanation:To answer yourquestion, aMINIFSfunction can be used in Excel to find the minimum value in a range of cells based on multiple criteria.Here's how you can use it:In cell K1, enter the following formula:=MINIFS(range_of_participants, range_of_cost, "$10", range_of_city, "Atlanta")In this formula, replace 'range_of_participants', 'range_of_cost', and 'range_of_city' with theactualranges in your data. For instance if your data spans from B2 to B100 for 'No. Participants', from C2 to C100 for 'Cost', and A2 to A100 for 'City', the formula should be:=MINIFS(B2:B100, C2:C100, "$10", A2:A100, "Atlanta")Once you enter the correct formula, Excel will output the minimum number of participants for events costing $10 in Atlanta.Learn more about MINIFS function here:brainly.com/question/34655305#SPJ2...

Unlock to view answer

Unlock full access for 72 hours, watch your grades skyrocket.

For just $0.99 cents, get access to the powerful quizwhiz chrome extension that automatically solves your homework using AI. Subscription renews at $5.99/week.