Question

Kristoffer needs to create cell names that match the column headings he has already created. Select the correct navigational path to set those names using the create-from-selection command.

a) Click on the tab on the ribbon and look in the defined names gallery.
b) Select the range of cells, including the row that includes the name you wish to use.
c) Select and click OK.
d) All of the above.

Answer 1

To set cell names using the create-from-selection command in Microsoft Excel, Kristoffer can select the range of cells and use the 'Create from Selection' button in the 'Formulas' tab on the ribbon.

Step-by-step explanation:

To set cell names using the create-from-selection command in Microsoft Excel, Kristoffer can follow these steps:

1. Select the range of cells, including the row that includes the name he wishes to use.
2. Click on the 'Formulas' tab on the ribbon.
3. In the 'Defined Names' group, click on the 'Create from Selection' button.
4. A dialog box will appear, select the desired options and click 'OK'.

By following these steps, Kristoffer will be able to create cell names that match the column headings he has already created.