Skip to content
Pass Any WGU OA Exam Now & Pay After You Pass. Contact Us!
  1. Home
  2. WGU Exams
  3. WGU D388
  4. Set 5
WGU D388 · Fundamentals of Spreadsheets and Data Presentations

WGU D388 Practice Questions – Set 5

50 multiple-choice questions with answers and detailed explanations. Untimed — choose an answer to check it instantly.

Question 1 of 50

What is the primary goal of inferential statistics?

Question 2 of 50

In a statistical context, what does the term "sample" refer to?

Question 3 of 50

Which scale of measurement provides the most precise information?

Question 4 of 50

What does the "mean" of a dataset represent?

Question 5 of 50

Which Excel function would you use to calculate the total number of numeric entries in a range?

Question 6 of 50

What does "data visualization" aim to achieve?

Question 7 of 50

In a box plot, what do the "whiskers" represent?

Question 8 of 50

When is it appropriate to use a bar chart?

Question 9 of 50

What is the purpose of "data cleaning"?

Question 10 of 50

Which statistical test would you use to determine if there is a significant difference between the means of two groups?

Question 11 of 50

What does "skewness" measure in a dataset?

Question 12 of 50

What is the role of a "legend" in a chart?

Question 13 of 50

When is it appropriate to use a pie chart?

Question 14 of 50

When you use the Remove Duplicates command, how does Excel decide whether two rows are duplicates?

Question 15 of 50

A limitation to be aware of when using Remove Duplicates is that it:

Question 16 of 50

The Text to Columns feature is most appropriate when you need to:

Question 17 of 50

In the Text to Columns wizard, what does the Fixed width option do?

Question 18 of 50

Goal Seek is best described as a what-if tool that:

Question 19 of 50

Which what-if analysis tool lets you define and compare several named sets of input values (for example Best Case, Worst Case) for the same cells?

Question 20 of 50

A one-variable data table in Excel is used to:

Question 21 of 50

When you use the Freeze Panes command with the active cell in C4, what happens?

Question 22 of 50

What is the difference between the Freeze Panes and Split commands on the View tab?

Question 23 of 50

When importing data from a CSV file, why might the TRIM function be applied to the resulting text columns during cleaning?

Question 24 of 50

When cleaning imported data, which function is best for standardizing inconsistent capitalization such as jOHN smith into John Smith?

Question 25 of 50

A retail manager wants to compare monthly sales revenue for five different product categories in a single quarter. Which chart type is most appropriate?

Question 26 of 50

You need to display the relationship between advertising spend and resulting sales to see whether higher spending correlates with higher revenue. Which chart type best reveals this correlation?

Question 27 of 50

A data analyst wants to show how the ages of 500 survey respondents are distributed across ranges such as 20-29, 30-39, and 40-49. Which chart is most suitable?

Question 28 of 50

A financial report needs to display both total monthly revenue (in dollars) and the profit margin percentage on the same chart, where the two metrics use very different scales. Which chart type is most appropriate?

Question 29 of 50

Which chart element provides a key that identifies what each color or series in the chart represents?

Question 30 of 50

What is the primary purpose of adding data labels to a chart?

Question 31 of 50

A sparkline in Excel is best described as which of the following?

Question 32 of 50

Which of the following sparkline types is best suited for showing whether monthly cash flow values were positive or negative?

Question 33 of 50

When designing an effective dashboard, which principle should generally guide the placement of the most important key performance indicators (KPIs)?

Question 34 of 50

Which practice most directly reduces visual clutter and improves the clarity of a data visualization?

Question 35 of 50

A bar chart's vertical axis begins at 50 instead of 0, making a small difference between two bars appear dramatic. Why is this considered a misleading practice?

Question 36 of 50

Which of the following best represents a best practice for using color in data visualizations?

Question 37 of 50

Why is a pie chart with twelve nearly equal slices generally considered a poor visualization choice?

Question 38 of 50

To make a table of financial figures easier to read at a glance, an analyst formats values like 1500000 as $1.5M. What is the main benefit of this presentation choice?

Question 39 of 50

What is the primary purpose of a chart title?

Question 40 of 50

When telling a story with data in a presentation, which approach is most effective for guiding your audience to the intended conclusion?

Question 41 of 50

Horizontal gridlines in a column chart primarily serve which purpose?

Question 42 of 50

A company wants to visualize the composition of its total budget across four departments as percentages of the whole. Which chart type is most appropriate?

Question 43 of 50

Which of the following is a recommended best practice when choosing a scale for a chart's value axis in a time-series line chart?

Question 44 of 50

An analyst is building a dashboard and wants each chart to be quickly understood by decision-makers. Which design guideline best supports this goal?

Question 45 of 50

Which chart type is most appropriate for showing the trend of a single company's stock price recorded daily over one year?

Question 46 of 50

Why should a designer avoid using a wide variety of unrelated bright colors across a single dashboard?

Question 47 of 50

What does the horizontal (category) axis typically represent in a standard column chart?

Question 48 of 50

A newspaper chart uses pictures of money bags of increasing size, where doubling a value makes the bag both twice as tall and twice as wide, quadrupling its area. Why is this misleading?

Question 49 of 50

Which formatting choice is most effective for presenting a column of percentages so they are immediately recognizable and consistent?

Question 50 of 50

An analyst wants to add a short piece of text directly on a line chart to explain a sudden spike caused by a product launch. What is this element called and why is it useful?

Set 5 complete

You scored 0%

0 correct out of 0 answered (50 questions in this set).

Struggling with WGU D388?

If this exam is giving you a hard time, let us be your helping hand. Contact us, and we'll provide the assistance you need to pass and move forward.

Chat Now