WGU D388 (PA) | Fundamentals of Spreadsheets and Data Presentations | Questions and Correct Answers with Rationale | Latest Update 2026/27 | Rated A+

WGU D388 (PA) | Fundamentals of Spreadsheets and Data
Presentations | Questions and Correct Answers with Rationale |
Latest Update 2026/27 | Rated A+



SECTION A: SPREADSHEET FUNDAMENTALS (15 Questions)


Question 1
What is the name of the file that contains one or more worksheets in Excel?
• □
A. Spreadsheet

• ☑
B. Workbook
• □
C. Worksheet
• □
D. Database
Correct Answer: B — Workbook
Expert Rationale: A workbook is the Excel file that contains one or more worksheets. Each
worksheet provides a separate grid for organizing data. By default, new workbooks contain one
worksheet, but users can add more. A worksheet (C) is a single page within the workbook. A
spreadsheet (A) is a general term for the grid-based program.


Question 2
Which symbol must precede all formulas entered in a cell?
• □
A. @

• ☑

,B. =
• □
C. +
• □
D. #
Correct Answer: B — =
Expert Rationale: The equals sign (=) tells Excel to calculate the expression that follows. Without
it, Excel treats the entry as plain text. While the plus sign (+) is sometimes accepted, the equals
sign is the standard and proper way to begin a formula.


Question 3
How are cells identified in Excel?
• □
A. Row letter and column number

• ☑
B. Column letter and row number
• □
C. Column number and row letter
• □
D. Row number and sheet name
Correct Answer: B — Column letter and row number
Expert Rationale: Cells are identified by their column letter followed by the row number (e.g.,
A1, B5, C10). Column letters are alphabetical (A through XFD) and row numbers are numerical.
The column letter is always listed first, followed by the row number.


Question 4
What is the name of the bar that displays the content of the active cell?
• □

,A. Name Box

• ☑
B. Formula Bar
• □
C. Status Bar
• □
D. Ribbon
Correct Answer: B — Formula Bar
Expert Rationale: The Formula Bar displays the content of the active cell, which may be a value
or a formula. The Name Box (A) shows the cell reference or named range. The Status Bar (C)
shows information about the current state of the worksheet. The Ribbon (D) contains tabs and
commands.


Question 5
If a cell displays "#######", what should be done to fix it?
• □
A. Re-enter the formula

• ☑
B. Widen the column
• □
C. Change the font
• □
D. Insert a new row
Correct Answer: B — Widen the column
Expert Rationale: When a cell displays "#######", it indicates the column width is too narrow to
display the content fully. This is particularly common with dates or long numbers. To fix this,
widen the column by dragging the column border or double-clicking the column header
boundary.

, Question 6
What is the purpose of the Name Box?
• □
A. To enter formulas

• ☑
B. To display the reference of the active cell or named range
• □
C. To format cells
• □
D. To insert charts
Correct Answer: B — To display the reference of the active cell or named range
Expert Rationale: The Name Box shows the reference of the active cell (e.g., C4) or a named
range if you have assigned a name to a cell or range. You can also type a cell reference and press
Enter to navigate directly to that cell.


Question 7
Which of the following is a valid cell reference?
• □
A. 1A
• □
B. AB1

• ☑
C. A1
• □
D. A&B
Correct Answer: C — A1
Expert Rationale: Valid cell references consist of a column letter followed by a row number
(e.g., A1, B10, Z100). The column letter must be alphabetical and the row number must be