Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. build a pivot table which calculates the average a

Build a pivot table which calculates the average and maximum sales by department You will have to...

50.1K

Verified Solution

Question

Accounting

Build a pivot table which calculates the average andmaximum sales by department

You will have to combine the data using VLOOKUP or MATCH/INDEX.Note any observations you see regarding trends in the results.

Use the data below to solve the problem. List steps anddirections step by step with any formulas, what has been clickedon, and any other important information to solve the problem usingExcel. Thank you.

Sales Data
Loyalty ID #Sale TotalDepartment
1391$   514.72Clothing
1804$   109.85Housing
1473$   328.42Housing
1847$   124.78Athletic
1586$     79.84Other
1243$   147.32Luggage
1117$   235.15Clothing
1995$     89.20Hardware
1591$     38.53Luggage
1919$     53.63Hardware
1957$   273.65Other
1397$     58.50Athletic
1118$   184.85Luggage
1354$   104.02Athletic
1414$     36.25Other
1714$   263.19Clothing
1826$     75.42Athletic
1591$   200.31Hardware
1387$     71.77Other
1147$   225.76Other
1298$   168.35Athletic
1045$     41.81Clothing
1022$     66.31Other
1290$     12.87Other
1059$   309.17Athletic
1522$     64.22Other
1533$   210.60Hardware
1266$   286.38Clothing

Answer & Explanation Solved by verified expert
3.9 Ratings (518 Votes)
AnswerThe image below shows the Average sales and maximum sales byeach    See Answer
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

An object moves along a straight line. The position as a function of time is given...

Biology
1.2K views

Which of the following statements best describes a single celled or multi celled organism that...

Physics
1.2K views

9 At an instant the current through the 302 resistor is 3A At this instant...

Basic Math
1.2K views

A particular country's exports of goods are increasing exponentially. The value of the exports, t...

Calculus
1.2K views

t T Find an exponential function of the form P t Pon that models the...

Accounting
1.2K views

Question 25) Your audit client shipped some merchandise to a customer on December 28 of...

Accounting
1.2K views

Cordova manufactures three types of stained glass window, cleverly named Products A, B,...

Accounting
1.2K views

. Which of the following are barriers to intercultural communication? Select one: a. Listening, speaking,...

Accounting
1.2K views

Event D Inventory costing $5,000 is sold and shipped to the customer. Assume the related...

Accounting
1.2K views

At the beginning of the period, the Assembly Department budgeted direct labor of $110,000, direct...

Accounting
1.2K views

You can not sell your personal residence so on 1/1/2019 you rent it out with...

Accounting
1.2K views

with a 6 tis returned by a blem and the tin 1 are as follows...