WGU D388 OA Practice Test 2026: Questions, Answers, Study Guide & Exam Tips

WGU D388 OA Practice Test 2026: Questions, Answers, Study Guide & Exam Tips

Preparing for the WGU D388 OA? This WGU D388 OA Practice Test 2026 guide is designed to help you review the spreadsheet concepts, Excel functions, formulas, data organization, formatting, charts, and data-presentation skills that can make or break your exam preparation.

D388: Fundamentals of Spreadsheets and Data Presentations is a 3-CU WGU course focused on using spreadsheet functions and tools to organize, calculate, analyze, and present data. WGU’s 2026 catalog specifically describes the course as an introduction to spreadsheet functions, spreadsheet-based data presentation, Microsoft Excel features, and real-world applications for collecting, organizing, and presenting data.

The YouTube resource associated with this topic is:

WGU D388 OA Practice Test – Questions, Answers & Study Tips

Important: The questions in this article are original study questions created for preparation. They are not copied from the WGU Objective Assessment and should not be treated as actual or leaked OA questions.

What Is WGU D388?

D388 Fundamentals of Spreadsheets and Data Presentations teaches practical spreadsheet skills that can be applied to business, academic, and workplace scenarios.

WGU lists D388 as a 3-CU course under BUS 2250.

Major skills to review include:

• Spreadsheet terminology
• Workbook and worksheet organization
• Rows, columns, and cells
• Cell references
• Relative, absolute, and mixed references
• Formulas and functions
• Basic mathematical calculations
• Logical functions
• Lookup functions
• Sorting and filtering
• Formatting
• Data validation
• Tables
• Charts and graphs
• Data presentation
• Basic data analysis
• Spreadsheet accuracy and organization

The goal isn’t simply to memorize Excel commands. You should understand why and when to use a particular spreadsheet feature.

WGU D388 OA Study Guide 2026

1. Understand Workbooks, Worksheets, Rows, Columns, and Cells

A spreadsheet workbook can contain multiple worksheets.

Important terminology:

For example:

A1 identifies the cell located at column A and row 1.

A range such as:

A1:A10

represents cells A1 through A10.

2. Cell References

Cell referencing is one of the most important concepts to understand.

Relative reference

Example:

A1

A relative reference changes when a formula is copied.

If:

=A1+B1

is copied one row down, it can become:

=A2+B2

Absolute reference

Example:

$A$1

The column and row are both locked.

If the formula is copied, the reference remains $A$1.

Mixed reference

Examples:

$A1

or

A$1

One component is locked while the other can change.

Quick memory trick

• A1 = nothing locked
• $A$1 = everything locked
• $A1 = column locked
• A$1 = row locked

3. Formulas and Operators

Most spreadsheet formulas begin with an equals sign.

Examples:

=A1+B1

=C5-D5

=B2*C2

=D10/E10

Common mathematical operators include:

Always pay attention to the order of operations.

For example:

=10+5*2

does not equal 30.

Multiplication is performed before addition, producing:

20

4. Essential Excel Functions for D388

You should be comfortable recognizing what common functions do.

SUM

Adds values.

=SUM(A1:A10)

AVERAGE

Calculates the arithmetic mean.

=AVERAGE(B2:B10)

MIN

Returns the smallest value.

=MIN(C2:C20)

MAX

Returns the largest value.

=MAX(C2:C20)

COUNT

Counts cells containing numerical values.

=COUNT(A1:A20)

COUNTA

Counts non-empty cells.

=COUNTA(A1:A20)

A common mistake is confusing COUNT and COUNTA.

5. IF Function

The IF function allows a spreadsheet to return one result when a condition is true and another result when it is false.

Example:

=IF(B2>=70,"Pass","Review")

The spreadsheet evaluates the condition:

Is B2 greater than or equal to 70?

If yes:

Pass

If no:

Review

When reviewing IF questions, identify three parts:

1. The condition
2. The result if TRUE
3. The result if FALSE

6. Lookup Functions

Lookup functions help retrieve information from a data table.

A traditional VLOOKUP searches for a value in the first column of a table and returns related information from another column.

For example, imagine a table containing:

A lookup can retrieve the department associated with an employee ID.

When studying lookup questions, understand:

• Lookup value
• Lookup table
• Return column
• Exact vs. approximate matching
• Proper range selection

Don’t simply memorize the syntax. Understand the purpose of the function.

7. Sorting and Filtering

Sorting changes the order in which data appears.

Examples:

• A to Z
• Z to A
• Smallest to largest
• Largest to smallest

Filtering temporarily displays only records that meet selected criteria.

For example, a sales spreadsheet containing 5,000 records could be filtered to show only:

Region = West

Filtering doesn’t necessarily delete the other records. It changes which records are displayed.

8. Spreadsheet Formatting

Formatting improves readability and helps users understand data.

Common formatting options include:

• Font changes
• Bold and italic text
• Borders
• Alignment
• Number formatting
• Currency
• Percentages
• Dates
• Decimal places
• Column width
• Row height
• Conditional formatting

Why formatting matters

A number such as:

0.25

could represent 25%.

Formatting the cell as a percentage makes that interpretation immediately clear.

9. Conditional Formatting

Conditional formatting changes the appearance of cells based on rules.

For example:

Highlight all sales below $500.

A conditional-formatting rule can automatically identify the values meeting that condition.

Common uses include:

• Highlighting high or low values
• Identifying duplicates
• Showing performance thresholds
• Creating visual data indicators
• Finding unusual values

10. Charts and Data Presentation

Charts help communicate patterns visually.

Common chart types include:

Example

If you want to show monthly revenue over a year, a line chart may make the trend easier to see.

If you want to compare revenue among five departments, a column chart may be more appropriate.

The key is to select a chart based on the message the data needs to communicate.

11. Data Tables and Organization

Good spreadsheet design makes information easier to analyze.

Best practices include:

• Use descriptive column headings.
• Keep data consistently formatted.
• Avoid unnecessary blank rows inside datasets.
• Keep one type of information in each column.
• Use consistent date formats.
• Avoid merging cells inside datasets when it interferes with sorting or filtering.
• Check formulas before presenting results.
• Keep source data organized.

A spreadsheet can contain correct formulas and still be difficult to use if the underlying data is poorly organized.

WGU D388 OA Practice Questions 2026

The following questions are original practice questions designed to reinforce common D388 concepts.

Question 1

Which spreadsheet component is identified by the intersection of a row and a column?

A. Workbook
B. Worksheet
C. Cell
D. Table

Answer: C. Cell

Explanation: A cell is the intersection of a row and a column.

Question 2

What happens to the reference A1 when a formula containing it is copied one row downward?

A. It becomes $A$1
B. It normally becomes A2
C. It becomes B1
D. It remains permanently unchanged

Answer: B. It normally becomes A2

Explanation: A1 is a relative reference, so its row adjusts when the formula is copied.

Question 3

Which reference keeps both the row and column fixed?

A. A1
B. A$1
C. $A1
D. $A$1

Answer: D. $A$1

Explanation: Dollar signs before both the column and row make the reference absolute.

Question 4

Which function calculates the average of a range?

A. SUM
B. COUNT
C. AVERAGE
D. MAX

Answer: C. AVERAGE

Explanation: AVERAGE() calculates the arithmetic mean of numerical values in the specified range.

Question 5

A manager wants to determine the highest monthly sales value in a dataset. Which function is most appropriate?

A. MIN
B. MAX
C. COUNT
D. AVERAGE

Answer: B. MAX

Explanation: MAX() returns the largest numerical value in a range.

Question 6

Which function counts cells containing numbers?

A. COUNT
B. COUNTA
C. SUM
D. MAX

Answer: A. COUNT

Explanation: COUNT() counts cells containing numerical values. COUNTA() counts non-empty cells more broadly.

Question 7

A spreadsheet formula is:

=IF(C2>=80,"High","Low")

If C2 contains 75, what is returned?

A. High
B. Low
C. 80
D. FALSE

Answer: B. Low

Explanation: 75 is not greater than or equal to 80, so the false-result argument, "Low", is returned.

Question 8

Which chart is generally most appropriate for showing a trend in monthly sales?

A. Line chart
B. Pie chart
C. Scatter chart
D. Doughnut chart

Answer: A. Line chart

Explanation: Line charts are especially useful for showing changes and trends over an ordered sequence such as time.

Question 9

What is the primary purpose of filtering a dataset?

A. Permanently delete records
B. Display records that meet selected criteria
C. Convert formulas to text
D. Lock all cells

Answer: B. Display records that meet selected criteria

Explanation: Filtering lets you focus on records matching specified criteria without necessarily deleting the other records.

Question 10

Which formula correctly adds cells B2 through B10?

A. =ADD(B2:B10)
B. =TOTAL(B2:B10)
C. =SUM(B2:B10)
D. =COUNT(B2:B10)

Answer: C. =SUM(B2:B10)

Explanation: SUM adds the numerical values contained in the specified range.

Question 11

Which reference locks the column but allows the row to change?

A. A1
B. $A1
C. A$1
D. $A$1

Answer: B. $A1

Explanation: $A1 locks column A while leaving the row relative.

Question 12

A business wants to compare the sales totals of several departments. Which chart would usually be a strong choice?

A. Column chart
B. Line chart
C. Scatter chart
D. Pie chart only

Answer: A. Column chart

Explanation: Column charts are effective for comparing values across discrete categories.

Question 13

What is the primary purpose of conditional formatting?

A. Automatically delete incorrect records
B. Change cell appearance based on rules
C. Convert formulas into values
D. Protect a workbook with a password

Answer: B. Change cell appearance based on rules

Explanation: Conditional formatting applies visual formatting when specified conditions are met.

Question 14

A spreadsheet contains employee IDs in one table and corresponding department information in another. Which type of function can help retrieve related information based on an ID?

A. Lookup function
B. SUM function
C. COUNT function
D. ROUND function

Answer: A. Lookup function

Explanation: Lookup functions are designed to find a matching value and retrieve related information.

Question 15

Which practice improves spreadsheet usability?

A. Using inconsistent date formats
B. Leaving column headings blank
C. Using descriptive headings
D. Combining unrelated data into one cell

Answer: C. Using descriptive headings

Explanation: Clear headings make datasets easier to understand, sort, filter, and analyze.