1. Brittany Lambert is a volunteer for the Brevard County Swim Clubs in Melbourne, Florida, and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Brittany Lambert is a volunteer for the Brevard County Swim Clubs in Melbourne, Florida, and has offered to compile data on the swim club employees and teams. She needs your help completing the workbook and analyzing the data. Switch to the All Employees worksheet. In cell E3, enter a formula using the HLOOKUP function as follows to determine an employee's potential pay rate, which is based on their years of experience: a. b. Use a structured reference to look up the value in the Years of Experience column. Retrieve the value in row 2 of the table in the range P14:U15, using an absolute reference. Because hourly pay rate is tiered based on the number of years of experience, find an approximate match. Fill the formula into the range E4:E32, if necessary. 33 Employee ID 3 A313 4 8534 5 8681 6 CB36 7 1724 8 0629 9 G875 10 1608 11 1869 12 M893 23 N352) 14 0943 15 P408 6 P492 17 P633 8 0967 0752 20 $639 17598 12 188 13 V188 24V420 5 V735 E W209 Function be Name Tiffany Adams Hassan Bachim Megan Beckman Catherine Coleman Carrie Faulkner Paul Gomez Bryant Grossburg Marilyn Jesberger Jonathan Lampert Gina Milota Jeff Newman Crystal Olneck Yolanda Padilla Michael Pienkowski Keith Pienkowski James Quinlan Ryan Quinlan Andrea Shelby Anna Tran Tracy Uphoff Javier Vazquez Jose Vasques Alexa Vanderson Dale Wong Documentation Ap C Age 22 19 19 28 24 124 18 21 25 21 31 33 18 25 34 24 20 36 19 inction Manage from Stedine Amateur window Watch Can Ca Optiem Des 23 18 22 18 28 Mebauhe Swen Teame D Years of Experience Pay Rate Cert. Tear CPR Trained 2018 Yes 2022 No 2033 2017 2015 4 16 6 0 3 5 3 3 5 0 7 6 4 2 18 3 15 0 4 0 4 Hebaume PyotTible 2018 2033 2019 2019 2030 2020 2018 2033 2017 2018 2000 3000 2017 G 2021 2017 2003 2018 2023 2018 Al Tea Table Yoo Yes Yes Yes No No Yes Yes No Yes No H Lifeguard You No No No Yes Yes No No Yes No No No No You HE Yes Yes BEAT Yes Yes No Yes Yes No Yes No Yes No Yes No Yes No Yes No No No Yes Instructor Yes No No Yes No No No No Yes No No No No Yos No Yes Yes No Yes No 2222 No Camp Counselor 1. Brittany Lambert is a volunteer for the Brevard County Swim Clubs in Melbourne, Florida, and has offered to compile data on the swim club employees and teams. She needs your help completing the workbook and analyzing the data. Switch to the All Employees worksheet. In cell E3, enter a formula using the HLOOKUP function as follows to determine an employee's potential pay rate, which is based on their years of experience: a. b. Use a structured reference to look up the value in the Years of Experience column. Retrieve the value in row 2 of the table in the range P14:U15, using an absolute reference. Because hourly pay rate is tiered based on the number of years of experience, find an approximate match. Fill the formula into the range E4:E32, if necessary. 33 Employee ID 3 A313 4 8534 5 8681 6 CB36 7 1724 8 0629 9 G875 10 1608 11 1869 12 M893 23 N352) 14 0943 15 P408 6 P492 17 P633 8 0967 0752 20 $639 17598 12 188 13 V188 24V420 5 V735 E W209 Function be Name Tiffany Adams Hassan Bachim Megan Beckman Catherine Coleman Carrie Faulkner Paul Gomez Bryant Grossburg Marilyn Jesberger Jonathan Lampert Gina Milota Jeff Newman Crystal Olneck Yolanda Padilla Michael Pienkowski Keith Pienkowski James Quinlan Ryan Quinlan Andrea Shelby Anna Tran Tracy Uphoff Javier Vazquez Jose Vasques Alexa Vanderson Dale Wong Documentation Ap C Age 22 19 19 28 24 124 18 21 25 21 31 33 18 25 34 24 20 36 19 inction Manage from Stedine Amateur window Watch Can Ca Optiem Des 23 18 22 18 28 Mebauhe Swen Teame D Years of Experience Pay Rate Cert. Tear CPR Trained 2018 Yes 2022 No 2033 2017 2015 4 16 6 0 3 5 3 3 5 0 7 6 4 2 18 3 15 0 4 0 4 Hebaume PyotTible 2018 2033 2019 2019 2030 2020 2018 2033 2017 2018 2000 3000 2017 G 2021 2017 2003 2018 2023 2018 Al Tea Table Yoo Yes Yes Yes No No Yes Yes No Yes No H Lifeguard You No No No Yes Yes No No Yes No No No No You HE Yes Yes BEAT Yes Yes No Yes Yes No Yes No Yes No Yes No Yes No Yes No No No Yes Instructor Yes No No Yes No No No No Yes No No No No Yos No Yes Yes No Yes No 2222 No Camp Counselor
Expert Answer:
Answer rating: 100% (QA)
Let us first understand the HLookup function of excel and then we shall put the right formula needed ... View the full answer
Related Book For
Concepts in Federal Taxation
ISBN: 9780324379556
19th Edition
Authors: Kevin E. Murphy, Mark Higgins, Tonya K. Flesher
Posted Date:
Students also viewed these accounting questions
-
Develop a request for proposal to replace the current computerized system for Business Solutions. The document should include All of the business requirements, Expansion plan for Business Solutions,...
-
The use of a ''flat tax'' to replace the current income tax system has received a considerable amount of interest in recent years. Various flat-tax proposals have been made, but the gist of a flat...
-
Your Block 1 for your Business Plan will require that you develop the following objectives which will be integrate part of the first five sections of the business plan. As a model and guide use the...
-
Preparing and interpreting a statement of cash flows using a T-account work sheet. Financial statement data for Dickerson Manufacturing Company for the current year appear in Exhibit 5.29. Additional...
-
Answer the following questions on the basis of the monopolists situation illustrated in the following graph. a. At what output rate and price does the monopolist operate? b. In equilibrium,...
-
Write the complete and net ionic equations for the neutralization reaction between H2C2O4(s) and Sr(OH)2(aq). Assume the salt is insoluble.
-
For the reaction \(\mathrm{N}_{2}(\mathrm{~g})+3 \mathrm{H}_{2}(\mathrm{~g}) ightarrow 2 \mathrm{NH}_{3}(\mathrm{~g})\), maximum conversion can be achieved if the reaction takes place at (a) Low...
-
At December 31, 2012, the trading securities for Oglesbee, Inc. are as follows. Instructions(a) Prepare the adjusting entry at December 31, 2012, to report the securities at fair value.(b) Show the...
-
1. Which of the 4 costs of quality due you believe is the most detrimental to an organization? Provide an example and support your opinion.
-
Jordan and Julianne Marra both work. Julianne is a part-time environmental lawyer whose W-2 provided the following information. Wages, tips, other compensation: $51,122.00 Social Security wages:...
-
Identify and discuss factors that affect both Net Export and Net Capital Outflow (250-300 words)
-
Choose a professional blog of interest to you. Read a minimum of ten posts. Then, in one to two pages, respond to the following questions: A. What is the name and web address of the blog? B. What is...
-
The Sorry Charlie Tuna Company produces canned tuna fish. The true mean weight of a can of tuna is 6 oz with a standard deviation of 1 oz. Assume the population is normally distributed, and suppose...
-
Reread the three examples of personal social media use that hurt employers (see the beginning of the Using Social Media Ethically section). For each item, do the following: A. Explain why the social...
-
Construct task-oriented routine messages, including requests, expectations, directions, responses to inquiries, announcements, and claims.
-
In Freeport High School, 40 % of the seniors who are eligible to vote indicated that they plan to vote in the upcoming election. What is the probability of selecting a random sample of 400 students...
-
Checks and balances play a vital role in the business landscape, ensuring accountability and transparency. Understanding a company's financial health remains a perpetual necessity. Through this...
-
To help you become familiar with the accounting standards, this case is designed to take you to the FASBs Web site and have you access various publications. Access the FASBs Web site at...
-
Determine the amount realized in each of the following property dispositions: a. Umberto wants to buy Kevin's truck. Because Umberto has no cash and cannot obtain a loan to finance the purchase,...
-
Kris starts a new business in 2011. She purchases 7-year MACRS property costing $12,000. Her business income before any cost-recovery deductions is $8,000. Kris does not want to claim bonus...
-
Sterling is a college professor with an extensive stock portfolio. Last year, he met Wheeler, a stockbroker with the firm of Ransom, LaForge, and Adkins. To get Sterlings business, Wheeler offered to...
-
Let \(P(A \cap \bar{B})=0.3\) and \(P(\bar{B})=0.6\). Determine \(P(A \cup B)\).
-
Is it possible that for two events \(A\) and \(B\) with \(P(A)=0.4\) and \(P(B)=0.2\) the relation \(P(A \cap B)=0.3\) is true?
-
Check whether for 3 arbitrary random events \(A, B\), and \(C\) the following constellations of probabilities can be true: (1) \(P(A)=0.6, P(A \cap B)=0.2\), and \(P(A \cap \bar{B})=0.5\), (2)...
Study smarter with the SolutionInn App