No More Worries!

image Our orders are delivered strictly on time without delay

Paper Formatting

  • Double or single-spaced
  • 1-inch margin
  • 12 Font Arial or Times New Roman
  • 300 words per page

No Lateness!

image Our orders are delivered strictly on time without delay

Our Guarantees

image

  • Free Unlimited revisions
  • Guaranteed Privacy
  • Money Return guarantee
  • Plagiarism Free Writing

Sorting employees into alphabetical order

INSTRUCTIONS

Documents and Videos will be found under "Modules - Excel"

1 Open worksheet labled “Payroll Worksheet”
2 Adjust Colums so that you don’t see the #’s
3 Sort employees into alphabetical order. Make sure that all of the data is also sorted along with the employee.
4 Create a new column for “Last Name”. View file “Splitting Values Seperated by Commas” and separate First and Last names into columns A & B.
5 Create a new column for Department and add the department for each employee as detailed on the solution.

The next steps must be done WITH FORMULAS.If you don’t use correct formulas then you will not receive credit.

6 Write a formula that will calculate the “regular pay” for Pieter Brucker. Use the autofill function to calculate regular pay fr the rest of the employees.
7 Write a formula to calculate overtime pay for Pieter Brucker. Drag the formula down for the rest of the employees. Overtime pay is 1.5 times regular pay.
8 Write a formula to calculate “gross pay” for Pieter Brucker. Drag the formula down for the rest of the employees.
9 Watch Video “Excel – Absolute Reference”. Write a formula (using absolute reference), to calculate Gross Pay “with raise”. Write to formula to reference to cell J1. Drage the formual through to the rest of the employees. Test the formula to see if it works by changing the “Proposed Raise” in cell J1 to 15%. All of the number in the “with raise” column should change.
10 Using AutoSum create total sums for columns B, C, E, F, G, H
11 Add a new employee. Luca Pacioli as Office Staff making $24/hr working 40 hours with 20 overtime hours. Make sure that the sums across the bottom change when you add the numbers. If they don’t then you have done something wrong with your formula.
12 Round all numbers to have 0 decimal places.
13 Format the spreadsheet as you see on the solution with borders, bold, italics and highlights as shown in the solution.
14 Use the Average Function to get an average of hours worked and average hourly rate. Look up how to use this function online.
15 Watch SUMIF video. Using the SUMIF function, sum the total Pay by Department. Watch the SUMIF video. Please note that if you drag the formula down to cells C36:C41 that you will need to make the “range” and s”sum range” absolute.
16 Use “AutoSum” funtion to total cells C:35 through C41. The totals of cell C42 and J28 should be equal
17 Using the “Quick Analysis” tool create a clustered column chart. Highlight cells C4:C41 and click on the “Quick Analysis” tool in the right corner of the cell range..
18 Your spreadsheet should look exactly like the solutution posted on the solution Worksheet.

NEXT - complete the 3 VLOOKUP and Chart Questions

Sample Solution

Through statistics alone, it is already evident that the English is superior to any other language within economic and business sectors across the world. Corporate giants such as Nokia and Samsung are becoming advocates for English as their “language of business”, to serve customers, build international connections, and overtake business competitors worldwide – using the English language as their lingua franca within business strategies. Even as pidgin English, consumers and business executives alike are much more likely to use the English language in plans, projects and trade deals than other languages such as Mandarin Chinese which said to be vital to global economics. This is due to the complex nature of Chinese as a foreign language, and the embedded history of English in many parts of the world due to historical colonisation. Pidgin English is a “grammatically simplified form of a language … some elements … [are] … taken from local languages … [and] … used for communication between people … [as a] … common language.” (Oxford Dictionary, 2018). ¬¬ Although the English language may be of significance within the business world, French should not be neglected as an important language within economics and education. Examining the language needs of Great Britain as a nation, there are skills which the English language lacks when referring to indexes such as current exportation from the UK, language activities of the general public, and immigration/emigration within the European and French speaking population. Results of a 2015 survey conducted by the British Council place French as the third most favourable foreign language in global trade after Spanish and Arabic, and third in the top ten most important export markets in 2012 following German and Dutch. Furthermore, 49% of British multinational corp
PLACE AN ORDER NOW

Price Calculator

Subject:
Type:
Pages/Words:
Single spaced
approx 275 words per page
Urgency:
Level:
Currency:
Total Cost:

12% Discount

image

  • Research Paper Writing
  • Essay Writing
  • Dissertation Writing
  • Thesis Writing

Why Choose Us

image

  • Money Return guarantee
  • Guaranteed Privacy
  • Written by Professionals
  • Paper Written from Scratch
  • Timely Deliveries
  • Free Amendments