Question

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.

Answer 1

To create a defined name for a range in Excel, use the Name Manager and set a name, such as 'Waterproof_Total' for the B7:E7 range. Then use the SUM function with the named range to display totals in specific cells, per each range's name.

Step-by-step explanation:

To create a defined name for the Waterproof sales amounts (range B7:E7), you would typically use the Name Manager in Excel. Go to the Formulas tab, click on 'Name Manager', then 'New', and enter 'Waterproof_Total' as the name, then specify the range B7:E7.

For the formulas:

• In cell F5, the formula to display the total of the sales amounts in the Mini_Total range would be =SUM(Mini_Total).
• In cell F6, the formula to display the total of the sales amounts in the Voice_Activated_Total range would be =SUM(Voice_Activated_Total).
• In cell F7, the formula to display the total of the sales amounts in the Waterproof_Total range would be =SUM(Waterproof_Total).