Time remaining:
spreadsheet

Other
Tutor: None Selected Time limit: 0 Hours

1.Create a manager summary report that includes head count and salary by manager. ◦Insert a pivot table on a new worksheet. ◦Choose "Manager," "Job Title," and "Full Name" as row labels. Limit the Manager Row labels to the 3 managers only (exclude the CEO and CEO direct reports as well as any blank data). ◦Choose "Full Name" and "Salary" as sum values, and change the Sum of Salary to Average of Salary. Format the Salary listing to be currency, rounded to whole dollars. ◦There should be a Summary line for each manager showing total head count and average salary. ◦Name the new worksheet "Heads and Salary By Manager." 2.Create a pie chart depicting the head count by job title. ◦Insert a pivot chart on a new worksheet. Change the chart type to "Pie." ◾For Mac users, create a pivot table then create a chart from that table. ◦Choose "Job Title" as the Category (exclude the CEO job description as a category). ◦Choose "Job Title" as sum values, and show the head count as a data label on each slice. Add a chart title called "Head Count by Job Title." Name the new worksheet "Heads By Job Title Pie." 3.Create a professional memo to the CEO in Microsoft Word, making sure you cover the following: ◦Manager summary pivot table ◦Head count pie chart ◦Brief summary of the organization and of the report
Sep 18th, 2013
Hi, am an expert in writing equipped with vast knowledge. Can I help you with this assignment? My work is original and of high standard. I assure you that you will not regret entrusting me with your work
Sep 18th, 2013

Did you know? You can earn $20 for every friend you invite to Studypool!
Click here to
Refer a Friend
...
Sep 18th, 2013
...
Sep 18th, 2013
Mar 27th, 2017
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle
Final Answer

Secure Information

Content will be erased after question is completed.

check_circle
Final Answer