Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. data table to complete task 1, task 2 and task 3

Data table to complete Task 1, Task 2 and Task 3 ...

50.1K

Verified Solution

Question

Accounting

Data table to complete Task 1, Task 2 and Task 3 Task 2: Conditional formatting.
a) If the Sales or Cost is LESS than average
Year Sales Cost Sales or Cost the format will be -
2001 923,859 755,087
2002 1,222,054 961,643 a) If the Sales or Cost is MORE than average
2003 1,250,365 1,008,292 Sales or Cost the format will be -
2004 1,176,787 925,430
2005 995,720 788,576
2006 1,324,534 1,067,627
2007 1,260,340 992,272
Task 1: Calculate the following.
Total Sales:
Average Sales:
Total Cost:
Average Cost:
Highest Sales:
Lowest Sales:
Highest Cost:
Lowest Cost:

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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

1) Before DNA sequencing, how were scientists able to determine the identity and number of chromosomes...

Biology
Q

Which of the following molecules is an enzyme?ProteinSucraseMannoseGlucoseSucrose

Biology
Q

9 A block of mass 5 kg is placed over a rough horizontal surface with...

Physics
Q

Accounting
Q

Opportunity cost is best defined as: Select one: a. The highest valued benefit given up...

Accounting
Q

Question 34 The costs most easily traced to each product manufactured are ________. ...

Accounting
Q

For 20X1, MAP Inc. had net income of $8,100 and collected the following information: ...

Accounting
Q

Koty Company purchased a building and land water market value of 1876.000 kr. 300.000 and...

Accounting
Q

A plant asset with a cost of $490000 and accumulated depreciation of $452000 is sold...

Accounting
Q

Marwicks Pianos, Inc., purchases pianos from a large manufacturer for an average cost of $1,492...

Accounting
Q

Village Delivery Company purchased a lot to construct a new warehouse for $293,000, paying $44,000...

Accounting
Q

Consider a zero-coupon bond with a $1000 face value and 10 years left until maturity....

Finance