Question

choose the correct answer. a new named range can be created by selecting the desired cells then __________. clicking on the first cell of the range and typing the name using the review tab and click on the name under more functions typing the name directly in the name box to the left of the formula bar

Explanation:

To create a new named range in Excel:

• Select the desired cells.
• Then, typing the name directly in the Name box (located to the left of the formula bar) is a common and straightforward method.
• Clicking on the first cell and typing the name (first option) is incorrect as it doesn't involve selecting the range.
• Using the review tab for this purpose (second option) is not the standard way for creating a named range (the review tab is more for checking spelling, adding comments etc., not for naming ranges in this context).

Answer:

typing the name directly in the Name box to the left of the formula bar.