Benicio started to define names for cells and ranges in the All Locations worksheet to make it easy to identify the total sales for each product. He wants you to add a defined name for the Waterproof sales amounts and then find the total annual sales for each product.
Create and use defined names as follows:
a. Create a defined name for the Waterproof sales amounts (range B7:E7) using Waterproof_Total as the name.
b. In cell F5, enter a formula using the SUM function to display the total of the sales amounts in the Mini_Total range.
c. In cell F6, enter a formula using the SUM function to display the total of the sales amounts in the Voice_Activated_Total range.
d. In cell F7, enter a formula using the SUM function to display the total of the sales amounts in the Waterproof_Total range.
Please help me out!
Reading books is a great way to learn. Here are some of the books we recommend.
a. Select range B7:E7, copy "Waterproof_Total". Right-click and select Define name. In the Name field paste it and click OK.
b. In cell F5, enter
=SUM(Mini_Total).c. In cell F6, enter
=SUM(Voice_Activated_Total).d. In cell F7, enter
=SUM(Waterproof_Total).Video Instruction by Taandar