It's Excel 2013 homework ( the steps that in the word file should be applied to

ebpxl56
timer Asked: Mar 12th, 2015

Question Description

It's Excel 2013 homework ( the steps that in the word file should be applied to the Excel file

NP_Excel2013_T5_P1b_AbdullahAlessa_1 (1).xlsx 

only ONE HOUR SIR

Unformatted Attachment Preview

New Perspectives Excel 2013 Tutorial 5: SAM Project 1b Fit Kix Footwear WORKING WITH TABLES, PIVOTTABLES, AND PIVOTCHARTS Author: Abdullah Alessa Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. Fit Kix Footwear - Westview Store Employees LastName FirstName Store Position Phillips Walters Vandergrift Wang Patterson Khatri Harris DiCristina Langman Pandey Potter Rosich Bajwa Freiberg Gabinelli Casey Morgan Adam Kevin Kiley Samir Zachary Jordan Emily Akasha Michael Mallory Guhan Gregory Jesse Westview Westview Westview Westview Westview Westview Westview Westview Westview Westview Westview Westview Westview Westview Westview Floor Floor Floor Register Register Manager Asst Manager Asst Manager Floor Register Floor Floor Register Floor Floor 2018 Hourly 2018 Weekly Rate Hours $8.00 15 $8.25 15 $8.00 25 $10.00 15 $10.25 20 $25.00 40 $18.75 35 $17.75 30 $8.50 10 $11.00 12 $8.25 15 $8.25 12 $10.50 25 $8.75 12 $8.25 12 2016 Wages $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 5,584 6,769 9,251 45,125 29,613 3,836 5,957 5,584 4,467 11,845 4,738 4,468 2017 Wages $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 5,700 5,878 7,125 9,738 47,500 31,172 25,294 4,038 6,270 5,878 4,703 12,469 4,988 4,703 2018 Wages $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 6,000 6,188 10,000 7,500 10,250 50,000 32,813 26,625 4,250 6,600 6,188 4,950 13,125 5,250 4,950 Fit Kix Footwear - Fontaine Store Employees LastName FirstName Store Position Foss Peterson Hu Lowe Little Kamiredi Jeffers Hirata Weaver Schultz Perez Silva George Diaz Griffiths Lee Ellen Kyle Alex Stephen Jenna Sonali Sonya Yuki Cassie Max Nina Alex Walter Gabriella Sandy Sammy Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Floor Register Floor Register Floor Manager Asst Manager Floor Floor Register Floor Register Register Asst Manager Asst Manager Register 2018 Hourly 2018 Weekly Rate Hours $8.00 15 $10.50 18 $8.00 12 $9.75 10 $8.75 20 $24.00 40 $15.75 24 $8.00 24 $8.25 12 $11.00 24 $8.25 24 $11.50 12 $10.50 10 $17.00 24 $17.00 24 $11.50 10 2016 Wages $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 8,529 4,400 7,897 43,320 17,057 4,467 11,913 8,935 6,227 4,738 18,411 18,411 5,189 2017 Wages $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 5,700 8,978 4,560 4,631 8,313 45,600 17,955 4,703 12,540 9,405 6,555 4,988 19,380 19,380 5,463 2018 Wages $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 6,000 9,450 4,800 4,875 8,750 48,000 18,900 9,600 4,950 13,200 9,900 6,900 5,250 20,400 20,400 5,750 Fit Kix Footwear - Willow Store Employees LastName FirstName Store Position Larsen Doherty Phelan Whitney Escada Kramer Yang Huang Ryan DeSouza Kong Rocha Shields Crowley Reinhardt Alisa Meghan Amrit Michael Julio Lars Doris Caitlin Elizabeth Jonathan Jason Angel Robert Declan Bettina Willow Willow Willow Willow Willow Willow Willow Willow Willow Willow Willow Willow Willow Willow Willow Floor Floor Register Register Floor Manager Register Asst Manager Floor Register Floor Floor Register Register Asst Manager 2018 Hourly 2018 Weekly Rate Hours $8.00 15 $8.25 15 $10.50 25 $10.00 15 $9.00 20 $23.00 40 $11.00 24 $16.50 30 $8.50 10 $11.00 12 $8.25 15 $8.25 12 $10.50 25 $11.75 10 $18.00 24 2016 Wages $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 5,584 11,845 6,769 8,123 41,515 11,913 22,337 3,836 5,957 4,467 11,845 5,302 19,494 2017 Wages $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 5,878 12,469 7,125 8,550 43,700 12,540 23,513 4,038 6,270 5,878 4,703 12,469 5,581 20,520 2018 Wages $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 6,000 6,188 13,125 7,500 9,000 46,000 13,200 24,750 4,250 6,600 6,188 4,950 13,125 5,875 21,600 Fit Kix Footwear - Highgate Store Employees LastName FirstName Store Position Coughlin Joyce McLaughlin Kumar Cote Kelly Martin Jiang McLaughlin Datta Sabot Rejto Silva Foster Boheim Meyers Andrew Liam Greg Ashok Francis Ryan Christina Wendy Greg Anjali Isaac Isabelle Daniela Paul Adin Kristin Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Floor Floor Floor Register Register Manager Asst Manager Asst Manager Floor Floor Register Floor Floor Register Floor Floor 2018 Hourly 2018 Weekly Rate Hours $8.00 12 $8.25 15 $8.00 25 $10.00 15 $10.25 20 $25.00 40 $18.75 35 $17.75 30 $8.00 25 $8.50 10 $11.00 12 $8.25 15 $8.25 12 $10.50 25 $8.75 12 $8.25 12 2016 Wages $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 5,584 9,025 6,769 9,251 45,125 29,613 24,029 9,025 3,836 5,957 11,845 4,738 4,468 2017 Wages $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 5,700 5,878 9,500 7,125 9,738 47,500 31,172 25,294 9,500 4,038 6,270 5,878 12,469 4,988 4,703 2018 Wages $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 4,800 6,188 10,000 7,500 10,250 50,000 32,813 26,625 10,000 4,250 6,600 6,188 4,950 13,125 5,250 4,950 Fit Kix Footwear - All Store Employees LastName FirstName Store Position Phillips Walters Vandergrift Wang Patterson Khatri Harris DiCristina Langman Pandey Potter Rosich Bajwa Freiberg Gabinelli Foss Peterson Hu Lowe Little Kamiredi Jeffers Hirata Weaver Schultz Perez Silva George Diaz Griffiths Lee Larsen Doherty Phelan Whitney Escada Kramer Yang Huang Ryan DeSouza Kong Rocha Casey Morgan Adam Kevin Kiley Samir Zachary Jordan Emily Akasha Michael Mallory Guhan Gregory Jesse Ellen Kyle Alex Stephen Jenna Sonali Sonya Yuki Cassie Max Nina Alex Walter Gabriella Sandy Sammy Alisa Meghan Amrit Michael Julio Lars Doris Caitlin Elizabeth Jonathan Jason Angel Westview Westview Westview Westview Westview Westview Westview Westview Westview Westview Westview Westview Westview Westview Westview Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Fontaine Willow Willow Willow Willow Willow Willow Willow Willow Willow Willow Willow Willow Floor Floor Floor Register Register Manager Asst Manager Asst Manager Floor Register Floor Floor Register Floor Floor Floor Register Floor Register Floor Manager Asst Manager Floor Floor Register Floor Register Register Asst Manager Asst Manager Register Floor Floor Register Register Floor Manager Register Asst Manager Floor Register Floor Floor 2018 Hourly 2018 Weekly Rate Hours $8.50 15 $8.25 15 $8.00 25 $10.00 15 $10.25 20 $25.00 40 $18.75 35 $17.75 30 $8.50 10 $11.00 12 $8.25 15 $8.25 12 $10.50 25 $8.75 12 $8.25 12 $8.00 15 $10.50 18 $8.00 12 $9.75 10 $8.75 20 $24.00 40 $15.75 24 $8.00 24 $8.25 12 $11.00 24 $8.25 24 $11.50 12 $10.50 10 $17.00 24 $17.00 24 $11.50 10 $8.00 15 $8.25 15 $10.50 25 $10.00 15 $9.00 20 $23.00 40 $11.00 24 $16.50 30 $8.50 10 $11.00 12 $8.25 15 $8.25 12 Shields Crowley Reinhardt Billings Coughlin Joyce McLaughlin Kumar Cote Kelly Martin Jiang McLaughlin Datta Sabot Rejto Silva Foster Boheim Meyers Robert Declan Bettina Christian Andrew Liam Greg Ashok Francis Ryan Christina Wendy Greg Anjali Isaac Isabelle Daniela Paul Adin Kristin Willow Willow Willow Willow Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Highgate Register Register Asst Manager Floor Floor Floor Floor Register Register Manager Asst Manager Asst Manager Floor Floor Register Floor Floor Register Floor Floor $10.50 $11.75 $18.00 $8.00 $8.00 $8.25 $8.00 $10.00 $10.25 $25.00 $18.75 $17.75 $8.00 $8.50 $11.00 $8.25 $8.25 $10.50 $8.75 $8.25 25 10 24 12 12 15 25 15 20 40 35 30 25 10 12 15 12 25 12 12 2016 Wages $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 5,584 6,769 9,251 45,125 29,613 3,836 5,957 5,584 4,467 11,845 4,738 4,468 8,529 4,400 7,897 43,320 17,057 4,467 11,913 8,935 6,227 4,738 18,411 18,411 5,189 5,584 11,845 6,769 8,123 41,515 11,913 22,337 3,836 5,957 4,467 2017 Wages $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 5,700 5,878 7,125 9,738 47,500 31,172 25,294 4,038 6,270 5,878 4,703 12,469 4,988 4,703 5,700 8,978 4,560 4,631 8,313 45,600 17,955 4,703 12,540 9,405 6,555 4,988 19,380 19,380 5,463 5,878 12,469 7,125 8,550 43,700 12,540 23,513 4,038 6,270 5,878 4,703 2018 Wages $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 6,375 6,188 10,000 7,500 10,250 50,000 32,813 26,625 4,250 6,600 6,188 4,950 13,125 5,250 4,950 6,000 9,450 4,800 4,875 8,750 48,000 18,900 9,600 4,950 13,200 9,900 6,900 5,250 20,400 20,400 5,750 6,000 6,188 13,125 7,500 9,000 46,000 13,200 24,750 4,250 6,600 6,188 4,950 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 11,845 5,302 19,494 5,584 9,025 6,769 9,251 45,125 29,613 24,029 9,025 3,836 5,957 11,845 4,738 4,468 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 12,469 5,581 20,520 5,700 5,878 9,500 7,125 9,738 47,500 31,172 25,294 9,500 4,038 6,270 5,878 12,469 4,988 4,703 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 13,125 5,875 21,600 4,800 4,800 6,188 10,000 7,500 10,250 50,000 32,813 26,625 10,000 4,250 6,600 6,188 4,950 13,125 5,250 4,950 Row Labels Bajwa Billings Boheim Cote Coughlin Crowley Datta DeSouza Diaz DiCristina Doherty Escada Foss Foster Freiberg Gabinelli George Griffiths Harris Hirata Hu Huang Jeffers Jiang Joyce Kamiredi Kelly Khatri Kong Kramer Kumar Langman Larsen Lee Little Lowe Martin McLaughlin Meyers Pandey Patterson Perez Peterson Phelan Total 2016 Wages Total 2017 Wages Sum of 2018 Wages $11,845 $12,469 13125 $0 $0 4800 $4,738 $4,988 5250 $9,251 $9,738 10250 $0 $5,700 4800 $5,302 $5,581 5875 $3,836 $4,038 4250 $5,957 $6,270 6600 $18,411 $19,380 20400 $0 $25,294 26625 $5,584 $5,878 6187.5 $8,123 $8,550 9000 $0 $5,700 6000 $11,845 $12,469 13125 $4,738 $4,988 5250 $4,468 $4,703 4950 $4,738 $4,988 5250 $18,411 $19,380 20400 $29,613 $31,172 32812.5 $0 $0 9600 $0 $4,560 4800 $22,337 $23,513 24750 $17,057 $17,955 18900 $24,029 $25,294 26625 $5,584 $5,878 6187.5 $43,320 $45,600 48000 $45,125 $47,500 50000 $45,125 $47,500 50000 $0 $5,878 6187.5 $41,515 $43,700 46000 $6,769 $7,125 7500 $3,836 $4,038 4250 $0 $0 6000 $5,189 $5,463 5750 $7,897 $8,313 8750 $4,400 $4,631 4875 $29,613 $31,172 32812.5 $18,050 $19,000 20000 $4,468 $4,703 4950 $5,957 $6,270 6600 $9,251 $9,738 10250 $8,935 $9,405 9900 $8,529 $8,978 9450 $11,845 $12,469 13125 Phillips Potter Reinhardt Rejto Rocha Rosich Ryan Sabot Schultz Shields Silva Vandergrift Walters Wang Weaver Whitney Yang Grand Total $0 $5,584 $19,494 $0 $4,467 $4,467 $3,836 $5,957 $11,913 $11,845 $6,227 $0 $5,584 $6,769 $4,467 $6,769 $11,913 $624,983 $5,700 $5,878 $20,520 $5,878 $4,703 $4,703 $4,038 $6,270 $12,540 $12,469 $6,555 $0 $5,878 $7,125 $4,703 $7,125 $12,540 $716,586 6375 6187.5 21600 6187.5 4950 4950 4250 6600 13200 13125 11850 10000 6187.5 7500 4950 7500 13200 788825 Row Labels Total 2016 Wages Total 2017 Wages Total 2018 Wages Fontaine $159,494 $178,149 $197,125 Asst Manager $53,879 $56,715 $59,700 Floor $21,299 $32,680 $44,000 Manager $43,320 $45,600 $48,000 Register $40,996 $43,154 $45,425 Highgate $169,265 $189,751 $203,488 Asst Manager $53,642 $56,466 $59,438 Floor $36,676 $50,184 $56,575 Manager $45,125 $47,500 $50,000 Register $33,821 $35,601 $37,475 Westview $137,237 $175,454 $195,063 Asst Manager $29,613 $56,466 $59,438 Floor $28,678 $35,887 $48,150 Manager $45,125 $47,500 $50,000 Register $33,821 $35,601 $37,475 Willow $158,987 $173,233 $193,150 Asst Manager $41,831 $44,033 $46,350 Floor $22,010 $29,046 $41,375 Manager $41,515 $43,700 $46,000 Register $53,631 $56,454 $59,425 Grand Total $624,983 $716,586 $788,825
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Content

Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors