Create a defined name for the Waterproof sales amounts $($range B$7$:$7)$ using

Waterproof$\_$Total as the name.

b$.$

In cell F$5,$ enter a formula using the SUM function to display the total of the sales amounts in the Mini$\_$Total range.

C$.$

In cell F$6,$ enter a formula using the SUM function to display the total of the sales amounts in the Voice$\_$

Activated$\_$Total range.

d$.$

In cell F$7,$ enter a formula using the SUM function to display the total of the sales amounts in the Waterproof$\_$Total range.