1. Luke Alberto is the director of the Academic Support Center at Ocean Side College. He...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Luke Alberto is the director of the Academic Support Center at Ocean Side College. He started planning the tutoring staffing assignments for the upcoming academic year in an Excel table. Luke needs your help completing the table. First, he'd like to confirm that all the staff data was entered correctly into the worksheet. Go to the Staff Listing worksheet and complete the following steps: Apply a conditional formatting Highlight Cells Rule to the range A2:A31 that formats any duplicate values with Light Red Fill with Dark Red Text. a. b. Correct the duplicate values by updating the Employee ID for Terri Ortez to 2026 and the Employee ID for Veola Huie to 2030. (Hint: When this sub-step is completed, the conditional formatting rule should no longer highlight any values in the range.) Delete the conditional formatting rule applied to the range D2:D31. In cell E2, enter a formula using the HLOOKUP function and structured references to determine a staff member's pay rate (which is based on the number of years of service). Use a structured reference to look up the value in the Service Years column. Retrieve the value in the 2nd row of the table in the range Q15:U16. Since staff members do not receive a raise after every year of service, find an approximate match. a. b. Fill the formula into the range E3:E31 if necessary. 1. Luke Alberto is the director of the Academic Support Center at Ocean Side College. He started planning the tutoring staffing assignments for the upcoming academic year in an Excel table. Luke needs your help completing the table. First, he'd like to confirm that all the staff data was entered correctly into the worksheet. Go to the Staff Listing worksheet and complete the following steps: Apply a conditional formatting Highlight Cells Rule to the range A2:A31 that formats any duplicate values with Light Red Fill with Dark Red Text. a. b. Correct the duplicate values by updating the Employee ID for Terri Ortez to 2026 and the Employee ID for Veola Huie to 2030. (Hint: When this sub-step is completed, the conditional formatting rule should no longer highlight any values in the range.) Delete the conditional formatting rule applied to the range D2:D31. In cell E2, enter a formula using the HLOOKUP function and structured references to determine a staff member's pay rate (which is based on the number of years of service). Use a structured reference to look up the value in the Service Years column. Retrieve the value in the 2nd row of the table in the range Q15:U16. Since staff members do not receive a raise after every year of service, find an approximate match. a. b. Fill the formula into the range E3:E31 if necessary.
Expert Answer:
Answer rating: 100% (QA)
Answer with Explanation Go to the Staff Listing worksheet and complete the following steps Apply a conditional formatting Highlight Cells Rule to the range A2A31 that formats any duplicate values with ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
In the following extensive form game one of the Nash equilibrium outcome involves an empty/non-credible threat. Which one? a. (D,R) b. (D,M) c. Both (D,M) and (D,R) d. (U,L) 1 U D (3,3) 2 L M (0,0)...
-
Joyce is the director of manufacturing for Titan Industries, which is considering building a new facility in the Midwest. The demand for the product manufactured in the facility will be either strong...
-
Elizabeth Jablonski is the director of Research and Development for Galaxy Electronics. Last week, she submitted the following funding request as part of the annual budget process. Project Funding...
-
How does the organization's mission, vision, values, and strategies shapes the organizational culture and develop culture for change?
-
Consider the grid of points shown at the top of the next column. Suppose that, starting at the point labeled A, you can go one step up or one step to the right at each move. This procedure is...
-
Art Binley has decided to look at his productivity from a multi factor (total factor productivity) perspective (refer to Solved Problem 1.1). To do so, he has determined his labor, capital, energy,...
-
A Gallup poll taken in May 2016 asked 1025 adult Americans to state their opinion on the availability of abortions. The following table presents the results, along with the proportions of people who...
-
Flint Fabricators Inc. machines metal parts for the automotive industry. Under the traditional manufacturing approach, the parts are machined through two processes: milling and finishing. Parts are...
-
Find the limit and explain why it doesn't exist. lim 2x 4 (x,4)-> (0,0) X4 +242
-
Morrow Enterprises Inc. manufactures bathroom fixtures. The stockholders' equity accounts of Morrow Enterprises Inc., with balances on January 1, 20Y5, are as follows: Common Stock, $20 stated value...
-
On February 19, 2015, Reggie and Mick form IClude Corporation as equal 50/50 shareholders with the following investment, for which each received 1,000 shares of IClude Corporation stock: From Reggie...
-
Milo is purchasing a new refrigerator for $2300 using an in-store offer. The store is offering a 60 days same-as-cash loan. This means that at the end of the 60 days, if Milo has paid off the cost of...
-
A young engineer designs a simple cipher based on Shannon's concept of a "product cipher". The ciphertext output, y, is generated by applying an affine cipher to the plaintext, x, to produce an...
-
A current situation in the economy or at your company that might necessitate hedging. Do you think companies should hedge away these types of risks, or leave it to their investors to do? What are the...
-
A projected gravitational potential is given by (0) = A(0 + 0)/ (a) Calculate the expected pattern of gravitational lensing bend angle a (0). Sketch this pattern. (b) Calculate the expected pattern...
-
Customer: "I made an agreement with my daughter that I will pay 60% of the cost of any product she chooses. Today she is interested in one of your products, which is listed at $350.00. What will be...
-
Please answer this in python quickly!! And I will vote!!! In this assignment, you will create a Python program that simulates the character and class system in the game "World of Warcraft."...
-
How much more interest will be earned if $5000 is invested for 6 years at 7% compounded continuously, instead of at 7% compounded quarterly?
-
Recently, fixed mortgage rates have been at historical lows due to the housing slowdown. Data in the Excel file mortgage rates.xlsx show the average 30 year fixed mortgage rate for the month of...
-
My department at school is comprised of 10 faculty and 6 administrators. I need to organize a committee of six people from the department. If I randomly select these committee members, determine the...
-
A political poll asked potential voters if they felt the economy was going to get worse, stay the same, or get better during the next 12 months. The party affiliations of the respondents were also...
-
The two pulleys fixed to the shaft are loaded as shown. If the journal bearings at \(A\) and \(B\) exert only vertical forces on the shaft, determine the required diameter of the shaft to the nearest...
-
The shaft is supported by journal bearings at \(A\) and \(B\) that exert force components only in the \(x\) and \(z\) directions on the shaft. If the allowable normal stress for the shaft is...
-
The shaft is supported by bearings at \(A\) and \(B\) that exert force components only in the \(x\) and \(z\) directions on the shaft. If the allowable normal stress for the shaft is \(\sigma_{\text...
Study smarter with the SolutionInn App