Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. exercise 2 item no. of item no. items price tax to

Exercise 2 ITEM NO. OF ITEM NO. ITEMS PRICE TAX TOTAL TOTAL PRICE PRICE BEFORE...

80.2K

Verified Solution

Question

Accounting

image
Exercise 2 ITEM NO. OF ITEM NO. ITEMS PRICE TAX TOTAL TOTAL PRICE PRICE BEFORE AFTER TAX TAX RATE 2 100 101 5 115 256 49 23 840 200 294 4 30 12 56 150 5 56 300 90 7 0 ? ? 1 Count of items 2 Average of tax 13 Min ITEM PRICE? Max ITEM PRICE? 1. Open a new workbook and save the file with the name "Exercice2". 2. Enter the labels and values in the exact cells locations as desired. 3. For the above table find the following: 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. 6. Save file

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students