1. To serve community, the company will provide donations for community organizations in each state. The donation is calculated as follows:
   1. If the state is TX and the average sales are greater than 132,000, the company will donate 7.5% of its average sales
   2. If the state is NY and the sales are greater than 120000, the company will denote 4.6% of its average sales
   3. In all other states and conditions, the company will donate 3% of its average sales.

Calculate the company donations in the column Question 5

2. What is the sum of average yearly sales in the city of Marina or Salinas established between 1/1/1970 and 1/1/1980. Create a macro and macro button in the Queries sheet