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?
-
At the end of Example 8.5.11, compute the probability that |2 | < 0.3 given Z = 0.9. Why is it so large?
-
On January 1, 2017, Pele SA purchased the following two machines for use in its production process. Machine A: The cash price of this machine was R$35,000. Related expenditures included: sales tax...
-
Under what conditions would an auditor take action for the subsequent discovery of facts existing at the report date?
-
Shanghai Corporation, the Chinese affiliate of a U.S. manufacturer, has the balance sheet shown below. The current exchange rate is $.0.15 = CNY1. Required: a. Translate the Chinese dollar balance...
-
5 Tito Martinez has just arranged to purchase a $560,000 vacation home in the Bahamas with a 25 percent down payment. The mortgage has an APR of 6.2 percent, compounded monthly, and calls for equal...
-
Emerald City Umbrellas sells umbrellas and rain gear in Seattle, so its sales are fairly level across the year. However, it is branching out to other markets where it expects demand to be much more...
-
How long will it take Lisa Harvie to accumulate $12,000 towards a new car if she is able to deposit $900 a year at 5% interest? . Vincent leung will retire in 10 years. Based on actuarial estimates,...
-
Consider the following items for Shocker Enterprises: 1. On November 30, 2024, Shocker received a $4,500 payment from a customer for services to be rendered evenly over the next three months....
-
Hudson Company reports the following contribution margin income statement. HUDSON COMPANY Contribution Margin Income Statement For Year Ended December 3 1 Sales ( 9 , 6 0 0 units at $ 2 2 5 each ) $...
-
Each of the following independent events requires a year - end adjusting entry. Paid $ 4 8 , 0 0 0 cash in advance on July 1 for a one - year lease on office space. Purchased $ 5 , 0 0 0 of supplies...
-
Valley Company s adjusted account balances from its general ledger on August 3 1 , its fiscal year - end, follows. It categorizes the following accounts as selling expenses: sales salaries expense,...
-
Lincolnshire Lumber sells boards for many uses including wood floors. For floors, the boards are sold to local installers or do - it - yourself homeowners. The boards go through up to four processes,...
-
Consider how well jewelry sales can be forecast on the basis of disposable personal income or unemployment rate, as measures of overall purchasing power. The explanatory variables selected are based...
-
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...
-
In a stage of impulse-reaction turbine, steam enters with a speed of \(250 \mathrm{~m} / \mathrm{s}\) at an angle of \(30^{\circ}\) in the direction of blade motion. The mean blade speed is \(150...
-
A single row impulse turbine develops \(130 \mathrm{~kW}\) at a blade speed of \(180 \mathrm{~m} / \mathrm{s}\) using \(2 \mathrm{~kg} / \mathrm{s}\) of steam. The steam leaves the nozzle at \(400...
-
A simple impulse turbine has one ring of moving blades running at \(150 \mathrm{~m} / \mathrm{s}\). The absolute velocity of steam at exit from the stage is \(80 \mathrm{~m} / \mathrm{s}\) at an...
Study smarter with the SolutionInn App