4. In cells B4:B15, type a yearly salary for each staff member. Format these values as...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
4. In cells B4:B15, type a yearly salary for each staff member. Format these values as Currency with no decimal places. 5. Calculate the new salary with a 10% increase in column C. 6. Calculate the new salary with a 15% increase in column D. The increase should be over the original or Current Salary (Column B). 7. Calculate total salaries for each level in cells B16:D16. 8. In cell A17, type: Totals. 9. In cell A18, type: Average. .0. In cell A19, type: Median. 1. Calculate the average and median salary for each column in cells B18:D19. 2. In cell B21, and type this sentence: "Type ID in cell B22." including the period. Type one of the staff IDs from column A in cell B22. 3. Select cell C22. Build an XLOOKUP (or VLOOKUP) function to display the salary with a 10% increase for the staff ID shown in cell B22. Format the results as Currency with no decimals. 4. Test your function by typing a different staff ID in cell B22. Staff ID ABOOI AB002 AB003 AB004 AB005 AB006 AB007 AB008 AB009 AB010 АВОП AB012 Totals Average Median New Story Home Contruction Cmpany Financial Data Current Salary 10% Increase 15% Increase $11,000 $11,500 $13,200 $13,800 $15,400 $16, 100 $18,400 $20,700 $23,000 $25,300 $27,600 $29,900 $32,200 $34,500 $36,800 $289,800 $10,000 $12,000 $14,000 $16,000 $18,000 $20,000 $22,000 $24,000 $26,000 $28,000 $30,000 $32,000 $252,000 $21,000 $21,000 Type ID in cell B22. ABO01 $17,600 $19,800 $22,000 $24,200 $26,400 $28,600 $30,800 $33,000 $35,200 $277,200 $23, 100 $23,100 10000 $24,150 $24,150 2/6/23 4. In cells B4:B15, type a yearly salary for each staff member. Format these values as Currency with no decimal places. 5. Calculate the new salary with a 10% increase in column C. 6. Calculate the new salary with a 15% increase in column D. The increase should be over the original or Current Salary (Column B). 7. Calculate total salaries for each level in cells B16:D16. 8. In cell A17, type: Totals. 9. In cell A18, type: Average. .0. In cell A19, type: Median. 1. Calculate the average and median salary for each column in cells B18:D19. 2. In cell B21, and type this sentence: "Type ID in cell B22." including the period. Type one of the staff IDs from column A in cell B22. 3. Select cell C22. Build an XLOOKUP (or VLOOKUP) function to display the salary with a 10% increase for the staff ID shown in cell B22. Format the results as Currency with no decimals. 4. Test your function by typing a different staff ID in cell B22. Staff ID ABOOI AB002 AB003 AB004 AB005 AB006 AB007 AB008 AB009 AB010 АВОП AB012 Totals Average Median New Story Home Contruction Cmpany Financial Data Current Salary 10% Increase 15% Increase $11,000 $11,500 $13,200 $13,800 $15,400 $16, 100 $18,400 $20,700 $23,000 $25,300 $27,600 $29,900 $32,200 $34,500 $36,800 $289,800 $10,000 $12,000 $14,000 $16,000 $18,000 $20,000 $22,000 $24,000 $26,000 $28,000 $30,000 $32,000 $252,000 $21,000 $21,000 Type ID in cell B22. ABO01 $17,600 $19,800 $22,000 $24,200 $26,400 $28,600 $30,800 $33,000 $35,200 $277,200 $23, 100 $23,100 10000 $24,150 $24,150 2/6/23
Expert Answer:
Related Book For
Fundamentals of Cost Accounting
ISBN: 978-1259565403
5th edition
Authors: William Lanen, Shannon Anderson, Michael Maher
Posted Date:
Students also viewed these accounting questions
-
Current Assets 2000 2001 Cash 200 1 000 Accounts receivable 1 600 1 000 Inventory 2 200 2 600 TOTAL CURRENT ASSETS 4 000 4 600 Gross Fixed Assets 12 000 12 400 Less Accum Depreciation 6 000
-
Each cell in a culture of 16 cells has a probability of 0.1 of dying. Find and approximate the probability that exactly one cell dies. In the above case, find the probability exactly with the...
-
4 cubed + 10 X 20 + 8 squared 23
-
The two key principles that form the foundation for an ethical sales presentation are OA) the approach and the close B) setting up the appointment and completing the application C) uncovering needs...
-
Show that the scalar potential of a point charge moving with constant velocity (Eq. 10.42) can be written equivalently as where R = r - vt is the vector from the present (.t) position of the particle...
-
If potential GDP was $270 in 2016 and it grew by 1 percent in 2017, in which phase of the business cycle is the economy? Explain. An economy produces only fun and food. The table shows the prices and...
-
Worldwide Communications, Incorporated, sells telecommunication products throughout the world in three sales territories: Europe, Asia, and the Americas. For July, all \($650,000\) of administrative...
-
Lifemaster produces two types of exercise treadmills: regular and deluxe. The exercise craze is such that Lifemaster could use all its available machine hours to produce either model. The two models...
-
Sparky Corporation uses the FIFO method of process costing. The following information is available for February in its Molding department Direct materials Conversion Percent Units Percent Complete...
-
Over the past several years, Claire Jackson, CEO and founder of Easy Learning (EL), has been working to expand operations outside of Canada. In particular, she has placed two longtime, trusted...
-
For each of the following, circle your final answer and show all necessary steps to receive full credit. For questions using the calculator, this means you need to write out normalcdf() or invnorm)...
-
A two-dimensional wedge shown moves through the atmosphere at zero angle of attack at M = 3.0. The approach flow static pressure is, P = 20,000 Pa. Assume that the width of the wedge is 1m into the...
-
4. A black chicken and a white chicken are crossed. What is the probability that they will have erminette chicks? Se % Parents: B xw BW 5. In snapdragons, flower color is controlled by incomplete...
-
Write a paragraph of about 100 words on how to frame a primary business message. What are the message development components?
-
along with additional information, follows: Diana & Associates Income Statement (Cash Basis) For the Year Ended December 31, 2023 Cash receipts from customers $400,000 Cash payments: Salaries and...
-
2. List the basic characteristics of members of the DomainEukarya, the Kingdom Protista and the Kingdom Fungi. Point out anysimilarities and differences between them and members of the DomainBacteria.
-
- JNJ has 10,000 shares outstanding at the beginning of the year. On April 1, JNJ issues 4,000 new shares. On September 1, JNJ repurchases 3,000 shares. Calculate JNJ's weighted average number of...
-
The tractor is used to lift the 150-kg load B with the 24-mlong rope, boom, and pulley system. If the tractor travels to the right at a constant speed of 4 m/s, determine the tension in the rope when...
-
Brunswick Parts is a small manufacturing firm located in eastern Canada. The company, founded in 1947, produces metal parts for many of the larger manufacturing firms located in both Canada and the...
-
Refer to the Business Application discussion of options backdating. If stock options and other forms of performance-based compensation result in some managers engaging in unethical or illegal...
-
Weaver, Inc., is a large consumer products company, which manufactures health and beauty products sold at grocery and drug stores throughout the country. Gamma Division does bot manufacturing and...
-
Rose Limited operates a small chain of retail shops that sell high-quality teas and coffees. Approximately half of sales are on credit. Abbreviated and unaudited financial statements are as follows:...
-
Presented below is a draft set of financial statements for Chips Limited. The following additional information is available: 1 Purchase invoices for goods received on 29 June 2016 amounting to 23,000...
-
Why are accounting rules needed when preparing financial statements?
Study smarter with the SolutionInn App