how fast can be done ,Copy and Paste Your Assignment Here
Lab 10 Question 2Question 3Question 4Question 5Question 6Question 7 Employee NumberNameSatisfactionJob StatusEvaluationSatisfaction BonusEvaluation BonusSatisfaction Bonus Data (For Q6) 110$0.00 3$10,000.00 5Question 8Question 9Question 10Question 11Question 12Question 135$15,000.00 Hire DateDate of BirthLocationSalaryTax CommentTax Rate7$25,000.00 Marks9$50,000.00 1) Name cells A3, C3, E3 and E7 to whatever appears above that cell. Ie A3 would be named "Employee_Number". Name the follownig ranges, J3:K8 212$100,000.00 "Satisfaction_Bonus_Your INITIALS", J11:K14 "Evaluation_Bonus_Your INITIALS, J17:L21 Tax_and_Comment_Data_Your INITIALS. Finally, name the range A2:I64 (This is on the data worksheet) to Employee_Data_Your INITIALS. For example, I would name A2:I64 "Employee_Data_RS". All functions must use range names!Evaluation Bonus Data (For Q7) 2) In cell B3 create a vlookup function that displays the name of the employee based on the Employee # entered in A3 and the info on the "Data" worksheet1Poor$0.00 3) In cell C3 create a vlookup function that displays the Satisfaction of the employee based on the Employee # entered in A3 and the info on the "Data" worksheet1Satisfactory$20,000.00 4) In cell D3 create a vlookup function that displays the Job Status of the employee based on the Employee # entered in A3 and the info on the "Data" worksheet1Good$30,000.00 5) In cell E3 create a vlookup function that displays the Evaluation of the employee based on the Employee # entered in A3 and the info on the "Data" worksheet1Excellent$50,000.00 6) In cell F3 create a vlookup function that outputs the Satisfaction Bonus for the employee based on the Satisfaction displayed in C3 and the info in the Satisfaction Bonus Data. For example, if they have a satisfaction of 3 they would get a bonus of $10,000 and a satisfaction of 2 would get them $01 Tax Rate and Comment Data (For Q12-13) 7) In cell G3 create a vlookup function that outputs the Evaluation Bonus for the employee based on the Evaluation displayed in E3 and the info in the Evaluation Bonus Data. For example, if they have an evaluation of Excellent they would get a bonus of $50,0001$0.00Great12% $25,000.00Good18% 8) In cell B7 create a vlookup function that displays the Hire Date of the employee based on the Employee # entered in A3 and the info on the "Data" worksheet1$35,000.00OK22% 9) In cell C7 create a vlookup function that displays the Date of Birth of the employee based on the Employee # entered in A3 and the info on the "Data" worksheet1$50,000.00Meh25% 10) In cell D7 create a vlookup function that displays the Location of the employee based on the Employee # entered in A3 and the info on the "Data" worksheet1$75,000.00Yuck30% 11) In cell E7 create a vlookup function that displays the Salary of the employee based on the Employee # in A3 and the info on the "Data" worksheet1 12) In cell F7 create a vlookup function that outputs the correct Tax Comment for the employee based on the Salary entered in E7 and the info in the Tax Rate and Comment Data. For example, if they have a Salary of $30,000 their comment would be "Good", $45,000 gets them "OK"1Average Salary of all employees 13) In cell G7 create a vlookup function that outputs the correct Tax Rate for the employee based on their Salary entered in E7 and the info in the Tax Rate and Comment Data. For example, if they have a Salary of $77,000 they would be at 30%, $20,500 gets them to 12%1 14) In cell J24 use a simple worksheet reference from the Data worksheet to display the average salary of all employees calculated in I65 on the "Data" worksheet1 15) On the Image worksheet, use wordart to add your full name across the entire page. Set the font size to anything over 100. Add a glow text effect of your choice1 16) On the Image worksheet, fill the range A1:AZ80 sheet with a custom colour of your choice. 1 17) On the Image worksheet, add at least two pictures of your choice but make sure they are exactly the same size. Add an artistic effet to one and recolour the next.1 Lab Mark /18 As the boss of ACME Toilet Co. you need to create a worksheet that gives you quick access to information specific to each individual employee by simply typing in the employee number into cell A3. When done, save as "YourFirstName YourLastName Lab 10" and submit via DC Connect ACME Toilet Test your functions by using different employee numbers We flush Everything Down! Company Data Employee #NameHire DateDate of BirthSatisfactionLocationJob StatusEvaluationSalary 115Abe02,Oct,201006,May,19596U.S.FTGood$63,583.00 85Amanada23,Feb,201111,Sep,197512CanadaFTGood$80,327.00 125Barb11,Aug,201225,Jul,19733U.S.FTExcellent$84,044.00 65Bob16,Oct,200908,Aug,197711BrazilFTExcellent$50,306.00 11Brianna19,Jun,201211,Sep,19672U.S.FTGood$47,890.00 47Catherine17,Aug,201116,May,19651MexicoPTExcellent$74,939.00 37Charlie21,Sep,201010,Jun,197910U.S.FTGood$42,782.00 55David23,Aug,201101,Jul,19741CanadaPTSatisfactory$44,659.00 103Debra10,Feb,201214,Mar,197510U.S.PTSatisfactory$72,827.00 23Dex03,Jul,201023,May,19578BrazilFTGood$55,183.00 79Dirk09,Oct,201108,Sep,19704U.S.FTExcellent$75,017.00 29Don22,Jul,201124,Feb,19795U.S.PTExcellent$75,284.00 31Doug25,Aug,201215,May,196412U.S.PTSatisfactory$36,409.00 13Fran14,Jun,201129,Oct,197512CanadaFTPoor$49,169.00 15Frank17,Jul,200915,Nov,19811EnglandFTPoor$49,274.00 67Garth29,Sep,201209,Apr,19737CanadaFTExcellent$52,306.00 117Gary03,May,201127,Jan,19725U.S.FTExcellent$65,075.00 121Genny20,Jun,201106,Apr,19609U.S.FTGood$74,302.00 35Hank06,May,201224,Sep,19607CanadaFTSatisfactory$37,601.00 83Harry21,Jul,200902,Apr,19631U.S.PTGood$79,113.00 89Heather19,Sep,200917,Aug,196312MexicoFTExcellent$83,635.00 91Heather02,Jul,201128,Jun,19636BrazilFTGood$36,974.00 105Iggy08,Mar,201213,Jul,197912U.S.FTSatisfactory$74,263.00 59Jack17,Sep,201002,Sep,19703CanadaFTGood$45,821.00 81Jasper28,Apr,201114,Jul,19754U.S.PTPoor$76,061.00 109Jay22,Sep,200921,Oct,196210CanadaFTGood$45,973.00 95Jill28,May,201111,Feb,19658U.S.FTSatisfactory$56,453.00 71Jimmy14,Jan,201110,Mar,19656U.S.FTGood$63,539.00 53Jocelyn06,May,201007,Jul,19694U.S.FTGood$43,681.00 33John22,Jun,201227,Dec,19705U.S.FTPoor$36,951.00 43Krum15,Aug,201122,Sep,196811CanadaFTExcellent$66,282.00 25Lanny02,Aug,201101,Dec,19557CanadaFTSatisfactory$57,470.00 41Larry27,Sep,201105,May,19755U.S.FTGood$54,779.00 97Lester14,Jul,201216,Nov,19617CanadaFTExcellent$56,944.00 77Linda15,Oct,201222,Mar,19589CanadaFTExcellent$72,410.00 93Louise24,Oct,201126,Feb,19791U.S.FTSatisfactory$42,979.00 21Lucy24,Feb,201225,Dec,19642U.S.PTGood$51,673.00 57Mack21,Nov,201117,Aug,19619EnglandPTGood$45,255.00 45Maddie15,Jul,201018,Nov,19729U.S.FTGood$69,601.00 119Marnie08,Aug,201006,May,19625CanadaPTGood$66,740.00 3Martin09,Jul,201127,Feb,195511U.S.PTGood$37,207.00 61Mary25,May,201217,May,198012U.S.FTGood$49,361.00 75Matt18,Feb,201021,Jul,19633U.S.FTGood$70,653.00 27May26,Aug,200915,Jan,19727U.S.FTGood$74,394.00 5Michael13,Oct,201206,Nov,19605MexicoPTPoor$40,912.00 111Missy27,Apr,201024,Mar,19756U.S.FTPoor$47,333.00 99Nadine30,Dec,201015,Sep,19659EnglandFTExcellent$57,081.00 39Nigel23,Jan,201102,May,19796U.S.FTPoor$51,826.00 113Olivia08,Sep,201121,May,19725U.S.FTExcellent$48,985.00 107Pauline19,Jan,201228,Dec,19737BrazilFTExcellent$42,622.00 17Pravin06,Jun,201207,Sep,19794CanadaFTSatisfactory$50,595.00 123Quorin09,Jun,201206,Apr,196011U.S.FTExcellent$77,466.00 1Reggie17,Oct,200918,Sep,19695CanadaFTPoor$35,513.00 19Rhonda27,May,201027,Oct,19581U.S.FTGood$50,688.00 7Rosie14,Aug,201124,Oct,19551BrazilFTPoor$44,621.00 51Shannon22,May,201005,Jun,19721U.S.FTExcellent$43,061.00 87Stan02,Jul,201128,Jun,195810U.S.FTSatisfactory$83,404.00 9Tamara23,Aug,200910,Aug,196911U.S.FTSatisfactory$47,305.00 69Tammy12,Feb,201002,Jun,196810U.S.FTGood$58,250.00 63Tara24,Jan,201201,Nov,19685U.S.FTGood$49,373.00 49Taya13,Sep,200908,Apr,19667BrazilFTExcellent$81,095.00 101Timothy05,Oct,201119,Jul,19702CanadaPTExcellent$71,085.00 73Vic24,Feb,201223,Dec,19704U.S.PTPoor$68,372.00 Average Salaries$57,758.35 Image