3 Tables, Sorting, and Filtering Free Online FlashCards

In a structured table, what does each row and column represent?

Each column is a field, such as Date or Region; each row is one record, such as a sale.

What makes a good source range for a structured table?

Use one header row, avoid blank rows or columns within the data, and keep one kind of information in each column.

How do you create a table in Excel?

Select a cell in the data, choose Home > Format as Table, select a style, confirm the range, and indicate whether the data has headers.

What can happen when you add records to an Excel table?

Excel tables can expand as records are added, helping keep table formatting and related formulas aligned.

What is an Excel structured reference?

Structured references use table and column names instead of fixed cell addresses; for example, =SUM(Table1[Sales]) refers to the Sales column.

Does an Excel table style change the data values?

A table style changes visual formatting, not the underlying values.

What does sorting do to spreadsheet records?

Sorting rearranges records into an order, such as alphabetical text, ascending numbers, or oldest-to-newest dates; it does not remove records.

How do priorities work in a multi-level sort?

The first sort level takes priority; later levels break ties. For example, sort by Region first, then by Sales within each region.

Why should you sort the entire table rather than one column?

Sort the entire table so each record’s values stay together. If prompted, choose to expand the selection.

What happens to records excluded by a filter?

Filtering temporarily hides records that do not meet the selected criteria; it does not delete them.

What happens when filters on multiple columns are combined?

Only rows that satisfy all active filters remain visible. For example, a row must match both the selected Region and Sales criteria.

How can you restore all records after filtering?

Clear individual criteria or turn off the filter to see all records again. Hidden records remain in the table, so check for active filters when interpreting totals or copying results.