AutoSave Of H E X_1_ASSIGNMENT (2) - Compatibility Mode - Ex... RICARDO.RIOS@baruchmail.cuny.edu 0 - 0 X Share Comments Tell me 13- File Home Insert Page Layout Formulas Data Review View Help Al LEO M AA Y Clear Reapply Stocks Geography = Filter All B Advanced Get & Transform Data Queries & Connecti... Data Types Sort & Filter B Get Refresh Sort Text to Outline Data Columns Data Tools What If Forecast Analysis Sheet Forecast C5 A B D E F G H I J KA Tax rate(%) 3 Name Salary Tax-Amount 5 J. Smith1 6 J. Smith2 7 J. Smith3 8 J. Smith4 9 J. Smith5 10 J. Smith6 11 J. Smith7 12 J. Smith8 13 J. Smith 9 14 J. Smith10 54,000 65,000 37,000 44,000 62,000 42,000 31,000 88,000 91,000 52,000 16 Total Tax Amount 20 Complete the following steps: 21 1. Calculate the individual Tax-Amount 22 2. Get the TOTAL TAX AMOUNT of all Tax-Amounts 23 3. Use Goal Seek to increase the TOTAL TAX AMOUNT = 50,000 - what will the new Tax rate be