Question

Kristofer 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. Click on the tab on the ribbon and look in the defined names gallery. Select the range of cells, including the row that includes the name you wish to use. Select _____ and click OK.

a) Formulas
b) Data
c) Insert
d) Page Layout

Answer 1

To create names in Excel that match column headings, select the cells including the headers, go to the 'Formulas' tab, find 'Defined Names', and choose 'Create from Selection'. Ensure the 'Top row' option is checked and click OK.

Step-by-step explanation:

Kristofer can set the cell names to match his column headings by using the Create from Selection command found in Excel. To do this, he needs to select the range of cells including the row with the column headings. The correct navigation path to set these names is to select the Formulas tab on the Excel ribbon. Within the Formulas tab, he should look in the Defined Names gallery.

To set cell names using the "Create from Selection" command, select the 'Formulas' tab on the ribbon. Then, in the defined names gallery, select the range of cells, including the row that includes the name you wish to use. Finally, select 'Create from Selection' and click OK.

After selecting the range, Kristofer should choose the Create from Selection command. He will be presented with a dialog box where he needs to ensure that the Top row option is checked since he is using the top row for the column headings. After that, clicking OK will create names in Excel that match his column headings.