2. (1.5 points) You have been asked to calculate Sales Tax for the sales orders in the Sales Order Data worksheet. Use a VLookup function to enter the appropriate "combined" sales tax rate for each sale (Sale Ext), based on the sales tax information provided for the state of Washington. The sales tax table can be found on the second worksheet named "WA sales tax rates". Your co-worker has informed you that the sales taxes are determined by the City in the state of WA, so you will want to match on city to lookup your combined sales tax rates. |