Question: 1 Create a Pivot Table creating pivot table Sports Qtr Sales Golf 3 1500 Golf 4 2500 Tennis 3 3450 Tennis 4 5500 Tennis 3

1 Create a Pivot Table

creating pivot table

Sports

Qtr

Sales

Golf

1500

Golf

2500

Tennis

3450

Tennis

5500

Tennis

6500

Tennis

2500

Golf

1500

Golf

2000

Football

5000

Football

8000

Q 2 do a quick analysis

1. Total Q1 sales

2. Average of Tele industries

Company

Industry

Q1Sales

Q2Sales

BMW

auto

450000

485000

Nissan

auto

350000

375000

Toyota

auto

250000

350000

CP 24

Media

100000

130000

GSK

Pharma

150000

125000

Pfyzer

Pharma

200000

250000

Apple

tech

245000

265000

Samsung

tech

120000

245000

3mobile

tele

130000

345000

Orange

tele

130000

230000

Virgin

tele

175000

275000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock 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!

Given the following information, please calculate after tax cash flow for year 1. Assuming a sales price of $1,100,000, please calculate the after tax cash flow from the sale (don't forget the...

Please instructions and complete attached excel worksheet. Correctly and completely. Excel Demo Student Assignment 1. Download the spreadsheet named 'Student Excel Assignment Spring 2017.xlsx' from...

I need help with creating a formula for Strata 3 and Strata 4 on the excel spreasheet. YouDriveOut: The conversation The scene: Executives at YouDriveOut, a chain of used car lots, are brainstorming...

REGIONAL REALTY ASSOCIATION AUTHOR DATE PURPOSE ANALYSIS CORA WILKE 1/23/2016 ANALYSIS OF THE CLAIM BY LUKE LIBERTY REALTY No they should not advertise that they your get your price. On the analysis...

Cedar Fair CaseCompanion Case to Six Flags CaseFrom 1998-2006 there were four large, well-funded competitors in the regional theme park industry. Inorder: Six Flags, Cedar Fair, Paramount Parks, and...

INTRODUCTION This exercise is comprised of four parts. Part 1 covers automated routines macros in Excel to rearrange and transform data, Part 2 covers Pivot Table: Data Sets Cross-Tabulation and...

Nike Inc Case Study Please use the Following Information in the exhibits and information from the Case Study above to answer the following questions in paragraph form in about a 4-5 page analysis -...

Based on Nike Inc case ( screenshot attached) - Reach out for more details. Discussion Questions What are the most relevant issues that is identified in the case? Conduct a 5 C's analysis to evaluate...

create an SBU analysis based on nikes 2004 annual report. where would you increase investments maintain current investments, divest current investments(or get rid of lines) Andrew Amphlett sat back...

Scenario Summary Current Values: Original Financing Intermediate Car Changing Cells: Price $ 56,500 $ 21,595 $ 33,999 $ CashBack $ 2,500 $ $ 1,500 $ Months 60 24 36 APR 3.90% 1.90% 2.40% Result...

Prepare a Quantitative Strategic Planning Matrix (QSPM) as appropriate for the following case (Under Armour, inc., 2013) Under Armour, Inc., 2013 www.ua.com, UA Headquartered in Baltimore, Maryland,...

Consider an experiment having three possible outcomes Outcome 1, Outcome 2 and Outcome 3, so that Outcome 1 occurs with probability pi, Outcome 2 occurs with probability Pz and Outcome 3 occurs with...

A US citizen earns income on foreign rental properties. Generally, that income [ Select ] [ " may be " , " is " , " is not" ] taxable in the US . This is an example of a [ Select ] [ " territorial "...

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

5. Work Rules. CCH, a Wolters Kluwer company, provides a business owners toolkit through their Tax and Accounting service. CCH is a leading provider of business, legal, and tax information. Locate...

3. What type of evidence are the e-mails received from employees about Gatess on-duty behavior? Should this evidence be considered by the arbitrator? Why or why not? Background On March 30, 2006,...

4. Should the Companys offer to pay back pay and to restore seniority and benefits if Gates is found not guilty be considered by the arbitrator? Why or why not? Background On March 30, 2006, David...