Cell and Range Names

Question 1

After selecting a cell in the data range, what are some ways to create a table? Check all that apply.Press the F5 + T keys.On the Home tab, in the Styles group, select a table style from the Format as Table gallery.On the Data tab, in the Arrangements group, click Form Table.On the Page Layout tab, in the Header & Footer group, click Format as Table.Press the Ctrl + T keys.On the Insert tab, in the Tables group, click Table.

Revolt · Accepted Answer

On the Home tab, in the Styles group, select a table style from the Format as Table gallery.; Press the Ctrl + T keys.; On the Insert tab, in the Tables group, click Table.

Question 2

What are some options available on the Table Tools Design tab? Check all that apply.applying themesidentifying formula errorsadding header or footer page numbersselecting a printerexporting and refreshing datalooking for duplicate data

Revolt · Accepted Answer

applying themes; exporting and refreshing data; looking for duplicate data

Question 3

How do you access the setting that prevents Excel from automatically adding new cells to a table?

Revolt · Accepted Answer

Click the AutoCorrect Options button.

Question 4

What are the steps for deleting a row in a table?

Revolt · Accepted Answer

Right-click the row, click Delete, and then click Table Rows.

Cell and Range Names Answers

More from this Course

TRY EDGENUITY HACKS