Write a macro and create a macro button for the following: For Wealth Choice Group

$($i$.$e$.$ WCG$),$

a$.$ what is the Total $$average yearly sales$$ from Texas $($i$.$e$.$ TX$)$ Pub that are were

established before $1989?$ Present your answer in Queries sheet.

b$.$ Repeat step a$,$ but this time, let the user enter the state. If the function returns

an error $($e$.$g$.$ Div$/0),$ display a message saying $$No sales for the given state$,$

otherwise, display the average.

$5.$ To serve community, the company will provide donations for community organizations

in each state. The donation is calculated as follows:

a$.$ If the state is TX and the average sales are greater than $132,000,$ the company

will donate $7\mathrm{.}5\%$ of its average sales

b$.$ If the state is NY and the sales are greater than $120000,$ the company will denote

$4\mathrm{.}6\%$ of its average sales

c$.$ In all other states and conditions, the company will donate $3\%$ of its average

sales.

Calculate the company donations in the column $$Question $5$

$6.$ 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