The spreadsheet calculates a yearly pension. Users enter the pension percentage as a percent in cell B1,

Question:

The spreadsheet calculates a yearly pension. Users enter the pension percentage as a percent in cell B1, the number of years worked in cell B2, and the last four working years' salaries in cells B3-B6. That 4-year average salary is calculated and displayed in cell B7. The yearly pension amount is calculated and displayed in cell B8.
a. Write the spreadsheet formula for cell B7.
b. Write the spreadsheet formula for cell B8.
The spreadsheet calculates a yearly pension. Users enter the pension
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: