Enter a formula in cell C2 to calculate next year's salary increase by multiplying the previous year's salary (cell B2) times the Cost of Living Adjustment (cell named COLA). Use the cell name in the formula.

On the Year1 sheet, in cell B8, enter a formula to display the value of cell B7 from the Salaries sheet

An employee starts a job at $1600 per month on January 1, 2015. At the end of three months their salary is increased 5 percent. At the end of the sixth month, they received another 5 percent increase. What is their total salary for the year?

An employee was hired at a bi-weekly rate of $500.00. Each year, for two years, they received a 5% increase over their present pay. How much should the employee be paid, bi-weekly, after their second salary increase?

A job as an environmental engineer that pays a salary of $65,000 in the first year. After the first year, your salary increases by 3.5% per year.a. Write a rule giving the salary $a_n$an​​ during the  $n$n​ th year of employment.$a_n=$an​=​ b. What is the salary during the fifth year of employment? Round your answer to the nearest dollar. You salary will be $.

What would be the displayed as the increased monthly salary in the following pseudocode if the user enters the department as “A” and the annual salary as 20000? if anSalary is numberic then     monSalary = anSalary / 12if deptCode = “A” then     monSalary = monSalary + monSalary * 0.072else     if deptCode = “B” then         monSalary = monSalary + monSalary * 0.068     else         monSalary = monSalary + monSalary * 0.063     endifendifdisplay “The increased monthly salary is R”, monSalaryelse     display “The annual salary must be numeric.”endifa.The increased monthly salary is R1786.67b.The annual salary must be numeric.c.The increased monthly salary is R2144.00d.The increased monthly salary is R21440.00