Question: 10. In column U, enter a formula to compute the total Tax amount for the line item. The tax applies to the line subtotal minus

10. In column U, enter a formula to compute the total Tax amount for the line item. The tax applies to the line subtotal minus the discount. Use the VLOOKUP function to get the tax rate from the table Tax, using the customer's State (column F) as the lookup value. Apply the Currency format to the column. (5) 11. Copy the formula down to all rows. (5) 12. In column V, enter the formula to compute the Line Total. The line total should add up the subtotal, freight, tax values, and subtract the discount amount. Apply the Currency format to the column. (5) 13. Copy the formula down to all rows. (5) 14 In column en tot Formatting Fx Product Name 100 N P R S U w UnitPrice Quantity Line Subtot Promo Freight Disc Parc DiscountAmt Tax Line Total Paid Days Due Orde vanni $10.70 20 $214.00 Yellow 349 35 $0.00 1 $17.98 15 $269.70 $14.30 1 dden Fried Moe $11.13 7 $77.91 $14.30 1 $35.58 30 $1.067 40 $434 54 1 apples $19.26 6 $115.56 $434.54 0 Hot Pepper Sauce $19.26 4 $77.04 $4.67 1 pples $19.26 4 $77.04 $89.94 1 and Clam Chowder $11.13 5 $55.65 $10.70 0 Hot Pepper Sauce $19.26 $1.926.00 Red $876.45 1 rod $1338 44 $588.72 Red $422 86 1 $52.76 30 $1,582 B0 Red $422.86 ot $16.59 20 $331 80 $0.87 1 malade $35.10 25 $877.50 $89.51 1 S2033 12 $24396 $9.20 $10.17 30 $305.10 521997 30 $6.64 4 $26.56 Red $17.17 1 $37 24 24 $893.76 $198.39 1 $6.42 20 $128 40 Blue $32.46 1 $33.42 18 $60156 Blue $0.50 $20.33 1 20 $406.60 $8206 ault 0 $66.88 20 $1337 60 $13.10 1 $58.85 30 $1,765 50 Blue $19.55 $36.38 15 5545.70 0 $14.79 $52.76 1 20 $1.055 20 Yellow $759 37 er grne Solle $11.99 1 10 5119 90 Yellow $20.73 $13 91 15 5208 65 Tan 517299 53724 40 51.489.60 Red 1 er grne Sofia $11.99 $54 27 20 $239.80 Rod 1 $77.98 Inde 5963 70 1 $674.10 Blue $50.82 alou 51739 $156 51 $2468 $36.38 5 $181.90 1 58.13 bo MK 510.17 4 54068 1 $8.15 $36 38 2 $72.76 Blue 1 $285 338.52 30 $1.155.60 $6.62 $52.76 1 $52.76 52776 $386 12 $4632 Yellow 528.42 519.25 TO $19260 and Clam Chowder 0 $11.13 $2776 566780 $58 58 1 $18.6 30 556040 Red 1 Shes $38 52 540.16 12 $462 24 Green 1 nic Dress $49.99 5042 15 536 30 mbo Mo 1 310.17 5229 20 $203.40 - $50.03 1 10 Won Table Date PVT Salesby Product PVT Sales year MacBook Air 10. In column U, enter a formula to compute the total Tax amount for the line item. The tax applies to the line subtotal minus the discount. Use the VLOOKUP function to get the tax rate from the table Tax, using the customer's State (column F) as the lookup value. Apply the Currency format to the column. (5) 11. Copy the formula down to all rows. (5) 12. In column V, enter the formula to compute the Line Total. The line total should add up the subtotal, freight, tax values, and subtract the discount amount. Apply the Currency format to the column. (5) 13. Copy the formula down to all rows. (5) 14 In column en tot Formatting Fx Product Name 100 N P R S U w UnitPrice Quantity Line Subtot Promo Freight Disc Parc DiscountAmt Tax Line Total Paid Days Due Orde vanni $10.70 20 $214.00 Yellow 349 35 $0.00 1 $17.98 15 $269.70 $14.30 1 dden Fried Moe $11.13 7 $77.91 $14.30 1 $35.58 30 $1.067 40 $434 54 1 apples $19.26 6 $115.56 $434.54 0 Hot Pepper Sauce $19.26 4 $77.04 $4.67 1 pples $19.26 4 $77.04 $89.94 1 and Clam Chowder $11.13 5 $55.65 $10.70 0 Hot Pepper Sauce $19.26 $1.926.00 Red $876.45 1 rod $1338 44 $588.72 Red $422 86 1 $52.76 30 $1,582 B0 Red $422.86 ot $16.59 20 $331 80 $0.87 1 malade $35.10 25 $877.50 $89.51 1 S2033 12 $24396 $9.20 $10.17 30 $305.10 521997 30 $6.64 4 $26.56 Red $17.17 1 $37 24 24 $893.76 $198.39 1 $6.42 20 $128 40 Blue $32.46 1 $33.42 18 $60156 Blue $0.50 $20.33 1 20 $406.60 $8206 ault 0 $66.88 20 $1337 60 $13.10 1 $58.85 30 $1,765 50 Blue $19.55 $36.38 15 5545.70 0 $14.79 $52.76 1 20 $1.055 20 Yellow $759 37 er grne Solle $11.99 1 10 5119 90 Yellow $20.73 $13 91 15 5208 65 Tan 517299 53724 40 51.489.60 Red 1 er grne Sofia $11.99 $54 27 20 $239.80 Rod 1 $77.98 Inde 5963 70 1 $674.10 Blue $50.82 alou 51739 $156 51 $2468 $36.38 5 $181.90 1 58.13 bo MK 510.17 4 54068 1 $8.15 $36 38 2 $72.76 Blue 1 $285 338.52 30 $1.155.60 $6.62 $52.76 1 $52.76 52776 $386 12 $4632 Yellow 528.42 519.25 TO $19260 and Clam Chowder 0 $11.13 $2776 566780 $58 58 1 $18.6 30 556040 Red 1 Shes $38 52 540.16 12 $462 24 Green 1 nic Dress $49.99 5042 15 536 30 mbo Mo 1 310.17 5229 20 $203.40 - $50.03 1 10 Won Table Date PVT Salesby Product PVT Sales year MacBook Air

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

9. In column U, enter a formula to compute the total Tax amount for the line item. The tax applies to the line subtotal minus the discount. Use the VLOOKUP function to get the tax rate from the table...

2 Sgt. Barnes is a veteran police officer filing as Head of Household. Currently, her taxable income is $50,000, but has been asked to sit for the Leutenant's exam. She is excited about the...

2 Sgt . Barnes is a veteran police officer filing as Head of Household. Currently, her taxable income is $ 5 0 , 0 0 0 , but has been asked to sit for the Leutenant's exam. She is excited about the...

Sgt. Barnes is a veteran police officer filing as Head of Household. Currently, her taxable income is $50,000, but has been asked to sit for the Leutenant's exam. She is excited about the opportunity...

Case 3 - Bobby's Popcorn (19 marks) Bobby Nolan established Bobby's Popcom in Hawthom, NV in 2016. He ships flavoured popcom in standard flavours such as plain and Kettle com and gourmet flavours...

The Nelson Company is planning a new division to make a specialised product. This is the only product that the division will make. As a financial analyst in the planning department, youve been asked...

Case Problem 1 Data File needed for this Case Problem: Popcorn.xlsx Ricky's Popcom Ricky Nolan established Ricky's Popcom in Hawthorne, Nevada, in 2000. He ships flavored popcorn in standard flavors...

help me Excel_Comprehensive_Capstonel_Wint ect Description: s project, you will apply skills you practiced from the objectives in Excel Chapters 4 through 10. You will develop a book for Frank Osei,...

need help with no. 10 and 11 pls. need to know how to type the formula in. 6. In the Price cell (cell Glb), use listed in the Product Pricing table in the Pricing and Shipping worksheet. (Hint: Use...

I also need help with form 540 2020 and with indvidual tax formula if possible hopefully these are much more clearer i apologize for the photos not being clear hopefully this time they are clearer ....

A body is attached to the lower end of a vertical spiral spring & it is gradually lowered to its equilibrium position. This stretches the spring by a length x. If the same body attached to the same...

The compound with the following 1HNMR spectrum is known to be highly reactive toward electrophilic aromatic substitution. Identify the compound. 0 8 0 (ppm)

4. ABCD is a parallelogram. It is given that AB = (7 0) and BC = (-3 4) (i) Find the value of AB. (ii) Express each of the following as a column vector. (a) DC (b) DA D A A C B

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...