Question: Using MS Excel, find the following for the given table TOTAL TOTAL NO. OF ITEM PRICE PRICE ITEM NO. TAX ITEMS PRICE BEFORE TAX

Using MS Excel, find the following for the given tableTOTALTOTALPRICEITEM NO. OFITEMPRICETAXRATENO.ITEMSPRICEBEFO

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

Step by Step Solution

3.47 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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

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 Accounting Questions!