01
Choose one
1 point
A team wants to show how monthly revenue changes over a year. Which chart type is most appropriate?
Free Practice Quiz Question List
9 Basic Data Analysis Workflows Online Quiz Questions
Use this free practice quiz with 20 questions to review 9 Basic Data Analysis Workflows, test your knowledge, and prepare for your next test or exam.
20 questions
02
Written response
1 point
A report needs one statistic describing the difference between the largest and smallest observed values. What is this statistic called?
03
Fill in the blank
1 point
To summarize total revenue by category in a pivot table, place in the rows area and in the values area, summarized by sum.
04
Choose one
1 point
In a sales table, Units is in column D and Unit Price is in column E. Which spreadsheet formula calculates revenue for row 2 by multiplying units by unit price?
- A
=D2+E2 - B
=D2*E2 - C
=SUM(D2:E2) - D
=D2/E2
05
Written response
1 point
A few unusually large transactions pull the mean revenue upward. Which measure of center would help describe the middle transaction with less influence from those extreme values?
06
Fill in the blank
1 point
A chart compares revenue across product categories. To make the measurements interpretable, label the axes and include the appropriate .
07
Choose one
1 point
An analyst enters =AVERAGE(F2:F20) to calculate a mean. What is AVERAGE in this expression?
- A
A filter
- B
A function
- C
A record
- D
A pivot table
08
Choose all
1 point
Before comparing total sales by category, which checks can help determine whether the sales records are fit for that analysis? Select all that apply.
- A
Check whether important values are blank or marked N/A.
- B
Check that dates, category names, and units use consistent formats.
- C
Check whether values are plausible and within the intended period.
- D
Check for records that appear more than once.
- E
Delete every unusual value without investigating or documenting the decision.
09
Choose one
1 point
Revenue rose after a promotion. Which conclusion is supported if the analysis design does not establish causation?
- A
The promotion caused the increase because the increase happened afterward.
- B
Revenue increased after the promotion, but this observation alone does not establish that the promotion caused the increase.
- C
The increase proves that every category performed better.
10
Choose all
1 point
A manager needs to use a category-revenue comparison for a decision. Which elements should a concise report include to make the finding understandable and appropriately qualified? Select all that apply.
- A
The question and scope of the analysis
- B
The main finding, with an appropriate number or chart
- C
How records were prepared and summarized
- D
Relevant limitations, assumptions, or reasons for caution
- E
What the result may mean for the decision at hand
- F
A claim that the result applies to every population, even when only recorded transactions were examined
11
Open ended
1 point
A dataset of transaction revenues has a mean much higher than its median. Describe how you would investigate this result and communicate it to a decision-maker, including checks, suitable summaries, and relevant cautions.
12
Choose one
1 point
An analyst needs the built-in operation for calculating the mean of a selected set of values in a spreadsheet. Which kind of tool should they use in a formula?
- A
A filter
- B
A function
- C
A chart
- D
A record
13
True or false
1 point
True or false: Keeping an unchanged copy of the original data makes it possible to check later changes against the original.
- A
True
- B
False
14
Choose one
1 point
You want to compare total sales revenue across product categories for one quarter. Which chart type is most suitable for making the category comparisons clear?
- A
A line chart
- B
A bar or column chart
- C
A histogram
- D
A scatter plot
15
Choose one
1 point
You are setting up a spreadsheet of sales records so it can be analyzed reliably. Which layout best follows the recommended rectangular-table structure?
- A
Put each record in a separate worksheet and use merged cells for shared headings.
- B
Use one row for each variable and put record values in additional header rows.
- C
Use one header row, one record per row, and one variable per column.
- D
Combine multiple variables into each column to reduce the number of columns.
16
Written response
1 point
A dataset has a few unusually large transaction values that may pull its mean upward. Which measure of center should you compare with the mean to help reveal this pattern?
17
True or false
1 point
True or false: Filtering a dataset to show records from one region proves that the displayed records are representative of the full dataset.
- A
True
- B
False
18
Written response
1 point
In a sales spreadsheet, Units is in column D and Unit Price is in column E. Enter the formula that calculates revenue for the record in row 2.
19
Choose one
1 point
You need a pivot table that answers “What was the total revenue for each product category?” Which setup will produce that summary?
- A
Place Revenue in rows and Category in values, summarized by count.
- B
Place Category in rows and Revenue in values, summarized by sum.
- C
Place Category in values and Revenue in rows, summarized by average.
- D
Place Revenue in rows and Category in values, summarized by sum.
20
True or false
1 point
A sales analysis produces a surprising total. Before drawing a conclusion, a sound next step is to verify key totals against the source records and investigate the surprising result.
- A
True
- B
False