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

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.