Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need Urgent help with this please. Also, the project needs to use formula which should be viewable to anything on the fx box. The

I need Urgent help with this please. Also, the project needs to use formula which should be viewable to anything on the fx box. The questions are mentiomed on the picture. Thanks a lot in advance.

image text in transcribed

Home Insert Page Layout Formulas Review View Data Connections Az T Show Deta Properties t Sort Filte Advanced ext to Remove Data Consolidate What lif Group Ungroup Subtotal e Hide Detail Columns Duplicates Val dat Analysis tion From From From New Database Refresh Edit Links FileMaker HTML Text Query 11 Name salary Tax Rate |Tax Amount 1 Tax Table smithi 54,000 Salary Tax 4 J. Smith 65,000 J. Smith 3 37,000 Rate 30,000 6 J. Smith 4 40,000 44,000 7 J. Smith 62,000 50,000 42,000 8 J. Smith 6 60,000 J. Smith 7 31,000 10 J. Smith 8 88,000 70,000 80,000 13 11 J. Smith9 91,000 90,000 14 12 J. Smith 10 52,000 100,000 15 15 TOTAL TAX AMOUNT 18 1. USE the vlookup function to find the appropriate Tax-Rate (in the Tax Table) for each employee 19 2. Calculate the individual Tax-Amount 20 3. Get the TOTAL TAXAMOUNT of all Tax-Amounts 21 4. Use Solver to increase the TOTAL TAX AMOUNT 65,000, and use the appropriate STEP 1 Share

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

Students also viewed these Accounting questions