WGU C268 Spreadsheets | Objective Assessment Practice Questions with Verified Answers (2026/2027 Edition)

WGU C268 Spreadsheets | Objective Assessment
Practice Questions with Verified Answers (2026/2027
Edition)

SECTION 1: Excel Fundamentals and Navigation

1. A business analyst needs to quickly access the Save, Undo, and Redo commands
regardless of which Ribbon tab is currently active. Which Excel feature should be
customized to ensure these commands are always visible?

A. The Ribbon tabs
B. The Quick Access Toolbar
C. The Status Bar
D. The Formula Bar

Correct Answer: B. The Quick Access Toolbar
Rationale: The Quick Access Toolbar sits above the Ribbon and remains visible across
all tabs, providing persistent one-click access to frequently used commands. The
Ribbon tabs (A) change based on context and are not always visible for all commands.
The Status Bar (C) displays information at the bottom of the window. The Formula Bar
(D) shows cell contents and formulas.

2. Which keyboard shortcut opens the Format Cells dialog box?

A. Ctrl + 1
B. Ctrl + Shift + F
C. F4
D. Alt + E, S

Correct Answer: A. Ctrl + 1

,Rationale: Ctrl + 1 is the standard Excel shortcut to open the Format Cells dialog. Ctrl +
Shift + F (B) opens Format Cells with the Font tab selected in some versions but is not
the primary universal shortcut. F4 (C) repeats the last action or toggles reference types.
Alt + E, S (D) opens the Paste Special dialog in older Excel versions.

3. When entering a number into a cell, Excel automatically aligns it to the right side of
the cell by default. This default behavior occurs because:

A. Numbers are treated as values and text is treated as labels
B. The cell is pre-formatted as Currency
C. Excel applies right-alignment to all data types by default
D. The worksheet is using the Accounting format by default

Correct Answer: A. Numbers are treated as values and text is treated as labels
Rationale: Excel's default alignment distinguishes values (right-aligned) from labels/text
(left-aligned), a convention inherited from early spreadsheet design to improve
readability. It is not due to pre-formatting as Currency (B) or Accounting (D), and not all
data types are right-aligned (C).

4. A manager wants to ensure that employee ID numbers starting with zeros (e.g.,
001245) are displayed correctly and not converted to numeric values. Which approach
should be used before entering the data?

A. Apply the General format to the cells
B. Precede the entry with an apostrophe or format the cells as Text
C. Use the TRIM function to remove leading zeros
D. Increase the column width

Correct Answer: B. Precede the entry with an apostrophe or format the cells as Text
Rationale: Excel strips leading zeros from numeric entries under the General format.
Preceding the entry with an apostrophe forces text treatment, as does applying the Text
format beforehand. The General format (A) will drop zeros. TRIM (C) removes spaces,
not zeros. Column width (D) affects display but not conversion.

,5. Which of the following is the correct sequence of Excel's mathematical order of
operations?

A. Parentheses, Addition, Multiplication, Division, Exponents, Subtraction
B. Parentheses, Exponents, Multiplication and Division, Addition and Subtraction
C. Exponents, Parentheses, Multiplication, Division, Addition, Subtraction
D. Parentheses, Exponents, Addition, Subtraction, Multiplication, Division

Correct Answer: B. Parentheses, Exponents, Multiplication and Division, Addition and
Subtraction
Rationale: Excel follows standard PEMDAS/BODMAS rules: Parentheses first, then
Exponents, followed by Multiplication and Division from left to right, and finally Addition
and Subtraction from left to right. Options A, C, and D all misorder the sequence.

6. To quickly navigate to the last cell containing data in a worksheet, which keyboard
shortcut should be used?

A. Ctrl + Home
B. Ctrl + End
C. Ctrl + Page Down
D. Ctrl + Arrow Key

Correct Answer: B. Ctrl + End
Rationale: Ctrl + End jumps to the intersection of the last used row and last used
column. Ctrl + Home (A) navigates to cell A1. Ctrl + Page Down (C) moves to the next
worksheet. Ctrl + Arrow Key (D) jumps to the edge of the current data region.

7. A user needs to fill a series of cells with the months of the year (January, February,
March, etc.) by typing only "January" and then dragging the fill handle. This behavior is
possible because Excel uses:

A. Custom lists
B. AutoComplete
C. Flash Fill

, D. Data Validation

Correct Answer: A. Custom lists
Rationale: Excel includes built-in custom lists for months, days, and other sequences
that auto-fill when the fill handle is dragged. AutoComplete (B) suggests existing entries
in a column. Flash Fill (C) extracts patterns from examples. Data Validation (D) restricts
input but does not generate series.



SECTION 2: Basic Functions and Formulas

8. A sales report contains values in cells B2:B21. Which formula correctly calculates the
arithmetic mean of these values?

A. =SUM(B2:B21)/20
B. =AVERAGE(B2:B21)
C. =MEAN(B2:B21)
D. =TOTAL(B2:B21)/COUNT(B2:B21)

Correct Answer: B. =AVERAGE(B2:B21)
Rationale: AVERAGE is the built-in Excel function for calculating the arithmetic mean.
While option A is mathematically equivalent, it is not the direct function and would fail if
the range size changed. MEAN (C) is not a standard Excel function. TOTAL (D) is not a
valid Excel function.

9. A dataset in A1:A50 contains numbers and text entries. Which formula counts only
the cells that contain numeric values?

A. =COUNTA(A1:A50)
B. =COUNT(A1:A50)
C. =SUM(A1:A50)
D. =COUNTIF(A1:A50,">0")

Correct Answer: B. =COUNT(A1:A50)