What are some ways to use a range name in a formula? Check all that apply. In the Defined Names group, click Use in Formula, and then select the desired name. Begin typing the name in the formula, select a name from the AutoComplete list, and use the arrow keys and Tab key to enter the name in the formula. Begin typing the formula, and then click and drag with the mouse to select the cells to include in the formula. Right-click one of the cells in the range. Click Formula Options, and use the dialog box to add the name.

click Use in Formula, and then select the desired name. Begin typing the name in the formula, select a name from the AutoComplete list, and use the arrow keys and Tab key to enter the name in the formula. Begin typing the formula, and then click and drag with the mouse to select the cells to include in the formula. Right-click one of the cells in the range. just that that applyes Thanks

Answer Link