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.
ABCD1YearSalaryThree year Average Salarya.2199949,500Percentage Multiplier2.03200052,000Years of Service314200153,000Annual Pension Benefitb.What are the formulas for cells D1 and D4? What are the resulting values?
What will be an ideal response?
a. =average(B2:B4) will be $51,500.
b. =(D1*D2/100*D3) will be $31,930.
Mathematics
You might also like to view...
Integrate the function.
, x > 8
A. ln 
+ C
B. ln 
+ C
C. 
+ C
D. 
+ C
Mathematics
Find the exact value of the expression or state that it does not exist.cos
A. 
B. 
C. 
D. 
Mathematics
Find the slope-intercept form for the line satisfying the conditions.Passing through (-4, -10) and (-2, -10)
A. x = -4 B. -4x - 2y = 0 C. -2x - 4y = 0 D. y = -10
Mathematics
Verify the identity.(sec x - tan x)(sec x + tan x) = 1
What will be an ideal response?
Mathematics