The CEO knows that companies who recognize and reward team members have increased employee morale, lower...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The CEO knows that companies who recognize and reward team members have increased employee morale, lower turnover and increased productivity. Rewarding employees can increase business profit as much as 20%. 5.1 Activate the 6. Employee Recognition worksheet. Enter a date function in B1 that will always display the current date. Apply a date format to match column D. (2) In cell G3, use a date function to determine the number of full or partial years each employee has been employed as of today. (2) In H3, apply a nested function based on the following criteria; if salesperson has worked more than 3 years, their Total Sales are over 100,000 and they are responsible for Territory Alberta, they will receive a bonus 4% salary increase, otherwise they will receive a standard 1% salary increase. Wherever possible cell referencing should be used. Results should show the conditional raise amount only. (4) In 13 use the IFS function to determine these bonuses. In the function refer to the Sales Positions listed in A18:A20. Each cell in this range is part of the Logical Test Condition and each cell in B18:B20 will be the individual Value if True in the function. These references must also be absolute. Complete the function and confirm that the correct bonuses are displayed. (3) Edit the function in 13 to add both the Conditional Raise from column H and the Salary located in column E. (1) Apply Accounting format with no decimals where salary, sales and bonuses are shown. The Years should be formatted as a number with 1 decimal. (1) 5.2 5.3 5.4 5.5 5.6 5.7 5.8 Insert two new rows at the top of the worksheet and copy the heading from the 2. Year End Subtotals sheet to cell A1. Change the title to Employee Recognition Report. Set row height to 90. Unmerge and remerge across used columns of the worksheet. (1) Apply appropriate table formats including table layouts to the worksheet, using the range A4:117 as the first table. Apply appropriate table formats to the second table in A19:B24. Convert all tables to a range and apply best fit column widths. Replace any references to Column heading titles inserted when applying the table formats. Apply text wrap to the titles in H4:14, set column width for columns D:1 to 12. (4) The CEO knows that companies who recognize and reward team members have increased employee morale, lower turnover and increased productivity. Rewarding employees can increase business profit as much as 20%. 5.1 Activate the 6. Employee Recognition worksheet. Enter a date function in B1 that will always display the current date. Apply a date format to match column D. (2) In cell G3, use a date function to determine the number of full or partial years each employee has been employed as of today. (2) In H3, apply a nested function based on the following criteria; if salesperson has worked more than 3 years, their Total Sales are over 100,000 and they are responsible for Territory Alberta, they will receive a bonus 4% salary increase, otherwise they will receive a standard 1% salary increase. Wherever possible cell referencing should be used. Results should show the conditional raise amount only. (4) In 13 use the IFS function to determine these bonuses. In the function refer to the Sales Positions listed in A18:A20. Each cell in this range is part of the Logical Test Condition and each cell in B18:B20 will be the individual Value if True in the function. These references must also be absolute. Complete the function and confirm that the correct bonuses are displayed. (3) Edit the function in 13 to add both the Conditional Raise from column H and the Salary located in column E. (1) Apply Accounting format with no decimals where salary, sales and bonuses are shown. The Years should be formatted as a number with 1 decimal. (1) 5.2 5.3 5.4 5.5 5.6 5.7 5.8 Insert two new rows at the top of the worksheet and copy the heading from the 2. Year End Subtotals sheet to cell A1. Change the title to Employee Recognition Report. Set row height to 90. Unmerge and remerge across used columns of the worksheet. (1) Apply appropriate table formats including table layouts to the worksheet, using the range A4:117 as the first table. Apply appropriate table formats to the second table in A19:B24. Convert all tables to a range and apply best fit column widths. Replace any references to Column heading titles inserted when applying the table formats. Apply text wrap to the titles in H4:14, set column width for columns D:1 to 12. (4)
Expert Answer:
Answer rating: 100% (QA)
The detailed answer for the above question is provided below 51 Activate the 6 Employee Recognition worksheet Enter a date function in B1 that will always display the current date Apply a date format ... View the full answer
Related Book For
Strategic Management An Integrated Approach
ISBN: 978-1111825843
10th edition
Authors: Charles W. L. Hill, Gareth R. Jones
Posted Date:
Students also viewed these general management questions
-
Use a tree diagram to determine the number of subsets of {3, 7, 9, 11, 24} with the property that the sum of the elements in the subset is less than 28.
-
Use the multiplicative rule to determine the number of sample points in the sample space corresponding to the experiment of tossing a coin the following number of times: a. 2 times b. 3 times c. 5...
-
Use the counting principle to determine the number of sample points in the sample space. One colored chipred, blue, or greenis selected at random and a fair die is rolled.
-
A quality inspector selects a sample of 12 items at random from a collection of 60 items, of which 18 have excellent quality, 25 have good quality. 12 have poor quality, and 5 are defective. (a) What...
-
The following table shows predicted product demand using your particular forecasting method along with the actual demand that occurred: Forecast ...... Actual 1500 ...... 1550 1400 ...... 1500 1700...
-
a. What does a population proportion tell us about the population? b. Explain the difference between p and p. c. What is meant when a public opinion poll's margin of error is 3 percent?
-
How to determine in which venue to file the lawsuit?
-
Can a creditor of both the husband and wife under the same obligation obtain an execution against a Winnebago mobile home owned by the husband and wife in tenancy by entirety?
-
1.The common stock of B&S currently sells for $23 per share. It is expected that a constant growth rate of 10.5% and end-of-year dividend of $2.5. a.What if your required rate of return? b.If you...
-
GWE in store retail is considering closing stores to save a further 20% next year. Given current figures, how many stores would you expect GWE to close? GWE Profit and Loss for (Year 1) Asia...
-
The binary system, acetone (1)/acetonitrile (2) conforms closely to Raoult's law. Using the vapor pressure data given below plot the P-x1 and P-y1 curves at 323K T (K) 311.45 315 319 323 327 331...
-
5. Please mark which intermolecular and intramolecular forces each of the following molecules partakes in with itself: NOTE: Please ONLY put a check mark in the columns that experience that...
-
How do central banks use open market operations to influence liquidity in the financial system, and what impact does this have on interest rates and inflation?
-
A poodle is chasing after a frisbee at the park. The frisbee is maintaining a height of h = 0.95 m as it passes through the air. The poodle leaps into the air, from level ground and with initial...
-
A basketball is dropped onto the dining room floor, and the distance from the ceiling is measured using a portable measurement computer with the sensor attached to the ceiling lamp. The graph below...
-
What role does due diligence play in the success of mergers and acquisitions, and what are the key areas of focus for due diligence in cross-border deals?
-
The existence of intangibility, inconsistency, inseparability, and perishability (inventory) in many service contexts are considered to present a number of challenges to services marketers not...
-
The baseball player A hits the ball from a height of 3.36 ft with an initial velocity of 34.8 ft/s. 0.14 seconds after the ball is hit, player B who is standing 15 ft away from home plate begins to...
-
1. Using the information contained in the case, conduct a five-forces analysis of the U.S. Steel industry. What conclusion can you draw from this? 2. Do you think there are any strategic groups in...
-
1. What macroenvironmental, competitive, and industry forces made Kodak initially successful? Are these the same in their demise? 2. How did Kodak achieve related diversification and vertical...
-
What steps would you recommend that a company take to build mutually beneficial long-term cooperative relationships with its suppliers?
-
State which of the following items could appear as an asset on the statement of financial position of Goblin Combe plc, a leading premium drinks business: \($150,000\) of product sold during the...
-
Trading continues apace for your new business Climb On! The products have proved to be popular and, seeing this as your opportunity to seize the day, you decided to expand and grow the business. Here...
-
A rare book library at a University of England in England houses first edition (FE), original manuscript (OM), and authors journals (AJ). Some of these rare books are worth hundreds of thousands of...
Study smarter with the SolutionInn App