Create Tables
The keyboard shortcut to create a table in Excel is ______.
Ctrl + T
The purpose of _____ in Excel is to quickly apply predefined formatting to improve the visual appeal of tables.
table styles
To rename a table in Excel, select the table, go to the _________ tab, and change the name in the Table Name box.
Table Design
To convert a range of data into a table, select the data range and then go to the _____ tab and click on Table.
Insert
You can change the color scheme of a table by selecting the ______ and then choosing a different style from the Table Design tab.
table
To remove duplicate entries from a table, select the table, go to the Data tab, and click on___________.
Remove Duplicates
A vertical set of cells. In a table, each column typically represents a specific field of data, like "Product Name" or "Price.
Column
To apply banded rows to a table, select the table and check the ________ option in the Table Design tab.
Banded Rows
To change the size of a table, click and drag the small corner handle on the bottom right of the table or adjust the range in the _______ tab.
Table Design
To add a new row to a table automatically, simply start typing in the row directly below the table, or press _____ in the last cell of the last row.
Tab
A ______ is a visual filter that allows you to filter table data interactively and enhance functionality by providing a user-friendly way to filter information.
slicer
To add a calculated column to a table, type a ________ in the first cell of the new column, and it will automatically fill down to the rest of the column.
formula
To create a table from an external data source, go to the _____ tab, select Get Data, and choose the appropriate source (e.g., Access, SQL Server).
Data
To _______ a table for better readability, use features like changing font sizes, applying cell styles, and adjusting column widths to fit content.
format
To filter data in a table using the dropdown arrows, click the arrow in the column header, select the criteria you want to filter by, and click _____.
OK