Question: Add a worksheet and rename it Step 1. Create a table that includes customer first and last name, total balance of deposit and investment accounts,
Add a worksheet and rename it Step 1. Create a table that includes customer first and last name, total balance of deposit and investment accounts, and whether the customer has a life insurance policy with the bank or not. Format the data to look professional. Sort the data by the total deposit and investment balance in descending order. Filter those customers without an insurance policy with the bank. It should look like the following. W1_Lab_Step_1.jpg Image Description Save your Excel file. Step 2: Complete Analysis of Car Loan Customer Without Insurance Copy the primary sheet (Sheet 1) and move it to the end. Rename it to Step 2. Filter the data to show those customers with a car
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
