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

By using Excel functions do the following:

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) 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.

DO NOT DELETE any work/functions you have used!

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

Requirements: As it should be