Timedora
Free Practice Quiz Question List

5 Sorting and Filtering Data Online Quiz Questions

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

20 questions
01
True or false
1 point

True or false: Applying a filter hides records that do not meet its criteria without deleting them.

  1. A

    True

  2. B

    False

02
Written response
1 point

What is the spreadsheet term for the column used to set the order of records?

03
Choose one
1 point

You need to rank transactions by Sales while keeping each transaction's date, region, and product attached to the correct sales value. What should you do?

  1. A

    Select just the Sales column and sort it from largest to smallest.

  2. B

    Select the complete data range and sort it by Sales from largest to smallest.

  3. C

    Copy the Sales values into a new column, sort that column, and leave the other fields in place.

  4. D

    Filter the Sales column to show the largest value, then move each visible value into a new row.

04
Fill in the blank
1 point

To place the earliest transactions first in a date column, sort the dates .

05
True or false
1 point

True or false: When sorting a data range with a header row, identify the header so the spreadsheet does not treat it as a record.

  1. A

    True

  2. B

    False

06
Written response
1 point

What spreadsheet feature displays records that meet selected criteria while hiding the other records from view?

07
Choose one
1 point

You want records grouped by Region in A-to-Z order, with the highest Sales first within each region. Which sort setup achieves this?

  1. A

    Sort by Sales largest to smallest, then sort the entire table by Region A to Z.

  2. B

    Filter Region to show each region separately, then manually move the rows into sales order.

  3. C

    Sort by Region A to Z, then add Sales as a secondary key from largest to smallest.

  4. D

    Sort by Region Z to A, then add Sales as a secondary key from smallest to largest.

08
Fill in the blank
1 point

To display only records where Region equals East and Sales is greater than 100, the criteria in these separate columns typically combine with .

09
Choose all
1 point

Select all statements that correctly describe how filter criteria are typically combined.

  1. A

    Selecting East or West in a Region filter typically shows records matching either selected value.

  2. B

    Selecting East or West in a Region filter typically shows only records whose Region is both East and West.

  3. C

    Filtering Region to East and Product to Books typically requires a record to meet both conditions.

  4. D

    Filtering Region to East and Product to Books typically requires a record to meet either condition, but not both.

10
Choose one
1 point

You need to locate one customer's name quickly, but later you want to inspect all records marked Open together. Which approach best matches these two tasks?

  1. A

    Use Find to hide all records except those containing the customer's name.

  2. B

    Use Find to locate a particular customer's name; use a filter when you want a matching subset to remain visible.

  3. C

    Use a filter to permanently remove records that do not contain the customer's name.

  4. D

    Use Find to sort every record by customer name and keep the matching records visible.

11
Choose all
1 point

Select all practices that help prepare a spreadsheet dataset for reliable sorting and filtering.

  1. A

    Give each column a clear, unique header.

  2. B

    Use a row to store parts of several different records whenever space is limited.

  3. C

    Store dates and numbers consistently as dates and numbers rather than as text.

  4. D

    Keep each row as one record and each column as one type of information.

12
Choose one
1 point

A filter is active, but some records you expected to see are missing. What is the most useful first troubleshooting step?

  1. A

    Sort the visible records repeatedly until the missing records appear.

  2. B

    Delete the filter and permanently remove records that do not match.

  3. C

    Assume that the filter has deleted the records and restore the spreadsheet from a backup.

  4. D

    Check the active criteria and look for inconsistent categories, misspellings, extra spaces, or numbers and dates stored as text.

13
Open ended
1 point

A sales table has columns for Region, Date, Product, and Sales. Describe a reliable workflow to prepare the table, show regions in A-to-Z order with the highest sales first within each region, and then inspect only East-region records with Sales greater than 100. Explain how the filter criteria combine, what happens to nonmatching records, and what to check if expected records are missing.

14
Choose one
1 point

Before sorting a spreadsheet table, which setup best helps the application identify and handle the data correctly?

  1. A

    Give each column a unique header, keep one record per row, and remove blank rows or columns that break up the data.

  2. B

    Leave the header row blank and separate each record with a blank row.

  3. C

    Put several kinds of information in each column so the table uses fewer columns.

  4. D

    Store dates and numbers as text so every cell has the same format.

15
True or false
1 point

After you clear or remove a spreadsheet filter, the previously hidden records appear in the table again.

  1. A

    True

  2. B

    False

16
Choose one
1 point

A transaction table should show its latest dates at the top. Which sort direction should you choose for the Date column?

  1. A

    Sort the dates from oldest to newest.

  2. B

    Sort the dates from newest to oldest.

  3. C

    Filter the date column to show only the latest date.

  4. D

    Search for each date individually.

17
Choose one
1 point

You need to sort a table by Sales but keep each sale attached to its original customer and date. What should you do?

  1. A

    Select only the Sales column so its values move independently.

  2. B

    Sort the rows one at a time, leaving the other columns untouched.

  3. C

    Select the complete data range and sort it using the chosen column.

  4. D

    Copy the sort-column values elsewhere, sort them, and leave the table unchanged.

18
Choose one
1 point

A table is filtered so that Region equals East and Sales is greater than 100. Which records will typically remain visible?

  1. A

    Records with Region equal to East or Sales greater than 100.

  2. B

    Records with Region equal to East and Sales greater than 100.

  3. C

    All records with Region equal to East, regardless of Sales.

  4. D

    Only records with Sales exactly equal to 100.

19
Written response
1 point

What is the term for a sort that uses a second key to order records tied on the first key? Enter the term.

20
Written response
1 point

What is the name of the spreadsheet feature that can save or use a set of filter criteria without changing what collaborators see?