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 1
WGU D388 · Fundamentals of Spreadsheets and Data Presentations

WGU D388 Practice Questions – Set 1

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 function of statistics in data analysis?

Question 2 of 50

A dataset consists of a large number of data points. What does the term "population" refer to in statistics?

Question 3 of 50

When dealing with discrete variables, which of the following is true?

Question 4 of 50

Which of the following best describes the "mode" in a data set?

Question 5 of 50

What is a primary characteristic of the mean as a measure of central tendency?

Question 6 of 50

In the context of statistical data, what does the term "cumulative frequency" refer to?

Question 7 of 50

What is the purpose of stratified sampling?

Question 8 of 50

Which of the following best defines "sampling error"?

Question 9 of 50

What does the term "graphical method" in data presentation refer to?

Question 10 of 50

In Excel, which of the following functions would you use to calculate the total number of non-blank cells in a dataset?

Question 11 of 50

If you want to ensure that the row reference remains constant when copying a formula in Excel, which type of reference should you use?

Question 12 of 50

What is the purpose of a "pivot table" in Excel?

Question 13 of 50

In statistics, what does "data cleaning" refer to?

Question 14 of 50

What kind of chart would be most appropriate for displaying parts of a whole?

Question 15 of 50

What is the purpose of using the TRIM function in Excel?

Question 16 of 50

In Excel, how is the order of operations prioritized when evaluating formulas?

Question 17 of 50

What does the "filtering" feature in Excel allow users to do?

Question 18 of 50

When conducting data analysis, why is it important to account for outliers?

Question 19 of 50

What is the result of using the TEXTSPLIT function in Excel?

Question 20 of 50

What is the function of the MAX formula in Excel?

Question 21 of 50

In which scenario would you use the AVERAGE function?

Question 22 of 50

What does the term "parsing" refer to in data management?

Question 23 of 50

Which Excel function would you use to identify how many cells contain numeric values?

Question 24 of 50

In Excel, how does an absolute reference differ from a relative reference?

Question 25 of 50

What are the three main strategies for dealing with missing values in a dataset?

Question 26 of 50

What is the purpose of using filters in Excel?

Question 27 of 50

What does the term "range" refer to in Excel?

Question 28 of 50

Which type of chart is best for comparing trends over time?

Question 29 of 50

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

Question 30 of 50

How can you determine the median in a dataset?

Question 31 of 50

Which of the following is an example of a categorical variable?

Question 32 of 50

In Excel, which function would you use to calculate the smallest value in a set of data?

Question 33 of 50

What does the term "vertical axis" refer to in a chart?

Question 34 of 50

When should you use "descriptive statistics"?

Question 35 of 50

What is the significance of using absolute references in Excel formulas?

Question 36 of 50

What would be the consequence of having duplicate data in a dataset?

Question 37 of 50

When presenting data, what is the primary benefit of using a bar chart?

Question 38 of 50

What is an important aspect of the frequency distribution table?

Question 39 of 50

In Excel, how would you find the average of a range of cells labeled A1 to A10?

Question 40 of 50

What is the purpose of a header in an Excel worksheet?

Question 41 of 50

What type of reference is used in the formula =A$1?

Question 42 of 50

Which function would you use to calculate a value after adding a 10% tax to an amount in cell A1?

Question 43 of 50

Which type of chart is best used to show data changes over time?

Question 44 of 50

What does the acronym PEMDAS stand for in the context of Excel formulas?

Question 45 of 50

What is the main advantage of using a worksheet in Excel?

Question 46 of 50

Which Excel function would you use to count the total number of non-blank cells in a range?

Question 47 of 50

What is the purpose of using "cloud storage" for Excel files?

Question 48 of 50

Which Excel feature allows you to separate text into individual columns?

Question 49 of 50

If a dataset contains a large amount of qualitative data, which analysis method is most appropriate?

Question 50 of 50

In Excel, what result does the formula =COUNTIF(B2:B10,">50") return?

Set 1 complete

You scored 0%

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

Next: Set 2

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