Naomi wants to calculate the totals for the instrument collection data. Switch to the All Instruments worksheet, and then create the following formulas:

a$.$ In cell B$40,$ use the COUNTA function with a structured reference to count the values in the Instrument column of the Instruments table.

b$.$ In cell F$40,$ use the SUM function with a structured reference to total the values in the Price column of the Instruments table.

c$.$ In cell G$40,$ use the SUM function with a structured reference to total the values in the Est. Value column of the Instruments table.