Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please show formulas Average Savings ($) please place Loan Purpose Jobs Average Saving Loan Purpose Jobs Management skilled Business $2,900.67 Education $461.67 Furniture $453.60 Large
please show formulas
Average Savings ($) please place Loan Purpose Jobs Average Saving Loan Purpose Jobs Management skilled Business $2,900.67 Education $461.67 Furniture $453.60 Large Appliance $4,568.000 New Car $1,647.92 Other $1,175.60 Repairs $1,879.00 Retraining $4,582.00 Small Appliance $4,483.57 Used Car $504.40 Unemployed Unskilled $584.88 $885.00 $2,642.18 $2,040.14 $890.00 $135.50 $2,133.24 $479.00 $1,639.47 $5,815.67 $2,500.00 $775.00 $1,469.54 $2,846.80 $1,306.00 $789.00 $1,258.00 $456.00 $846.14 $672.00 $591.67 $301.50 $1,592.00 $1,598.00 $2,148.05 $3,566.00 $2,539.92 $2,230.50 $13,428.00 $541.00 6_(10pts) a_Create a drop-down list of items in "Loan Purpose" and "Jobs" cells using the Data Validation tool. (4pts) b_Design a query application to input "Loan Purpose" and "Jobs" name, and retrieve the corresponding average savings using VLOOKUP and MATCH functions. (6pts)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started