WGU D388 Objective Assessment (OA) | Fundamentals of
Spreadsheets and Data Presentations | Questions and Correct
Answers with Rationale | Latest Update 2026/27 | Rated A+
SECTION A: EXCEL FUNDAMENTALS & NAVIGATION
Question 1
What is the term for a collection of cells arranged in columns and rows within a spreadsheet program?
• □
A. File
• □
B. Menu tab
• ☑
C. Worksheet
• □
D. Workbook
Correct Answer: C — Worksheet
Rationale: A worksheet is a single spreadsheet within a spreadsheet program that consists of cells
arranged in columns and rows . A workbook (D) is the file that contains one or more worksheets. A file
(A) is the saved document. A menu tab (B) contains command groups.
Question 2
Which naming convention is used to identify cells in spreadsheets?
• □
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
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 3
What is the name of the bar at the top of the worksheet that displays the actual formula or value of
the selected cell?
• □
A. Name Box
• ☑
B. Formula Bar
• □
C. Status Bar
• □
D. Title Bar
Correct Answer: B — Formula Bar
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 Title Bar (D) displays the workbook name.
Question 4
What is the purpose of the "Name Box" located to the left of the Formula Bar?
• □
A. To display the result of the active cell's formula
• ☑
B. To show the reference of the active cell or named range
• □
, C. To enter new formulas
• □
D. To format cell contents
Correct Answer: B — To show the reference of the active cell or named range
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 5
Which symbol must be entered at the beginning of a cell to signify a formula?
• □
A. + (plus sign)
• □
B. @ (at symbol)
• ☑
C. = (equals sign)
• □
D. # (hash symbol)
Correct Answer: C — = (equals sign)
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 by Excel, the equals sign is the
standard and proper way to begin a formula.
Question 6
If text appears as "#######" in a cell, what is the issue?
• ☑
A. The column is not wide enough to display the content
• □
B. The cell contains an error in the formula
• □
Spreadsheets and Data Presentations | Questions and Correct
Answers with Rationale | Latest Update 2026/27 | Rated A+
SECTION A: EXCEL FUNDAMENTALS & NAVIGATION
Question 1
What is the term for a collection of cells arranged in columns and rows within a spreadsheet program?
• □
A. File
• □
B. Menu tab
• ☑
C. Worksheet
• □
D. Workbook
Correct Answer: C — Worksheet
Rationale: A worksheet is a single spreadsheet within a spreadsheet program that consists of cells
arranged in columns and rows . A workbook (D) is the file that contains one or more worksheets. A file
(A) is the saved document. A menu tab (B) contains command groups.
Question 2
Which naming convention is used to identify cells in spreadsheets?
• □
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
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 3
What is the name of the bar at the top of the worksheet that displays the actual formula or value of
the selected cell?
• □
A. Name Box
• ☑
B. Formula Bar
• □
C. Status Bar
• □
D. Title Bar
Correct Answer: B — Formula Bar
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 Title Bar (D) displays the workbook name.
Question 4
What is the purpose of the "Name Box" located to the left of the Formula Bar?
• □
A. To display the result of the active cell's formula
• ☑
B. To show the reference of the active cell or named range
• □
, C. To enter new formulas
• □
D. To format cell contents
Correct Answer: B — To show the reference of the active cell or named range
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 5
Which symbol must be entered at the beginning of a cell to signify a formula?
• □
A. + (plus sign)
• □
B. @ (at symbol)
• ☑
C. = (equals sign)
• □
D. # (hash symbol)
Correct Answer: C — = (equals sign)
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 by Excel, the equals sign is the
standard and proper way to begin a formula.
Question 6
If text appears as "#######" in a cell, what is the issue?
• ☑
A. The column is not wide enough to display the content
• □
B. The cell contains an error in the formula
• □
