A banker would like to present a spreadsheet as part of a presentation to potential clients. The spreadsheet makes use of several advanced spreadsheet features. One of these features shows clients how much interest they can earn by opening a new savings account with the bank. Savings are shown by month and by year.

Which feature will prevent the annual interest earnings total from duplicating monthly interest earnings totals?

A. nested IF statement

B. subtotal function

C. conditional formatting

D. cell protection

ANSWER//b