Free Practice Quiz Question List

3 Tables, Sorting, and Filtering Online Quiz Questions

Use this free practice quiz with 20 questions to review 3 Tables, Sorting, and Filtering, test your knowledge, and prepare for your next test or exam.

20 questions

Choose one

1 point

Which source range is best organized for conversion into a structured table?

A
A range with several header rows, occasional blank rows, and mixed information in columns
B
A range with one header row, no blank rows or columns inside the data, and one kind of information in each column
C
A range with no headers and blank columns separating records
D
A range where each row contains multiple records and each column contains several unrelated fields

Fill in the blank

1 point

Complete the structured-reference formula to total the Sales column: =SUM(Table1[])

True or false

1 point

True or false: Applying a table style changes the underlying values in the cells.

A
True
B
False

Written response

1 point

A conditional-formatting rule highlights Sales values below 25. In the example table, how many sales values would be highlighted?

Choose one

1 point

You sort a table first by Region from A to Z, then by Sales from largest to smallest. How are the records ordered?

A
Sales is sorted first across the entire table, then Region is used only for identical sales values.
B
The two levels are applied independently, so their order does not matter.
C
Region is sorted first, and Sales is sorted within each Region group.
D
The second level always overrides the first level.

Choose all

1 point

Select all accurate descriptions of conditional-formatting display types.

A
Data bars compare magnitudes visually.
B
Color scales remove records outside a selected range.
C
Color scales show relative high-to-low values.
D
Icon sets divide values into categories.

True or false

1 point

True or false: A structured table can expand as records are added, helping keep its formatting and related formulas aligned.

A
True
B
False

Written response

1 point

If the original record order may need to be recovered after sorting, what kind of column should be added beforehand?

Fill in the blank

1 point

When filters are combined across columns, visible rows must satisfy active filters.

Choose one

1 point

You want to quickly sort a table by one column. Which action is described as a quick-sort method?

A
Use Home > Conditional Formatting.
B
Use the header's dropdown for a quick sort.
C
Turn off the table's header row.
D
Use a filter condition to permanently rearrange the records.

Choose all

1 point

Select all accurate statements about what happens when a table is filtered.

A
Records that do not meet the criteria are temporarily hidden.
B
Hidden records remain in the table.
C
Applying a filter permanently deletes nonmatching records.
D
Clearing the criteria or turning off the filter can show all records again.

Open ended

1 point

A report needs to flag Sales values below 25 in amber. Explain how to apply the conditional-formatting rule and give two precautions that help make the result useful and reliable.

Written response

1 point

In the example table, what is the date of the record with Region East and Product Pen?

True or false

1 point

True or false: A date column can be sorted from oldest to newest.

A
True
B
False

Choose one

1 point

When organizing spreadsheet data for analysis, how should records and fields be arranged?

A
Put one field in each row and one record in each column.
B
Put one record in each row and one field in each column.
C
Put several records in each row and combine all fields in one column.
D
Use rows for headers and columns for individual values, without organizing them by record.

Written response

1 point

In the formula =SUM(Table1[Sales]), what is the spreadsheet term for the reference that uses the table name and column name?

Choose one

1 point

Why should you sort an entire table rather than sorting only one column?

A
Sorting just one column keeps all the other values in each record aligned automatically.
B
Sorting the entire table preserves the original row order while changing the selected column.
C
Sorting the entire table keeps each record’s values together as records are rearranged.
D
Sorting one column deletes records whose values do not match the sort order.

Choose one

1 point

Using the example table, you filter Region to show West and Sales to show amounts greater than 25. Which row remains visible?

A
Only the West Pen row, with Sales of 22.50.
B
Only the West Notebook row, with Sales of 60.
C
The West Notebook row with Sales of 60 and the East Pen row with Sales of 30.
D
All three rows in the example table.

Choose one

1 point

A conditional-formatting rule highlights Sales values below 25 in amber. Which of the values 22.50 and 30 is highlighted?

A
Only 22.50 is highlighted.
B
Only 30 is highlighted.
C
Both values are highlighted.
D
Neither value is highlighted.

Choose one

1 point

A conditional-formatting rule was applied to only part of a Sales column. What is a likely risk?

A
The rule automatically corrects inconsistent data in every column.
B
The rule changes the underlying values in the selected cells.
C
Some existing or new records may not receive the intended formatting.
D
The rule prevents the table from being sorted.