By using Excel functions do the following:

Create the following new columns of data to indicate customers who meet the criteria:

"Membership" column for customers who had membership for more than $2$ years

"Checking or Saving" column for customers with either more than $$12,000$ in their savings or more than $$5,000$ in their checking

"Flagstaff and Own" column for customers whose local branch is Flagstaff AND own their own houses with OR without mortgage

Build ONE Pivot Table which calculates the Average of Checking Total and Minimum of Savings Total by Branch, and customer Gender and Age.

You need to merge Gender and Age from worksheet B into A using XLOOKUP, VLOOKUP or MATCH$/$INDEX$.$

Note any observations you see regarding trends in the results. These observations can be typed as a sentence directly into the Excel workbook.

IMPORTANT: The values in columns for question $2,3,$ and $4$ must be $0$ or $1,$ NOT "False" or "True". An example of such column $($indicating if the customers savings account is less than $$1,000)$ is shown.