How do you convert the cell range to a table with Table Style Light 8 and include headers?

How do you convert the cell range to a table with Table Style Light 8 and include headers?

• A. Data tab, Sort & Filter group, Convert to Range
• B. In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the Format as Table button. In the Format as Table menu, you selected the Table Style Light 8 option. Inside the Format As Table dialog, you clicked the OK button.
• C. Insert tab, Tables group, Table Style Light 8
• D. Table Tools Design tab, Convert to Range button

Answer: (B)

Converting a range to a table with a specific look and headers is done by using the Format as Table command from the Home tab. This path directly turns the selected cells into a table, applies a chosen table style, and lets you decide whether the range has headers. Begin on the Home tab, in the Styles group click Format as Table. In the menu, choose the desired style—Table Style Light 8. The Format As Table dialog will open, showing the range to be converted. If your range includes headers, make sure the My table has headers option is checked, then click OK. The result is a new table styled with Light 8 and with headers visible. Other routes don’t create a table with a style in one flow. For example, converting to a range removes table formatting, and some paths don’t present the style choice or header option in the same step, so they don’t achieve both goals together.

Converting a range to a table with a specific look and headers is done by using the Format as Table command from the Home tab. This path directly turns the selected cells into a table, applies a chosen table style, and lets you decide whether the range has headers.

Begin on the Home tab, in the Styles group click Format as Table. In the menu, choose the desired style—Table Style Light 8. The Format As Table dialog will open, showing the range to be converted. If your range includes headers, make sure the My table has headers option is checked, then click OK. The result is a new table styled with Light 8 and with headers visible.

Other routes don’t create a table with a style in one flow. For example, converting to a range removes table formatting, and some paths don’t present the style choice or header option in the same step, so they don’t achieve both goals together.