Which tab appears when you select an Excel table?
Analysis & Theory
When you click on a table, the **Table Design** tab appears in the ribbon for formatting and options.
What does the **Header Row** checkbox do in the Table Design tab?
B
Adds filters to column titles
D
Adds a title above the table
Analysis & Theory
The **Header Row** checkbox enables or disables the header row with sorting/filtering buttons.
What is the purpose of the **Total Row** option in Table Design?
A
Adds formatting to the header
B
Displays a summary row for totals, averages, etc.
Analysis & Theory
The **Total Row** adds a bottom row that can perform calculations like **SUM**, **AVERAGE**, etc.
What happens when you change the **Table Style** from the Table Design tab?
B
It applies borders only
C
The table's visual appearance (colors, shading) changes
Analysis & Theory
**Table Style** changes the visual appearance of the table such as colors, row shading, and header formatting.
Which checkbox adds shading to alternate rows in a table?
Analysis & Theory
**Banded Rows** alternates shading for better readability between rows.
What is the effect of enabling **First Column** in the Table Design tab?
B
Boldens the first column's text
C
Adds a filter to the first column only
D
Renames the first column
Analysis & Theory
**First Column** bolds the content of the first column for emphasis (like row titles).
What does the **Resize Table** option in Table Design do?
C
Changes the size and range of the table
Analysis & Theory
**Resize Table** allows you to expand or shrink the range that the table covers.
Which feature lets you give a meaningful name to your table?
C
Table Name box in Table Design tab
Analysis & Theory
You can rename a table using the **Table Name box** in the **Table Design** tab.
What is the use of the **Remove Duplicates** button in the Table Design tab?
B
Filters out blank cells
C
Deletes rows with identical values in selected columns
Analysis & Theory
**Remove Duplicates** deletes duplicate rows based on the selected columns' data.
What does the **Convert to Range** option do?
A
Changes the table into a PivotTable
C
Removes table features but keeps formatting
D
Deletes formatting and content
Analysis & Theory
**Convert to Range** removes table functionality (like filtering and structured references) but retains formatting.