Mr.Casem is preparing to retire after 31 years with his company.He set up this spreadsheet to calculate his pension,which is based on his most recent three -year average salary,number of years of service,and a 2% multiplier.What are the formulas for cells D1 and D4? What are the resulting values?
What are the formulas for cells D1 and D4? What are the resulting values?

Question

Mr.Casem is preparing to retire after 31 years with his company.He set up this spreadsheet to calculate his pension,which is based on his most recent three -year average salary,number of years of service,and a 2% multiplier.What are the formulas for cells D1 and D4? What are the resulting values?  ​
What are the formulas for cells D1 and D4? What are the resulting values?

Quizplus · Accepted Answer

The Answer of Mr.Casem is preparing to retire after 31 years with his company.He set up this spreadsheet to calculate his pension,which is based on his most recent three -year average salary,number of years of service,and a 2% multiplier.What are the formulas for cells D1 and D4? What are the resulting values?  ​
What are the formulas for cells D1 and D4? What are the resulting values?

MrCasem Is Preparing to Retire After 31 Years with His