Using MS Excel, find the following for the given table TOTAL TOTAL NO. OF ITEM PRICE...

Transcribed Image Text:

Using MS Excel, find the following for the given table TOTAL TOTAL NO. OF ITEM PRICE PRICE ITEM NO. TAX ITEMS PRICE BEFORE TAX AFTER TAX 100 115 30 101 256 12 49 59 23 150 840 5 200 56 294 300 4 90 Count of items ? Average of tax ? Min ITEM PRICE? Max ITEM PRICE a) TAX (If ITEM PRICE is less than 100, TAX is 50, otherwise it should be 100). b) TOTAL PRICE BEFORE TAX=NO. OF ITEMS ITEM PRICE. c) TOTAL PRICE AFTER TAX=TOTAL PRICE BEFORE TAX + TAX. d) RATE (If TOTAL PRICE AFTER TAX > 3500 then the rate is "HIGH", otherwise it is REASONABLE. e) Find Count of Items, Average of Taxes, Min Item PRICE and Max Item PRICE. RATE Using MS Excel, find the following for the given table TOTAL TOTAL NO. OF ITEM PRICE PRICE ITEM NO. TAX ITEMS PRICE BEFORE TAX AFTER TAX 100 115 30 101 256 12 49 59 23 150 840 5 200 56 294 300 4 90 Count of items ? Average of tax ? Min ITEM PRICE? Max ITEM PRICE a) TAX (If ITEM PRICE is less than 100, TAX is 50, otherwise it should be 100). b) TOTAL PRICE BEFORE TAX=NO. OF ITEMS ITEM PRICE. c) TOTAL PRICE AFTER TAX=TOTAL PRICE BEFORE TAX + TAX. d) RATE (If TOTAL PRICE AFTER TAX > 3500 then the rate is "HIGH", otherwise it is REASONABLE. e) Find Count of Items, Average of Taxes, Min Item PRICE and Max Item PRICE. RATE

Answer rating: 100% (QA)

Formulas as per following 3 a IFC2 100... View the full answer