Free Practice Quiz Question List

7 Basic Spreadsheet Data Analysis Online Quiz Questions

Use this free practice quiz with 20 questions to review 7 Basic Spreadsheet Data Analysis, test your knowledge, and prepare for your next test or exam.

20 questions

True or false

1 point

True or false: Exploratory analysis can reveal patterns and anomalies, but it does not by itself prove what caused them.

A
True
B
False

Fill in the blank

1 point

A well-structured spreadsheet table has one row per and one column per variable.

Written response

1 point

Before cleaning a dataset, what should you preserve separately so your work does not overwrite the source?

Choose one

1 point

For the question “Which region had the highest total sales this quarter?”, which setup correctly identifies the measure, group, and scope?

A
Measure: region; group: quarter; scope: total sales.
B
Measure: total sales; group: region; scope: the quarter in question.
C
Measure: number of orders; group: product; scope: all available records.
D
Measure: total sales; group: individual order; scope: one region.

Fill in the blank

1 point

Filtering hides rows that do not meet a condition; it does not them from the source data.

Written response

1 point

In a spreadsheet, what is a built-in calculation used within a formula called?

Choose one

1 point

A manager wants to show how sales change from month to month. Which chart type is most appropriate for displaying that change over time?

A
A column chart
B
A pie chart
C
A line chart
D
A bar chart

Choose all

1 point

Which actions support reliable spreadsheet data preparation? Select all that apply.

A
Keep an untouched copy of the original data.
B
Check for missing values, duplicates, impossible values, and unexpected categories.
C
Automatically delete every duplicate record.
D
Use consistent formats and meanings within each column.

Choose one

1 point

You need a PivotTable showing total revenue for each region. Which configuration best answers the question?

A
Put Revenue in Rows and Region in Values, summarized by Count.
B
Put Region in Rows and Revenue in Values, summarized by Sum.
C
Put Region in Rows and Revenue in Values, summarized by Count.
D
Put Date in Rows and Region in Values, summarized by Sum.

True or false

1 point

True or false: If a spreadsheet contains an outlier, you should discard it before checking whether it is a legitimate value or a data problem.

A
True
B
False

Choose all

1 point

Which checks can help verify a spreadsheet analysis before you draw a conclusion? Select all that apply.

A
Confirm that formula ranges include the intended data rows and exclude headers or totals that could be counted twice.
B
Compare a result calculated two ways, such as a PivotTable grand total against a SUM formula.
C
Check that filters and date boundaries are correct.
D
Inspect surprising values in the original records.

Open ended

1 point

You have compared recorded revenue across regions for a quarter. What should a clear summary of the finding include so readers can understand the result and its limitations?

Choose one

1 point

A dataset of transaction amounts is strongly skewed by a few unusually large values. Which measure is often more representative of a typical transaction amount?

A
Use the mean because it is unaffected by extreme values.
B
Use the median because it is often more representative when values are skewed.
C
Use the maximum because it represents a typical observation.
D
Use the range because it is the arithmetic average.

True or false

1 point

True or false: If the source data changes, you should refresh a PivotTable so its summary reflects the updated data.

A
True
B
False

Choose one

1 point

You need to clean and analyze a spreadsheet but want to preserve the original records. What should you do first?

A
Edit the original data directly so all changes are in one place.
B
Make a separate sheet or copy for cleaning and analysis.
C
Delete the original data after creating a summary.
D
Merge the original data cells to make them easier to read.

Choose one

1 point

You are organizing sales records so they can be sorted, filtered, and summarized reliably. Which layout is most appropriate?

A
One row per variable, one column per observation, and a header row repeated for each category.
B
One row per observation, with several variables combined in a single column.
C
One row per observation, one column per variable, and one clear header row.
D
One row per category, with merged cells for observations and variables.

Choose one

1 point

A manager wants to see how recorded revenue changes from month to month. Which chart choice best supports that comparison?

A
A pie chart with no axis labels.
B
A line chart with a descriptive title and labeled axes with units.
C
A decorative 3-D chart with unlabeled axes.
D
A column chart with no title or units.

Written response

1 point

Recorded order revenues are strongly skewed because a few orders are exceptionally large. Which statistic is often more representative of a typical order than the mean?

Choose one

1 point

You apply a filter to show only sales from one region. What happens to records from the other regions?

A
It permanently deletes every row that does not meet the condition.
B
It changes the values in rows that do not meet the condition.
C
It hides rows that do not meet the condition but does not remove them from the source data.
D
It adds rows that meet the condition to the source data.

Written response

1 point

Which built-in spreadsheet function is used in =SUMIF(B2:B101,"North",E2:E101) to total revenue only for rows where the region is North?