Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit And Assurance Q And A 2016

Authors: ACA Simplified

1st Edition

1523200464, 978-1523200467

More Books

Students also viewed these Accounting questions

Question

How would you handle this situation?

Answered: 1 week ago

Question

2. What efforts are countries making to reverse the brain drain?

Answered: 1 week ago