q3 - 3 PROMBLEM: Use the most efficient Excel tool or...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
3 PROMBLEM: Use the most efficient Excel tool or command to find the total salary for each department as well as the grand total. This tool or command will display the result as shown in the sample table. Name the worksheet Problem #3 . Describe your finding in the Word document saying which tool you used, and which two departments have the most salary expense along with what those salary expenses are. Include a table as shown below listing the total salary of each department and the grand total. ANSWER: First Name Last Name Department Title Salary Hire Date Samuel Gates Engineering Engineer 66,300 1/28/97 Nemesha Mehta Engineering Engineer 65,000 10/1/95 Patti Stonesifer Engineering Engineer 64,300 7/6/98 Phyllis Leonard Engineering Engineer 59,800 12/13/96 Frederich Bednarczyk Engineering Engineer 56,700 5/14/99 Francine Detweiler Engineering Engineer 56,700 10/10/95 Sharad Manispour Engineering Manager 54,500 10/13/90 Edgar Rothrock Engineering Engineer 53,300 2/8/94 Michael Goldstein
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/14/2009 for the course BAEN 14354 taught by Professor Morgan during the Spring '09 term at Texas A&M.

Page1 / 2

q3 - 3 PROMBLEM: Use the most efficient Excel tool or...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online