Do you need this or any other assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 10% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
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.
Do you need this or any other assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 10% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
