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.
0/50 answered0 correct
Question 1 of 50
What is the primary goal of inferential statistics?
Correct answer: B) To make predictions or generalizations about a population based on sample data
Explanation: Inferential statistics uses sample data to make inferences about a larger population, allowing researchers to draw conclusions beyond the immediate data set.
Question 2 of 50
In a statistical context, what does the term "sample" refer to?
Correct answer: B) A portion of the population selected for analysis
Explanation: A sample is a subset drawn from a larger population, used for statistical analysis to infer characteristics about the whole population.
Question 3 of 50
Which scale of measurement provides the most precise information?
Correct answer: D) Ratio
Explanation: The ratio scale provides the highest level of measurement precision, including an absolute zero point and meaningful ratios between values.
Question 4 of 50
What does the "mean" of a dataset represent?
Correct answer: C) The average of all the values
Explanation: The mean is calculated by summing all values in a dataset and dividing by the number of values, reflecting the central tendency.
Question 5 of 50
Which Excel function would you use to calculate the total number of numeric entries in a range?
Correct answer: A) COUNT
Explanation: The COUNT function counts only the cells containing numeric values within the specified range.
Question 6 of 50
What does "data visualization" aim to achieve?
Correct answer: B) To present data in a visual context to enhance understanding
Explanation: Data visualization transforms raw data into graphical formats, making it easier for users to grasp insights and trends.
Question 7 of 50
In a box plot, what do the "whiskers" represent?
Correct answer: B) The maximum and minimum values excluding outliers
Explanation: In a box plot, whiskers extend to the highest and lowest values that are not considered outliers, providing insight into the spread of the main body of data.
Question 8 of 50
When is it appropriate to use a bar chart?
Correct answer: B) To illustrate the frequency of different categories
Explanation: Bar charts are ideal for comparing discrete categories, using bars to represent the frequency or value associated with each category.
Question 9 of 50
What is the purpose of "data cleaning"?
Correct answer: B) To remove inaccuracies and inconsistencies from the dataset
Explanation: Data cleaning ensures that the dataset is accurate and reliable before analysis, which is essential for producing valid results.
Question 10 of 50
Which statistical test would you use to determine if there is a significant difference between the means of two groups?
Correct answer: B) T-test
Explanation: A T-test is used to compare the means of two groups to determine if there is a statistically significant difference between them.
Question 11 of 50
What does "skewness" measure in a dataset?
Correct answer: B) The measure of symmetry of the distribution
Explanation: Skewness quantifies how much a distribution deviates from symmetry, indicating the direction (left or right) of the skew.
Question 12 of 50
What is the role of a "legend" in a chart?
Correct answer: B) To indicate what each color or pattern represents
Explanation: The legend clarifies the meaning of different colors or patterns used in the chart, helping viewers understand the data series.
Question 13 of 50
When is it appropriate to use a pie chart?
Correct answer: A) To show trends over time
Question 14 of 50
When you use the Remove Duplicates command, how does Excel decide whether two rows are duplicates?
Correct answer: B) By comparing the values in the columns you select in the Remove Duplicates dialog
Explanation: Remove Duplicates evaluates the columns you check in its dialog. Two rows are duplicates only if they match across all selected columns. If you check only one column, rows with the same value there are removed even if other columns differ; checking more columns makes the match more specific. The first occurrence is kept and later duplicates are deleted.
Question 15 of 50
A limitation to be aware of when using Remove Duplicates is that it:
Correct answer: A) Permanently deletes the duplicate rows rather than just hiding them
Explanation: Remove Duplicates actually deletes the extra rows from the worksheet; it does not hide them the way a filter would. Because the removal is destructive, it is wise to work on a copy of the data or use a filter/formula approach first if you might need the duplicates later. Undo can reverse it immediately, but not after further edits.
Question 16 of 50
The Text to Columns feature is most appropriate when you need to:
Correct answer: B) Split a single column of combined data (such as Smith, John) into multiple columns
Explanation: Text to Columns parses one column into several by splitting on a delimiter (comma, space, tab, semicolon) or by fixed character widths. It is ideal for separating full names, addresses, or delimited imported data into distinct fields. To do the reverse, joining columns, you would use CONCAT, TEXTJOIN, or the ampersand operator instead.
Question 17 of 50
In the Text to Columns wizard, what does the Fixed width option do?
Correct answer: A) Splits data at specific character positions you set with break lines rather than at a delimiter
Explanation: The Fixed width option lets you divide text based on column positions rather than a separating character. You click in the data preview to insert, move, or delete break lines at exact character positions. This is useful for legacy reports where fields align in fixed columns without commas or tabs between them.
Question 18 of 50
Goal Seek is best described as a what-if tool that:
Correct answer: A) Finds the input value needed to make a formula produce a specific target result
Explanation: Goal Seek works backward: you specify a formula cell, the target value you want it to equal, and one input cell to change. Excel iteratively adjusts that single input until the formula reaches the goal. For example, it can find the sales volume required to hit a target profit. It handles only one variable at a time.
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?
Correct answer: B) Scenario Manager
Explanation: Scenario Manager stores multiple named scenarios, each holding a different set of values for a group of changing cells. You can switch between scenarios to see how results change and generate a summary report comparing them. This makes it well suited to modeling best-case, expected, and worst-case assumptions in a single workbook.
Question 20 of 50
A one-variable data table in Excel is used to:
Correct answer: A) Show how one or more formula results change as a single input value varies across a list
Explanation: A one-variable data table substitutes a series of values into one input cell and records how the referenced formula(s) respond to each. The varying values run down a column or across a row, and Excel fills in the corresponding results. It's ideal for sensitivity analysis, such as seeing loan payments across a range of interest rates.
Question 21 of 50
When you use the Freeze Panes command with the active cell in C4, what happens?
Correct answer: A) Everything above row 4 and to the left of column C is frozen while scrolling
Explanation: Freeze Panes locks the rows above and the columns to the left of the active cell. With C4 selected, rows 1 to 3 and columns A to B remain visible as you scroll down and right. This keeps headers and label columns in view. Freeze Top Row and Freeze First Column are quick presets that lock only that single row or column.
Question 22 of 50
What is the difference between the Freeze Panes and Split commands on the View tab?
Correct answer: B) Freeze Panes locks rows/columns so they stay visible; Split divides the window into independently scrollable panes
Explanation: Freeze Panes keeps chosen rows and columns fixed on screen while the rest scrolls, and the frozen area cannot be scrolled. Split divides the window into two or four panes, each with its own scroll bars, so you can view and scroll different parts of the same sheet simultaneously. You can drag or remove the split bars freely.
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?
Correct answer: B) To remove leading, trailing, and extra internal spaces that can cause matching and lookup errors
Explanation: Imported data often contains stray spaces at the start or end of entries, or multiple spaces between words, which cause lookups and comparisons to fail even when values look identical. TRIM removes leading and trailing spaces and collapses internal runs of spaces to single spaces, standardizing text so joins, filters, and VLOOKUP-style matches work correctly.
Question 24 of 50
When cleaning imported data, which function is best for standardizing inconsistent capitalization such as jOHN smith into John Smith?
Correct answer: B) PROPER
Explanation: PROPER capitalizes the first letter of each word and lowercases the rest, turning jOHN smith into John Smith, which is ideal for names and titles. UPPER and LOWER force a single case throughout, and TRIM handles spacing rather than capitalization. Combining PROPER with TRIM is a common step when normalizing messy imported text.
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?
Correct answer: A) Clustered column chart
Explanation: A clustered column chart is ideal for comparing discrete values across multiple categories, allowing side-by-side visual comparison of each product category. A pie chart only shows parts of a single whole, a scatter plot displays correlation between two numeric variables, and a histogram shows the frequency distribution of a single continuous variable rather than comparing categories.
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?
Correct answer: C) Scatter plot
Explanation: A scatter plot plots two continuous numeric variables against each other, making it the best choice for revealing correlation or the strength and direction of a relationship between advertising spend and sales. Pie and stacked bar charts show composition, and a line chart is best for showing a single variable's trend over ordered time intervals rather than the relationship between two independent variables.
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?
Correct answer: A) Histogram
Explanation: A histogram is designed to display the frequency distribution of a continuous variable grouped into bins or intervals, making it perfect for showing how ages fall into ranges. Unlike a bar chart, a histogram's bars represent continuous intervals and typically touch. Pie charts show proportions of a whole, line charts show trends over time, and scatter plots show relationships between two variables.
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?
Correct answer: A) Combo chart with a secondary axis
Explanation: A combo chart (for example, columns for revenue and a line for profit margin) with a secondary vertical axis lets you plot two data series that have very different scales and units on the same visual, keeping both readable. A single-axis chart would flatten the smaller-scale series, and pie or doughnut charts cannot represent two distinct metrics tracked over time.
Question 29 of 50
Which chart element provides a key that identifies what each color or series in the chart represents?
Correct answer: B) Legend
Explanation: The legend serves as a key, mapping each color, pattern, or marker to the data series it represents, which is essential when a chart contains more than one series. Gridlines are reference lines behind the plot area, data labels show the exact value of individual data points, and an axis title labels what a given axis measures.
Question 30 of 50
What is the primary purpose of adding data labels to a chart?
Correct answer: A) To display the exact numeric value of individual data points directly on the chart
Explanation: Data labels display the precise value (or category name or percentage) of specific data points directly on or next to the plotted elements, letting readers read exact numbers without estimating against the axis. Identifying series colors is the legend's job, horizontal reference lines are gridlines, and describing the chart's subject is the chart title's role.
Question 31 of 50
A sparkline in Excel is best described as which of the following?
Correct answer: A) A small, cell-sized chart that shows a trend for a single row or range of data
Explanation: A sparkline is a tiny chart contained within a single cell that provides a compact visual representation of the trend in an adjacent range of data, such as monthly sales across a row. It is ideal for dashboards and tables where space is limited. It is not a full separate chart, a formatting rule, or a pivot table feature.
Question 32 of 50
Which of the following sparkline types is best suited for showing whether monthly cash flow values were positive or negative?
Correct answer: C) Win/Loss sparkline
Explanation: A Win/Loss sparkline displays each value as an identical-height marker pointing up or down depending only on whether the value is positive or negative, making it ideal for at-a-glance profit/loss or gain/loss patterns. Line and column sparklines emphasize the magnitude and trend of values, and Excel does not offer an area sparkline type.
Question 33 of 50
When designing an effective dashboard, which principle should generally guide the placement of the most important key performance indicators (KPIs)?
Correct answer: A) Place them in the top-left area where viewers naturally look first
Explanation: Because viewers in left-to-right reading cultures naturally scan starting from the top-left, the most important KPIs should be placed there so they are seen first. Burying critical metrics at the bottom, hiding them, or scattering them randomly undermines the dashboard's goal of communicating key information quickly and clearly.
Question 34 of 50
Which practice most directly reduces visual clutter and improves the clarity of a data visualization?
Correct answer: B) Removing unnecessary gridlines, borders, and decorative elements
Explanation: Removing non-essential elements, sometimes called reducing chart junk, increases the data-to-ink ratio so the actual data stands out and the message is clearer. Adding 3-D effects, using excessive colors, or cramming in every series all increase cognitive load and distract from the information the chart is meant to convey.
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?
Correct answer: A) It exaggerates the visual difference between values, distorting the reader's interpretation
Explanation: Truncating the value axis so it does not start at zero exaggerates the proportional difference between bars, causing readers to perceive a much larger gap than actually exists. For bar and column charts, the axis should generally start at zero so the length of each bar accurately represents its value. The other options are unrelated to axis scaling.
Question 36 of 50
Which of the following best represents a best practice for using color in data visualizations?
Correct answer: B) Use color purposefully to highlight key data and rely on muted tones for context
Explanation: Effective color use is purposeful: a distinct highlight color draws attention to the most important data, while muted or neutral tones provide supporting context, creating a clear visual hierarchy. Saturating everything eliminates emphasis, relying only on red and green creates problems for color-blind viewers, and inconsistent color meaning confuses readers.
Question 37 of 50
Why is a pie chart with twelve nearly equal slices generally considered a poor visualization choice?
Correct answer: B) The human eye struggles to compare the areas and angles of many similar slices
Explanation: People are poor at accurately judging and comparing the angles and areas of pie slices, especially when there are many slices of similar size, making differences hard to perceive. A bar or column chart, whose lengths are much easier to compare, is a better choice when there are many categories. Pie charts have no hard limit of five values and do not use secondary axes or time series.
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?
Correct answer: B) It improves readability and reduces cognitive load without altering the actual data
Explanation: Applying a display format such as abbreviated millions or thousands makes large numbers easier to scan and interpret while leaving the actual stored value unchanged, so formulas still calculate correctly. Number formatting affects only how the value appears, not the value itself, and it does not convert numbers to text or affect unrelated cells.
Question 39 of 50
What is the primary purpose of a chart title?
Correct answer: B) To concisely describe what the chart is showing so the audience understands its subject
Explanation: A chart title gives the audience immediate context about the chart's subject and purpose, ideally summarizing the key takeaway. Identifying series by color is the legend's function, showing exact point values is done with data labels, and reference lines across the plot area are gridlines.
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?
Correct answer: B) Emphasize the key insight visually and structure the narrative around it
Explanation: Effective data storytelling focuses the audience on a clear key insight, using visual emphasis (such as a highlight color or annotation) and a logical narrative structure to guide interpretation toward the intended conclusion. Dumping raw data, overusing chart types, or omitting helpful annotations all make it harder for the audience to grasp the message.
Question 41 of 50
Horizontal gridlines in a column chart primarily serve which purpose?
Correct answer: B) They help the reader estimate the value of each data point against the value axis
Explanation: Gridlines are light reference lines extending from the axis across the plot area that help readers visually align data points with the axis scale to estimate values more accurately. They do not label categories (axis labels do that), identify series (the legend does that), or serve as a title. Overly heavy gridlines can add clutter, so they should be kept subtle.
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?
Correct answer: C) Pie chart
Explanation: A pie chart is well suited to showing how a single total is divided into a small number of parts (here, four departments), emphasizing each part's share of the whole. With only four categories, the slices are easy to compare. A line chart shows trends over time, a scatter plot shows relationships between variables, and a histogram shows frequency distributions.
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?
Correct answer: B) Choose a scale and intervals that represent the data honestly without exaggerating or minimizing changes
Explanation: An honest, appropriate axis scale with consistent, sensible intervals ensures that the visual magnitude of changes matches their real magnitude, so the chart neither exaggerates nor understates trends. Deliberately compressing or stretching the axis distorts interpretation, random intervals mislead, and removing the axis leaves readers unable to gauge values.
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?
Correct answer: B) Keep the layout simple, consistent, and focused on the most relevant metrics
Explanation: A good dashboard is simple, consistent, and focused, presenting the most relevant metrics clearly so decision-makers grasp the situation quickly. Overloading the screen with metrics, using inconsistent fonts and colors, or forcing excessive scrolling all reduce clarity and slow comprehension.
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?
Correct answer: A) Line chart
Explanation: A line chart is ideal for displaying how a single continuous value changes over many ordered time intervals, such as daily stock prices across a year, because the connected line makes the overall trend and fluctuations easy to follow. A pie or doughnut chart shows composition at one point in time, and a clustered column chart with 365 columns would be far too cluttered for a dense daily series.
Question 46 of 50
Why should a designer avoid using a wide variety of unrelated bright colors across a single dashboard?
Correct answer: B) It creates visual noise and makes it harder to identify what is important
Explanation: Using many unrelated bright colors overwhelms the viewer, creating visual noise that competes for attention and makes it difficult to discern which elements matter most. A restrained, consistent palette with intentional highlight colors communicates hierarchy more effectively. Color choice does not affect file size, calculation, or legend behavior.
Question 47 of 50
What does the horizontal (category) axis typically represent in a standard column chart?
Correct answer: B) The categories or groups being compared
Explanation: In a standard column chart, the horizontal axis (also called the category or x-axis) lists the discrete categories or groups being compared, while the vertical axis shows the measured values. The color key is provided by the legend, and cumulative totals would require a specific chart type such as a running-total line rather than being an inherent function of the horizontal axis.
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?
Correct answer: A) The area grows far faster than the underlying value, exaggerating the difference
Explanation: When an icon is scaled in both width and height to represent a value, its two-dimensional area increases with the square of the scaling factor, so a value that doubles appears about four times larger. This exaggerates differences and misleads viewers. Accurate pictographs should scale by count or by a single dimension, not by area.
Question 49 of 50
Which formatting choice is most effective for presenting a column of percentages so they are immediately recognizable and consistent?
Correct answer: B) Apply the percentage format with a consistent number of decimal places, e.g., 45.2%
Explanation: Applying Excel's percentage number format with a consistent number of decimal places (such as 45.2%) makes the values instantly recognizable as percentages and keeps the column visually uniform and easy to scan. Leaving them as raw decimals is harder to interpret, converting to text prevents calculation, and coloring every row differently adds clutter without adding meaning.
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?
Correct answer: B) An annotation, which provides context that guides interpretation of the data
Explanation: An annotation is explanatory text (often with a callout or arrow) placed on a chart to give context about a specific data point or event, helping the audience understand why something happened and guiding interpretation. It is central to data storytelling. Gridlines aid value estimation, legends identify series, and a secondary axis rescales a series, none of which explain events.
Set 5 complete
You scored 0%
0 correct out of 0 answered (50 questions in this set).