Timedora
Free Practice Quiz Question List

6. Filtering and Exploring Data Online Quiz Questions

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

20 questions
01
Choose one
1 point

Which operation displays only the rows that satisfy one or more specified conditions?

  1. A

    Rearranging rows according to one or more columns

  2. B

    Displaying only rows that satisfy one or more conditions

  3. C

    Combining records into category or interval summaries

  4. D

    Reducing many values to a summary value

02
Choose one
1 point

A data analyst wants to examine whether two numeric variables are related. Which visual tool is most appropriate?

  1. A

    A scatter plot

  2. B

    A histogram

  3. C

    A bar chart

  4. D

    A line chart

03
Written response
1 point

An order contains 2 units priced at $10 each, and another contains 8 units priced at $20 each. What is the weighted average price per unit?

04
Fill in the blank
1 point

Complete the statement: creates categories for comparing records that share a category or interval.

05
True or false
1 point

True or false: If a line chart shows sales and advertising increasing at the same time, the chart alone proves that advertising caused the sales increase.

  1. A

    True

  2. B

    False

06
Written response
1 point

A route has 8 late trips out of 10 total trips. What is its late-trip rate? Enter the percentage-point value; a nonzero tolerance is not allowed.

07
Fill in the blank
1 point

Complete the formula: Revenue = .

08
Choose all
1 point

Which practices support a reproducible data-analysis workflow? Select all correct choices.

  1. A

    Keep an unchanged copy of the original data

  2. B

    Record formulas, filter conditions, and software settings

  3. C

    Overwrite the raw data after each transformation

  4. D

    Explain which records were omitted and why

09
Choose one
1 point

When sorting a table by one column, which action helps prevent values from becoming detached from their records?

  1. A

    Sort only the column containing the values of interest

  2. B

    Delete rows that are not in the desired order

  3. C

    Select and sort the complete table

  4. D

    Convert every category into a numeric value

10
Choose all
1 point

Which situations can produce misleading conclusions in data analysis? Select all correct choices.

  1. A

    A chart omits selected regions without stating the excluded population

  2. B

    Two percentages are compared even though their denominators differ substantially

  3. C

    An analyst investigates an unusual value and documents why it is retained

  4. D

    A vertical axis begins far above zero without clear explanation

11
Choose one
1 point

In a PivotTable, which setup would produce total units for each region?

  1. A

    Place Units in the row area and leave Region unused

  2. B

    Place Region in the values area and use Count on Units

  3. C

    Place Region in the row area and summarize Units with Sum

  4. D

    Sort the Unit Price column from largest to smallest

12
True or false
1 point

True or false: A histogram is an appropriate visual tool for inspecting the distribution of a numeric variable.

  1. A

    True

  2. B

    False

13
Open ended
1 point

Design a reproducible analysis for comparing late arrivals across transportation routes. Describe the filtering rule, validation checks, calculated fields and summaries, comparison method, visual or tabular outputs, and documentation needed to avoid misleading conclusions.

14
Choose one
1 point

Which practice best prevents premature rounding from changing calculated totals or averages?

  1. A

    Round every input before calculating a total

  2. B

    Keep full precision during calculations and round only the final presentation

  3. C

    Replace unusually large values with the nearest rounded value

  4. D

    Round the denominator but not the numerator

15
Choose one
1 point

A data analyst applies a filter for Region = West using a spreadsheet filter view. What does this action do?

  1. A

    It permanently deletes every row that does not satisfy the condition.

  2. B

    It displays only rows that satisfy the condition without changing the underlying values.

  3. C

    It automatically sorts the remaining rows from largest to smallest.

  4. D

    It replaces missing values in the filtered column.

16
Choose one
1 point

Why should an analyst select the complete table before sorting a data set by one column?

  1. A

    It prevents the sort from using numbers stored as text.

  2. B

    It guarantees that missing values will be placed at the bottom.

  3. C

    It keeps values in the same records while the rows are rearranged.

  4. D

    It converts a single-level sort into a multilevel sort.

17
Choose one
1 point

Two orders have very different numbers of units, and an analyst wants the average price paid per unit across all units. Which calculation is most appropriate?

  1. A

    Total revenue divided by total units

  2. B

    The arithmetic mean of the unit prices of all orders

  3. C

    The largest unit price minus the smallest unit price

  4. D

    Total units divided by the number of orders

18
True or false
1 point

True or false: If a line chart shows that advertising and sales increased during the same period, the chart alone proves that advertising caused the increase in sales.

  1. A

    True

  2. B

    False

19
Written response
1 point

What is the data-analysis operation called when records are combined into categories such as region, month, or age interval?

20
Written response
1 point

A route has 8 late trips out of 10 total trips. What is its late-trip rate? Enter the numeric percentage-point value; no tolerance is allowed.