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...
-
The Hamilton Corp. has 35,000 shares of common stock outstanding with a book value of $20 per share. It owes creditors $1.5 million at an interest rate of 12%. Selected financial results are as...
-
What legacy of empowerment do you aspire to leave behind, as you sow the seeds of change and nurture the saplings of progress, ensuring that future generations inherit a world where the flame of...
-
The kinematic viscosity of a certain solvent system depends on the ratio of the two solvents and the temperature. Table B. 10 summarizes a set of experimental results. a. Fit a multiple linear...
-
Phelps Company distributed the following dividends to its stockholders: (a) 450,000 shares of Bedrock Corporation stock, carrying value of investment, $975,000; fair market value, $1,350,000. (b)...
-
Consider the SIR model with vital dynamics with a population of K individuals without considering birth and death rate. Find the equilibrium points and compute the Jacobian linearization about each...
-
Looking for the excel function in Yellow on Q9 Question 9 Annual 3.000% Semi-Annual 3.022% Quarterly 3.034% Monthly 3.042% 4 points Question 10 14.2 14.2 4 points 9) After reviewing the compounding...
-
Watch the video explaining the four characteristics of services posted in this module 1. As you move into your future careers, how can a supervisor/manager overcome the challenges associated with:...
-
For following circuit where vs (t) = 2u(t), R = 20, R = 6, L= 2.215 H, and C = 0.0376 F. R R www vs(t) b) (5') Find its poles. C + V iL(t) a) (25') Suppose vs(t) is the input and i(t) is the output,...
-
Use this slide to solve the problems below Convert between SOP and POS POS-SOP: Use the following 3 properties (in this order) P8b. P149 P8a. (a + b)(a + c) = a + bc (a + c)(a' + b) = ab + a'c a (b...
-
Pendant Publishing is considering investing in a new printing press. The initial costs will be $250,000. After-tax cash flows next year will increase by $18,000 and will grow at an annual rate of 4%...
-
Objectives and the Timeline: The objective of this project is to conduct an in-depth ratio analysis of a firm's performance in last five years and forecast its performance of next year using the...
-
Alice tries to make cascode current source as the figure below. Calculate Rout. (9m1-9m2=(2692), n1-n2-2.6k, ro1-10k2, roz=20k(2) (The unit is k and write only the number rounded to one decimal place...
-
For the following project, compute an EAA: Project A requires you an upfront payment of $211,199 and yearly payments of $54,077 for 14 years. Your cost of capital is 3.08%,
-
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...
-
The Sun contains what percentage of the solar systems mass? (a) about 35% (b) 85% (c) the percentage varies over time (d) over 99%
-
Each second, the burning Suns mass (a) increases. (b) remains unchanged. (c) decreases.
-
The nebular theory is based on the observation that the solar system (a) follows patterns indicating that it formed progressively from physical processes. (b) has a structure much like an atom. (c)...
Study smarter with the SolutionInn App