Apply conditional formatting to the Checking Total column to visually demonstrate the range of profits$/$contract $($choose any bars or scales you want$)$

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 $($without Filter and without Slicer$)$ which calculates the Average of Checking Total and Minimum of Savings Total at the subsequent levels of Branch $($top category$),$ customer Gender $($middle category$),$ and customer Age $($last low category$).$

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.

DO NOT DELETE any work$/$functions you have used!

Submit the assignment by uploading your workbook with all the answers in the Excel file.