Just like the PowerPoint project, you can complete this assignment working together with a partner (only one). There is no need each partner to submit the assignment separately - just make sure both names appear in the file name and in the payroll register. Java Jive imports coffee and tea from around the world. Prepare) a worksheet that will calculate the weekly payroll for Java Jive’s five employees. The payroll register contains the following headings:
Instructions: 1. Open the attached “Excel Assignment.xlsx” file and name it “LastName_FirstInitial - Excel Assignment.xlsx”.
2. Set the page orientation to landscape. Change the student name(s) to your name(s).
3. Wrap the text in the column headings A4:J4 and A14:H14 in Sheet 1 and set the column width to (approximately) 10 for columns B to J.
4. Calculate the Gross Pay (F5:F9) using the following formula: Pay Rate times Regular Hours plus 1.5 times Pay Rate times O/T Hours.
5. Display the Taxable Benefits (G5:I9) in the following way: apply a formula/function to allocate and return the appropriate
weekly amount of Dental, Insurance, and Medical based on his/her Benefits Level and the corresponding taxable benefit to
this code in Sheet 2. The assumptions, the taxable benefit rates, and the tax rates (all in Sheet 2) may be subject to changes,
so all formulas should be created in a way so that they would reflect any changes in Sheet 2 automatically