Question: Using the data on employee data worksheet answer the pivot table on the sales person worksheet to calculate the percentage of grand total each position

Using the data on employee data worksheet answer the pivot table on the sales person worksheet to calculate the percentage of grand total each position makes up in each region

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 General Management Questions!

Question 1 The data for question 1 is located on the worksheet names Software. The worksheet contains a database containing information related to a software company's sales of network and database...

The data for question 1 is located on the worksheet names Software. The worksheet contains a database containing information related to a software company s sales of network and database software to...

please answer instructions 1-9 for a like! please and thank you! Y019_Excel_Ch06_Prepare_PartB_Sales_Analysis Project Description: Aleeta Herriott manager of the Red Blut Pro Shop, would like to...

Aleeta Hecciatt, manager of the Red Bluff Pro Shop, would like to develop a marketing strategy for increasing pro shop patronage. She has requested data about the pro shop sales over the past several...

A1 x fx Pro Shop Sales Database B D E F G H K L 1 Pro Shop Sales Database 2 3 TransID 4 P000100 5 P000101 6 P000102 7 P000103 8 P000104 9 P000105 10 PO00106 11 P000107 12 P000108 13 PO00109 14...

1 . 5 Using the data on the Employee Data worksheet, insert a PivotTable on the "Position" worksheet to calculate the percentage of employees for each type of position by region. a . Construct the...

Instructions Start Excel. Download and open the file named Exp19_Excel_Ch05_ML1_RealEstate.xlsx. Grader has automatically added your last name to the beginning of the filename. Before subtotaling the...

please answer 11-20 on the instructions for a like! please and thank you! Complete the Database Totals worksheet using the appropriate database functions using the Sales Database named range use...

An analyst believes that the price of an IBM stock is a normally distributed random variable with mean $105 and variance 24. The analyst would like to determine a value such that there is a 0.90...

When mixing two types of atoms, say A and B, will atoms always diffuse from regions of higher concentrations to regions of lower concentrations? Explain either in words or with a graph.

This is a partial adjusted trial balance of Crane Company.CRANE COMPANY Adjusted Trial Balance January 3 1 , 2 0 XX Answer these questions, assuming the year begins January 1 . ( a ) If the amount in...

PLEASE SHOW WORK AND FORMULAS. THANK YOU. You are asked to present an investment analysis of a new small residential income producing property for sale to a potential investor. The asking price for...