1. Apply a Red, Accent 2, Lighter 60% fill color to the three cells closest to break-even without creating a deficit.
2. Apply custom number format to cell E21 to display # Attend.
3. Create a scenario named 500 Attend using the Number of Attendees, Caterer’s Meal Cost per Person, Ticket Price per Person, and Ballroom Rental variables as the changing cells. Deselect Prevent changes. Enter these values for the scenario: 500, 15.95, 75, and 12500.
