I need help with this Excel work! the assignment needs to be done in a period of time of an hour! your time will be rewarded by a good tip!
Central Lending (100 points)You have been hired to evaluate the lending history for Central Lending customers. Central Lending isevaluating their lending business to determine if they are in the position to expand their marketing into newmarkets or whether they should concentrate their efforts and resources in their current markets.a. Start Excel, open exam2_lending _ data and save as exam2_lending _LastFirst.b. Copy the Closed_Accts worksheet and rename the new worksheet as Pmt_Analysis. Using thePmt_Analysis worksheet, create a table named Pmt. Sort the table ascending by Loan_Status.Convert the table to a range and add subtotals showing the average Monthly_Pmt_Amt and averageLoan_Amt by Loan_Status, only show the Subtotal lines.c. Using the range A1:N400 from the Closed_Accts worksheet, insert a PivotTable on a new worksheetnamed P1. Name the PivotTable P1. Create a PivotTable to show the average Annual_Inc byHome_Ownership. Change the column label to Annual_Inc_Average, format the column withCurrency format and no decimals. Change the Row Labels to Home_Ownership.d. Using the range A1:N400 from the Closed_Accts worksheet, insert a PivotTable on a new worksheetnamed P2 and name the PivotTable P2. Create a PivotTable to show the total Loan_Amt byLoan_Status. Change the Loan_Amt column heading to Total_Loan_Amt and format the columnwith currency format and no decimals. Change the Row Labels to Loan_Status.e. Create a table using the data on the Contacts worksheet. Sort the table by State then by City. Add asubtotal to count the number of contacts from each state. Only show the subtotal lines.f. Save the file and post to Blackboard under Exam 2.
Recently Asked Questions
- Megan has $33 to spend on two goods - sushi and coca-cola. Sushi costs $4 per roll and coca-cola cost $5 per bottle. Megan's total benefit (TB) from consuming
- What are some cases in the classroom where a teacher would use procedural memory? Where are some examples where a teacher would use declarative memory?
- Read Jakada's (2014) article, " Building Global Strategic Alliances and Coalitions for Foreign Investment Opportunities " on building global strategic