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...

60.1K

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

Physics
1.2K views

82 The diagram shows the path of four a particles of the same energy being...

Statistics
1.2K views

Which statement about correlation is FALSE O A correlation of 1 or 1 corresponds to...

Basic Math
1.2K views

Figure A shows the original figure Arrange the other figures in the order of reflection...

Physics
1.2K views

49 A tube of small uniform cross section is used to siphon the water from...

Physics
1.2K views

Which graph best represents the variation of electric potential as a function of distance from...

Geometry
1.2K views

Which of the following is not a grouped data sample Select one or more a...

Geometry
1.2K views

3 a 6 9 1 12 15 1 What type of segment is KL K...

Basic Math
1.2K views

During the month of August, the mean of the daily rainfall in one city was...

Statistics
1.2K views

The chief financial officer is monitoring the raises for each department The hypothesis is based...

Algebra
1.2K views

Rationalize the denominator Assume that the variable is positive 5 2x 5

Accounting
1.2K views

Briof Exercise 15-12 Pearl Mining Company declared, on April 20, a dividend of 403,000 payable...

Accounting
1.2K views

Is the cost of direct Labor by unit and The % of the expected income...