WGU C268 SPREADSHEETS |
OBJECTIVE ASSESSMENT PRACTICE QUESTIONS
COMPLETE 250 QUESTIONS WITH VERIFIED ANSWERS
& RATIONALES2026/2027 EDITION |
EXPERT VERIFIED FOR GUARANTEED PASS
This comprehensive test bank contains 250 expert-verified practice questions with short
rationales, specifically designed for the WGU C268 Spreadsheets Objective Assessment. It
covers all key content areas including Excel fundamentals, formulas and functions, data
analysis, charts and visualizations, financial functions, logical functions, lookup functions, pivot
tables, and advanced spreadsheet techniques. All questions reflect currently tested concepts
based on the latest WGU C268 course objectives. Each question includes the verified correct
answer and a concise rationale to reinforce understanding of critical spreadsheet concepts
essential for exam success.
SECTION 1: EXCEL FUNDAMENTALS AND NAVIGATION (Questions 1-50)
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.
8. What is the keyboard shortcut to insert a new worksheet?
A. Ctrl + N
B. Shift + F11
C. Ctrl + Shift + N
D. Alt + I, W
Correct Answer: B. Shift + F11
Rationale: Shift + F11 inserts a new worksheet in Excel. Ctrl + N (A) creates a new
workbook. Ctrl + Shift + N (C) is not a standard Excel shortcut. Alt + I, W (D) is a menu
navigation shortcut but not as direct as Shift + F11.
, 9. To quickly select all cells in a worksheet, which keyboard shortcut should be used?
A. Ctrl + A
B. Ctrl + Shift + A
C. Ctrl + Spacebar
D. Shift + Spacebar
Correct Answer: A. Ctrl + A
Rationale: Ctrl + A selects the entire worksheet. Ctrl + Spacebar (C) selects the current
column. Shift + Spacebar (D) selects the current row. Ctrl + Shift + A (B) is not a valid
Excel shortcut.
10. Which Excel feature allows a user to view two different parts of the same worksheet
simultaneously?
A. Freeze Panes
B. Split
C. New Window
D. Zoom
Correct Answer: B. Split
Rationale: The Split feature divides the worksheet into panes that scroll independently,
allowing simultaneous viewing of different areas. Freeze Panes (A) locks rows or columns
but does not create independent panes. New Window (C) opens a duplicate window.
Zoom (D) changes magnification only.
11. To quickly move to cell A1 in a worksheet, which keyboard shortcut should be used?
A. Ctrl + Home
B. Ctrl + End
C. Home
D. Ctrl + Page Up
Correct Answer: A. Ctrl + Home
Rationale: Ctrl + Home navigates to cell A1. Ctrl + End (B) goes to the last used cell.
Home (C) moves to the beginning of the row. Ctrl + Page Up (D) moves to the previous
worksheet.
12. Which of the following is NOT a valid way to enter data into a cell in Excel?
A. Typing directly into the cell
B. Typing in the Formula Bar
C. Copying and pasting from another cell
D. Clicking the Insert Tab and selecting Insert Cells
Correct Answer: D. Clicking the Insert Tab and selecting Insert Cells
OBJECTIVE ASSESSMENT PRACTICE QUESTIONS
COMPLETE 250 QUESTIONS WITH VERIFIED ANSWERS
& RATIONALES2026/2027 EDITION |
EXPERT VERIFIED FOR GUARANTEED PASS
This comprehensive test bank contains 250 expert-verified practice questions with short
rationales, specifically designed for the WGU C268 Spreadsheets Objective Assessment. It
covers all key content areas including Excel fundamentals, formulas and functions, data
analysis, charts and visualizations, financial functions, logical functions, lookup functions, pivot
tables, and advanced spreadsheet techniques. All questions reflect currently tested concepts
based on the latest WGU C268 course objectives. Each question includes the verified correct
answer and a concise rationale to reinforce understanding of critical spreadsheet concepts
essential for exam success.
SECTION 1: EXCEL FUNDAMENTALS AND NAVIGATION (Questions 1-50)
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.
8. What is the keyboard shortcut to insert a new worksheet?
A. Ctrl + N
B. Shift + F11
C. Ctrl + Shift + N
D. Alt + I, W
Correct Answer: B. Shift + F11
Rationale: Shift + F11 inserts a new worksheet in Excel. Ctrl + N (A) creates a new
workbook. Ctrl + Shift + N (C) is not a standard Excel shortcut. Alt + I, W (D) is a menu
navigation shortcut but not as direct as Shift + F11.
, 9. To quickly select all cells in a worksheet, which keyboard shortcut should be used?
A. Ctrl + A
B. Ctrl + Shift + A
C. Ctrl + Spacebar
D. Shift + Spacebar
Correct Answer: A. Ctrl + A
Rationale: Ctrl + A selects the entire worksheet. Ctrl + Spacebar (C) selects the current
column. Shift + Spacebar (D) selects the current row. Ctrl + Shift + A (B) is not a valid
Excel shortcut.
10. Which Excel feature allows a user to view two different parts of the same worksheet
simultaneously?
A. Freeze Panes
B. Split
C. New Window
D. Zoom
Correct Answer: B. Split
Rationale: The Split feature divides the worksheet into panes that scroll independently,
allowing simultaneous viewing of different areas. Freeze Panes (A) locks rows or columns
but does not create independent panes. New Window (C) opens a duplicate window.
Zoom (D) changes magnification only.
11. To quickly move to cell A1 in a worksheet, which keyboard shortcut should be used?
A. Ctrl + Home
B. Ctrl + End
C. Home
D. Ctrl + Page Up
Correct Answer: A. Ctrl + Home
Rationale: Ctrl + Home navigates to cell A1. Ctrl + End (B) goes to the last used cell.
Home (C) moves to the beginning of the row. Ctrl + Page Up (D) moves to the previous
worksheet.
12. Which of the following is NOT a valid way to enter data into a cell in Excel?
A. Typing directly into the cell
B. Typing in the Formula Bar
C. Copying and pasting from another cell
D. Clicking the Insert Tab and selecting Insert Cells
Correct Answer: D. Clicking the Insert Tab and selecting Insert Cells
