Alex wants to compare the Platinum group data for January by specialty. He asks you to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Alex wants to compare the Platinum group data for January by specialty. He asks you to create a PivotTable to better manipulate and filter the data. On a new worksheet, create a recommended PivotTable based on the Platinum table that shows the Sum of Jan by Specialty. [Mac Hint - Insert a new PivotTable on a new worksheet, adding the Specialty field to the Rows area and the Jan field to the Values area.] Use Platinum PivotTable for the name of the worksheet containing this PivotTable. Apply Rose, Pivot Style Medium 13 to match the style of the other tables in the workbook. 10. 11. Alex asks you to customize the new PivotTable to show more details and to provide a filter. Add the Total Projects field to the Values area below the Sum of Jan field. Add the Group ID field to the Rows area below the Specialty field. Add the Project Type field to the Filters area. Change the display of subtotals to Show all Subtotals at Bottom of Group. Alex also wants to focus on data for repeat projects only and to display the records for reviews. Filter the PivotTable to show only records with a Repeat project type. Drill down into cell C15 to show all records for Reviewing projects with a Repeat project type on a new worksheet. Use Repeat Reviews as the name of the new worksheet. Apply Red, Table Style Medium 6 to the table. 12. Editing Groups - Platinum Level 1. 2. 3. Specialty Project Type Projects Mar - 4. Group ID Level Jan Total Projects Feb 5. A-2 Platinum Reviews New 10 8. 11 29 6. Repeat Copywriting Repeat A-1 Platinum Q&AS 7 8. 9 24 7 B-2 Platinum 10 7. 7 24 C-1 Platinum Internal New 6. 9. 22 9. B-3 Platinum Reviews 6. 6. 20 Repeat Copywriting Repeat 8 10 C-3 Platinum 6. 20 11 A-3 Platinum Internal New 5. 7. 7. 19 Platinum Q&As 7 7. 19 Repeat Repeat 12 В-1 13 C-2 Platinum Reviews 6. 6. 6. 18 14 15 Most projects: 16 17 Total reviews: Alex wants to compare the Platinum group data for January by specialty. He asks you to create a PivotTable to better manipulate and filter the data. On a new worksheet, create a recommended PivotTable based on the Platinum table that shows the Sum of Jan by Specialty. [Mac Hint - Insert a new PivotTable on a new worksheet, adding the Specialty field to the Rows area and the Jan field to the Values area.] Use Platinum PivotTable for the name of the worksheet containing this PivotTable. Apply Rose, Pivot Style Medium 13 to match the style of the other tables in the workbook. 10. 11. Alex asks you to customize the new PivotTable to show more details and to provide a filter. Add the Total Projects field to the Values area below the Sum of Jan field. Add the Group ID field to the Rows area below the Specialty field. Add the Project Type field to the Filters area. Change the display of subtotals to Show all Subtotals at Bottom of Group. Alex also wants to focus on data for repeat projects only and to display the records for reviews. Filter the PivotTable to show only records with a Repeat project type. Drill down into cell C15 to show all records for Reviewing projects with a Repeat project type on a new worksheet. Use Repeat Reviews as the name of the new worksheet. Apply Red, Table Style Medium 6 to the table. 12. Editing Groups - Platinum Level 1. 2. 3. Specialty Project Type Projects Mar - 4. Group ID Level Jan Total Projects Feb 5. A-2 Platinum Reviews New 10 8. 11 29 6. Repeat Copywriting Repeat A-1 Platinum Q&AS 7 8. 9 24 7 B-2 Platinum 10 7. 7 24 C-1 Platinum Internal New 6. 9. 22 9. B-3 Platinum Reviews 6. 6. 20 Repeat Copywriting Repeat 8 10 C-3 Platinum 6. 20 11 A-3 Platinum Internal New 5. 7. 7. 19 Platinum Q&As 7 7. 19 Repeat Repeat 12 В-1 13 C-2 Platinum Reviews 6. 6. 6. 18 14 15 Most projects: 16 17 Total reviews:
Expert Answer:
Answer rating: 100% (QA)
B D E F G K L M 1 Project Type All PivotTable Fields 2 Choose fields ... View the full answer
Related Book For
Statistical Techniques in Business and Economics
ISBN: 9781260239478
18th Edition
Authors: Douglas Lind, William Marchal, Samuel Wathen
Posted Date:
Students also viewed these mathematics questions
-
The president of the American Insurance Institute wants to compare the yearly costs of auto insurance offered by two leading companies. He selects a sample of 15 families, some with only a single...
-
An agriculture researcher wants to compare the yield of 5 corn varieties: A, B, C, D, and E. The field in which the experiment will be carried out increases in fertility from north to south. The...
-
Suppose that an investor wants to compare the risks associated with two different stocks. One way to measure the risk of a given stock is to measure the variation in the stocks daily price changes....
-
When members of your team coordinate how to prepare the progress report, in which direction is the flow of communication?
-
Organizers of the annual Fiesta Bowl football game held in Arizona proposed establishing a race-specific scholarship fund for players of the competing teams. Are such scholarships unconstitutional...
-
Higher life-forms could not have evolved through merely random processes, because no organized beings could have evolved that way. In the following enthymemes, determine whether the missing statement...
-
Alfresco Ltd manufactures air-conditioning units designed for apartment use. The company markets this line in two geographic areas, one with a humid climate and the other with a dry climate....
-
On January 31, a firm learns that it will have additional funds available on May 31. It will use the funds to purchase $5,000,000 par value of the APCO 9 1/2 percent bonds maturing in about 21 years....
-
Vail Inc. manufacturers towels that are sells sold to hotels and resorts. Currently, the company has capacity to produce 600,000 towels per year; however, actual production is 520,000. Vail Inc....
-
Alpha Company receives.A note from one of its customers. It is a $20,000 60 day note at 9% interest (ordinary time). What will be the maturity value of the note when it is collected?
-
What is the output of the following code? public class Test5 { public static void main(String[] args) { int[][] matrix = {{1, 2, 3, 4), {4, 5, 6, 7), {8, 9, 10, 11), {12, 13, 14, 15}}; } } for (int i...
-
The state is beginning a new apprenticeship program for incarcerated individuals. Officials designed the program to improve the chances of inmates finding a job upon release and to increase the wages...
-
Diwana Ltd manufactures automobile accessories and parts. The following are the total costs and also the unit costs of processing a component, DIL-2010: Total Cost for 1,00,000 units Per unit Cost...
-
171.A copy machine acquired on March 1, 2011 with a cost of $1,410 has an estimated useful life of 3 years. Assuming that it will have a residual value of $150, determine the depreciation for the...
-
K The Verifine Department Stores, Inc. chief executive officer (CEO) has asked you to compare the company's profit performance and financial position with the averages for the industry. The CEO has...
-
Write a Go program that serves a simple REST API with endpoints for CRUD operations. Implement a concurrent web scraper in Go that can handle multiple URLs simultaneously. Create a Go routine that...
-
Define the following: (a) Audit instrument (b) Field notes (c) Life cycle of documents (d) Audit scope (e) Audit fatigue (f) Audit trail (g) Compliance
-
Teasdale Inc. manufactures and sells commercial and residential security equipment. The comparative unclassified balance sheets for December 31, 2015 and 2014 are provided below. Selected missing...
-
The PEW Research Institute recently conducted a survey of adult Americans regarding Internet shopping. The survey found that 15% of the respondents made a retail purchase on the Internet last week. A...
-
Using 2010 as the base period, compute a simple index of domestic sales for each year from 2011 until 2018. Interpret the trend in domestic sales. Johnson & Johnson Domestic Sales International Sales...
-
Using the following time series data of U.S. new car sales ($ millions), respondto the following items. Find Monthly Retail Trade Report, then select Time Series/Trend Charts to find the data for...
-
Earnings is calculated deducting: A. Dividends on ordinary shares. B. Dividends on preference shares. C. Tax expense. D. Interest expense.
-
Set out in Figure 16.10 are summarized balance sheets and income statements for F Co. for 20X1 and 20X2. You are required to: Figure 16.10 a. prepare a table of ratios, covering all aspects of...
-
Under IFRS, income statements are required to show: A. Extraordinary items. B. Unusual items. C. Exceptional items. D. None of the above.
Study smarter with the SolutionInn App