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...
-
Suppose the perturbation (t) is proportional to t, that is, (t) = t for some constant . Show directly that the following initial-value problems are well-posed. a. y' = 1 y, 0 t 2, y(0) = 0 b. y' =...
-
An ideal gas at 100 kPa and 27C enters a steady-flow compressor. The gas is compressed to 400 kPa, and 10 percent of the mass that entered the compressor is removed for some other use. The remaining...
-
Consider the following cash flow profile and assume MARR is 10 percent/year. a. What does Descartes' rule of signs tell us about the IRR(s) of this project? b. What does Norstrom's criterion tell us...
-
Goose down is used in a wide variety of products, including jackets, bedding, and pillows. In recent years, the cost of down has been increasing. For example, in October 2010, Lands End, a retailer...
-
Write a three page paper on Compare and contrast Online Analytic Processing (OLAP) and Online Transaction Processing (OLTP); also discuss Codds rules for TP databases and OLAP databases. Cite any...
-
Rosh Corporation is planning to issue bonds with a face value of $800,000 and a coupon rate of 8 percent. The bonds mature in four years and pay interest semiannually every June 30 and December 31....
-
Watch the videos and create your own thread discussing at least three concepts presented in or that you learned from the video. As a note, each student must chose a different video (you cannot use a...
-
Which of the functions of communication do you think Kevin Johnson uses when he is involved in a Partner Connection Tour? Are the communication functions any different when he uses the internal...
-
What are the key features of the normative and descriptive decision theory?
-
How can the various areas within business administration be classified?
-
What are the characteristics of an economic entity?
-
What characterizes internal services?
-
Use the project information contained in the attached Excel file to determine the initial: 1. Project duration & completion date 2. Critical path (CP) 3. Slack for activities not on the CP Please use...
-
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...
-
Solve the Gross-Pitaevskii equation and evaluate the mean field energy, see equations (11.2.21) and (11.2.23), for a uniform Bose gas to show that this method yields precisely equation (11.2.6).
-
Solve the Gross-Pitaevskii equation and evaluate the mean field energy, see equations (11.2.21) and (11.2.23), for an isotropic harmonic oscillator trap with frequency \(\omega_{0}\) for the case \(N...
-
Assuming the Dieterici equation of state \[P(v-b)=k T \exp (-a / k T v)\] evaluate the critical constants \(P_{c}, v_{c}\), and \(T_{c}\) of the given system in terms of the parameters \(a\) and...
Study smarter with the SolutionInn App