This spreadsheet calculates a yearly pension.The formulas are entered in column B.What is the spreadsheet formula for B7?
A) =average(B3:B5)
B) =sum(B3:B5)
C) =(B6*B2)/B1
D) =B1/100*B6*B2

Question

This spreadsheet calculates a yearly pension.The formulas are entered in column B.What is the spreadsheet formula for B7? 
A) =average(B3:B5) 
B) =sum(B3:B5) 
C) =(B6*B2)/B1 
D) =B1/100*B6*B2

Quizplus · Accepted Answer

B7 should calculate the yearly pension by multiplying the average salary (B6) by the number of years of service (B2) and the percentage of the pension plan (B1). Therefore, the correct formula is (B1/100)*B6*B2.

This Spreadsheet Calculates a Yearly Pension