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? Nested IF statement subtotal function conditional formatting cell protection

subtotal function

Explanation:

The Microsoft Excel SUBTOTAL returns the subtotal of the numbers in the columns in a list or database, and it can be applied horizontally as well as vertically. And the SUBTOTAL function happens to be the built-in function in Excel which is categorized as the Math function or the Trigger function. And like a worksheet function, it can be inserted as a part of the formula inside a cell of a worksheet. Select the columns in a row, or rows in a column, and move to the Data tab in the ribbon. From there,  select the SUBTOTAL, and the function you would like to use, and press ok. And this means here the correct option is the subtotal function.