Question

What should you do to create range names using the create from selection button?

1) Select the tables sheet, select cells a6:b10, and click on the create from selection button in the formulas tab
2) Select the tables sheet, select cells a6:b10, and click on the create from selection button in the data tab
3) Select the tables sheet, select cells a6:b10, and click on the create from selection button in the home tab
4) Select the tables sheet, select cells a6:b10, and click on the create from selection button in the insert tab

Answer 1

To create range names using the 'Create from Selection' button in Microsoft Excel, select the tables sheet, select the desired range, and click on the button in the 'Formulas' tab.

Step-by-step explanation:

To create range names using the 'Create from Selection' button in Microsoft Excel, you should follow these steps:

1. Select the tables sheet.
2. Select cells A6:B10.
3. Click on the 'Create from Selection' button in the 'Formulas' tab.

This will create range names based on the labels in the first row and first column of the selected range.