WGU · C268 · SPREADSHEETS E DITION
PRA C TIC E E X A M IN ATIO N · C O M PRE H E N SIV E
C268 Practice
Exam Questions
& Answers
A 100-Question Comprehensive Assessment Aligned with the
Western Governors University C268 Spreadsheets Course
Syllabus, Microsoft Office Specialist (MOS) Excel Certification
Standards, and 2026/2027 Data Analysis Curriculum
Guidelines.
EX A MI N AT I O N CO V ER A G E
Ten sections spanning Excel fundamentals and interface navigation; data entry and formatting;
basic and advanced formulas; cell referencing and named ranges; PivotTables and data
analysis tools; charts and visualization; What-If Analysis; financial and statistical functions; and
macros, automation, and advanced features. Each question includes a fully annotated rationale
referencing WGU C268 curriculum outcomes and MOS Excel methodology.
T O TAL Q UES T I O N S S ECT IO N S CO GN I T I VE MI X
100 MCQs 10 Modules / 25
P R E PA R E D F O R H I G H E R E D U C A T I O N & C I S C O U R S E W O R K EDITION
,C268 Practice Exam Questions and Answers · Edition WGU · Spreadsheets
C268 Practice Exam Questions and Answers
WGU Spreadsheets Course · Edition · 100-Question Comprehensive Assessment
Section 1: Excel Fundamentals & Interface
Questions 1–10
Navigation
Q1: A WGU C268 student opens Excel and notices the ribbon is hidden except for the tab names. To
restore the full ribbon so all command groups are visible while working on a budget worksheet, which
action should the student take?
A. Press Ctrl+F1 to collapse the ribbon further, then press Esc to lock it.
B. Double-click any ribbon tab name (e.g., Home) to toggle Show Tabs vs. Show Tabs and Commands, or use the
pin icon at the bottom-right of the ribbon.
C. Press Ctrl+F1 to toggle the ribbon display between collapsed and expanded states, then click the pin
icon to keep it open. [CORRECT]
D. Go to File > Options > General and disable the 'Auto-hide Ribbon' setting, then restart Excel.
Correct Answer: C — Press Ctrl+F1 to toggle the ribbon display between collapsed and
expanded states, then cli…
Rationale
Ctrl+F1 is the standard keyboard shortcut that toggles the ribbon between collapsed (Show Tabs only) and expanded
(Show Tabs and Commands) views; clicking the pin icon keeps it persistent. Option A is incorrect because Ctrl+F1 does not
collapse the ribbon further-it toggles its display. Option B describes a valid mouse action but mixes two separate behaviors;
double-clicking a tab toggles, while the pin icon locks the state-they are not the same action. Option D is unnecessary
because the ribbon state can be controlled directly from the view without restarting Excel, which violates the WGU C268
emphasis on efficient interface navigation.
Q2: An accounting analyst wants to add the 'Subtotal' command to the Quick Access Toolbar (QAT) so it
is always available regardless of which ribbon tab is active. What is the correct procedure?
A. Right-click the Subtotal button on the Data tab and select 'Add to Quick Access Toolbar' from the
context menu. [CORRECT]
B. Drag the Subtotal button from the Data tab directly onto the QAT using the mouse.
C. Press Alt+Q to open the Search box, type 'Subtotal', and select 'Pin to Quick Access Toolbar'.
D. Open File > Options > Quick Access Toolbar, then manually add it from the Choose Commands From list.
Correct Answer: A — Right-click the Subtotal button on the Data tab and select 'Add to Quick
Access Toolbar' f…
Rationale
Right-clicking any ribbon command and choosing 'Add to Quick Access Toolbar' is the fastest, most direct method and is
the WGU C268 recommended workflow for QAT customization. Option D is technically correct as a fallback method but
is slower and not the recommended first choice. Option B does not work because ribbon commands cannot be dragged to
the QAT. Option C is invalid because Alt+Q opens Tell Me / Search, but Search results do not offer a 'Pin to QAT' option.
Q3: A student is reviewing a worksheet and clicks cell C12. The formula bar displays '=SUM(C4:C11)'
but the cell shows the value '4520.75'. Which statement best describes the relationship between the
Comprehensive 100-Question Practice Examination Page 2
,C268 Practice Exam Questions and Answers · Edition WGU · Spreadsheets
formula bar and the cell display?
A. The formula bar shows the underlying formula while the cell shows the calculated result; this is normal
Excel behavior and indicates the cell contains a formula, not a static value. [CORRECT]
B. The formula bar and the cell display should always match; the discrepancy indicates a corrupted workbook that
must be repaired.
C. The formula bar shows the most recently entered value and the cell shows the formatted result; pressing F9 will
sync them.
D. The formula bar displays formulas only when 'Show Formulas' mode (Ctrl+`) is active; otherwise it shows
values.
Correct Answer: A — The formula bar shows the underlying formula while the cell shows the
calculated result; t…
Rationale
By design, Excel's formula bar displays the underlying formula or raw data of the active cell, while the cell itself shows
the calculated, formatted result. This dual-view is a foundational concept in the WGU C268 curriculum. Option B is
incorrect because the difference is expected behavior, not corruption. Option C misrepresents the formula bar's purpose.
Option D confuses the formula bar with the 'Show Formulas' toggle (Ctrl+`), which switches the cell display itself between
values and formulas across the entire worksheet.
Q4: While reviewing a large dataset, an analyst sees 'Average: 247.5' and 'Count: 18' displayed at the
bottom of the Excel window after selecting a range of numeric cells. Which interface element is displaying
this information?
A. The Formula Bar, which automatically calculates and displays summary statistics for selected ranges.
B. The Status Bar, which can be customized to show Average, Count, Numerical Count, Minimum,
Maximum, and Sum for the selected range. [CORRECT]
C. The Backstage View, accessible via the File tab, which provides live calculation summaries.
D. The Quick Access Toolbar, which displays quick statistics when range selections are active.
Correct Answer: B — The Status Bar, which can be customized to show Average, Count,
Numerical Count, Minimum, …
Rationale
The Status Bar, located at the bottom of the Excel window, displays contextual information including automatic
aggregations (Average, Count, Sum, Min, Max) for the selected range. Users can right-click the Status Bar to customize
which statistics appear. This is a key productivity feature emphasized in WGU C268. Option A is incorrect because the
Formula Bar shows the active cell's content, not range summaries. Options C and D incorrectly attribute the feature to the
Backstage View and QAT respectively.
Q5: A user needs to access commands for printing, saving, exporting, and managing workbook options in
one centralized location. Which interface area should they use?
A. The Home tab on the ribbon, which contains all file-related commands in the File group.
B. The Backstage View, accessed by clicking the File tab, which centralizes file management, printing,
exporting, account settings, and Excel Options. [CORRECT]
C. The Quick Access Toolbar, which by default includes Print, Save, and Export commands.
D. The View tab on the ribbon, which contains the Workbook Views group for file operations.
Correct Answer: B — The Backstage View, accessed by clicking the File tab, which centralizes
file management, …
Rationale
Comprehensive 100-Question Practice Examination Page 3
, C268 Practice Exam Questions and Answers · Edition WGU · Spreadsheets
The Backstage View, opened via the green File tab, consolidates all document-level operations including Save, Save As,
Print, Export, Share, Account, and Options. This is a foundational concept in WGU C268's interface navigation module.
Option A is incorrect because the Home tab contains cell-formatting commands, not file operations. Option C is incorrect
because the default QAT includes only Save, Undo, and Redo. Option D is incorrect because the View tab controls
worksheet display options, not file management.
Q6: A colleague asks, 'What is the difference between a workbook and a worksheet in Excel?' Which
response is most accurate according to the C268 curriculum?
A. A workbook is a single sheet of cells; a worksheet is the entire file containing multiple sheets.
B. A workbook is the entire Excel file (.xlsx) that can contain multiple worksheets; a worksheet is a single
tabbed page of cells within that workbook. [CORRECT]
C. A workbook is a saved file; a worksheet is an unsaved temporary calculation area that disappears when closed.
D. A workbook contains only charts and graphs; a worksheet contains only numeric data.
Correct Answer: B — A workbook is the entire Excel file (.xlsx) that can contain multiple
worksheets; a worksh…
Rationale
A workbook is the complete Excel file (e.g., Budget.xlsx) and acts as a container for one or more worksheets, each of
which is a tabbed grid of cells. This distinction is fundamental in the WGU C268 syllabus and MOS Excel certification.
Option A reverses the relationship. Option C incorrectly implies worksheets are temporary. Option D misrepresents both
terms entirely.
Q7: A user types 'Q2_Sales' into the Name Box (located to the left of the formula bar) and presses Enter.
What is the most likely result?
A. Excel creates a named range 'Q2_Sales' that refers to the currently selected cell or range, allowing it to
be referenced by name in formulas. [CORRECT]
B. Excel renames the active worksheet tab to 'Q2_Sales'.
C. Excel opens the Find and Replace dialog with 'Q2_Sales' as the search term.
D. Excel saves the current workbook as 'Q2_Sales.xlsx'.
Correct Answer: A — Excel creates a named range 'Q2_Sales' that refers to the currently
selected cell or range…
Rationale
Typing a valid name into the Name Box creates a named range referencing the current selection, which is a core technique
taught in WGU C268 for improving formula readability and maintainability. Option B is incorrect because worksheet tabs
are renamed by double-clicking the tab itself. Option C is incorrect because Find and Replace is opened with Ctrl+F.
Option D is incorrect because saving uses Ctrl+S or File > Save As.
Q8: An analyst forgets which ribbon tab contains the 'PivotTable' command. What is the most efficient
way to locate and execute it without manually scanning each tab?
A. Press Alt+P to open the PivotTable shortcut menu directly.
B. Use the Search box (Tell Me) by typing 'PivotTable' in the search field at the top of the ribbon, then
select the desired command from the results. [CORRECT]
C. Press Ctrl+P to open the PivotTable dialog.
D. Right-click any ribbon tab and choose 'Find PivotTable' from the context menu.
Correct Answer: B — Use the Search box (Tell Me) by typing 'PivotTable' in the search field at
the top of the …
Comprehensive 100-Question Practice Examination Page 4
PRA C TIC E E X A M IN ATIO N · C O M PRE H E N SIV E
C268 Practice
Exam Questions
& Answers
A 100-Question Comprehensive Assessment Aligned with the
Western Governors University C268 Spreadsheets Course
Syllabus, Microsoft Office Specialist (MOS) Excel Certification
Standards, and 2026/2027 Data Analysis Curriculum
Guidelines.
EX A MI N AT I O N CO V ER A G E
Ten sections spanning Excel fundamentals and interface navigation; data entry and formatting;
basic and advanced formulas; cell referencing and named ranges; PivotTables and data
analysis tools; charts and visualization; What-If Analysis; financial and statistical functions; and
macros, automation, and advanced features. Each question includes a fully annotated rationale
referencing WGU C268 curriculum outcomes and MOS Excel methodology.
T O TAL Q UES T I O N S S ECT IO N S CO GN I T I VE MI X
100 MCQs 10 Modules / 25
P R E PA R E D F O R H I G H E R E D U C A T I O N & C I S C O U R S E W O R K EDITION
,C268 Practice Exam Questions and Answers · Edition WGU · Spreadsheets
C268 Practice Exam Questions and Answers
WGU Spreadsheets Course · Edition · 100-Question Comprehensive Assessment
Section 1: Excel Fundamentals & Interface
Questions 1–10
Navigation
Q1: A WGU C268 student opens Excel and notices the ribbon is hidden except for the tab names. To
restore the full ribbon so all command groups are visible while working on a budget worksheet, which
action should the student take?
A. Press Ctrl+F1 to collapse the ribbon further, then press Esc to lock it.
B. Double-click any ribbon tab name (e.g., Home) to toggle Show Tabs vs. Show Tabs and Commands, or use the
pin icon at the bottom-right of the ribbon.
C. Press Ctrl+F1 to toggle the ribbon display between collapsed and expanded states, then click the pin
icon to keep it open. [CORRECT]
D. Go to File > Options > General and disable the 'Auto-hide Ribbon' setting, then restart Excel.
Correct Answer: C — Press Ctrl+F1 to toggle the ribbon display between collapsed and
expanded states, then cli…
Rationale
Ctrl+F1 is the standard keyboard shortcut that toggles the ribbon between collapsed (Show Tabs only) and expanded
(Show Tabs and Commands) views; clicking the pin icon keeps it persistent. Option A is incorrect because Ctrl+F1 does not
collapse the ribbon further-it toggles its display. Option B describes a valid mouse action but mixes two separate behaviors;
double-clicking a tab toggles, while the pin icon locks the state-they are not the same action. Option D is unnecessary
because the ribbon state can be controlled directly from the view without restarting Excel, which violates the WGU C268
emphasis on efficient interface navigation.
Q2: An accounting analyst wants to add the 'Subtotal' command to the Quick Access Toolbar (QAT) so it
is always available regardless of which ribbon tab is active. What is the correct procedure?
A. Right-click the Subtotal button on the Data tab and select 'Add to Quick Access Toolbar' from the
context menu. [CORRECT]
B. Drag the Subtotal button from the Data tab directly onto the QAT using the mouse.
C. Press Alt+Q to open the Search box, type 'Subtotal', and select 'Pin to Quick Access Toolbar'.
D. Open File > Options > Quick Access Toolbar, then manually add it from the Choose Commands From list.
Correct Answer: A — Right-click the Subtotal button on the Data tab and select 'Add to Quick
Access Toolbar' f…
Rationale
Right-clicking any ribbon command and choosing 'Add to Quick Access Toolbar' is the fastest, most direct method and is
the WGU C268 recommended workflow for QAT customization. Option D is technically correct as a fallback method but
is slower and not the recommended first choice. Option B does not work because ribbon commands cannot be dragged to
the QAT. Option C is invalid because Alt+Q opens Tell Me / Search, but Search results do not offer a 'Pin to QAT' option.
Q3: A student is reviewing a worksheet and clicks cell C12. The formula bar displays '=SUM(C4:C11)'
but the cell shows the value '4520.75'. Which statement best describes the relationship between the
Comprehensive 100-Question Practice Examination Page 2
,C268 Practice Exam Questions and Answers · Edition WGU · Spreadsheets
formula bar and the cell display?
A. The formula bar shows the underlying formula while the cell shows the calculated result; this is normal
Excel behavior and indicates the cell contains a formula, not a static value. [CORRECT]
B. The formula bar and the cell display should always match; the discrepancy indicates a corrupted workbook that
must be repaired.
C. The formula bar shows the most recently entered value and the cell shows the formatted result; pressing F9 will
sync them.
D. The formula bar displays formulas only when 'Show Formulas' mode (Ctrl+`) is active; otherwise it shows
values.
Correct Answer: A — The formula bar shows the underlying formula while the cell shows the
calculated result; t…
Rationale
By design, Excel's formula bar displays the underlying formula or raw data of the active cell, while the cell itself shows
the calculated, formatted result. This dual-view is a foundational concept in the WGU C268 curriculum. Option B is
incorrect because the difference is expected behavior, not corruption. Option C misrepresents the formula bar's purpose.
Option D confuses the formula bar with the 'Show Formulas' toggle (Ctrl+`), which switches the cell display itself between
values and formulas across the entire worksheet.
Q4: While reviewing a large dataset, an analyst sees 'Average: 247.5' and 'Count: 18' displayed at the
bottom of the Excel window after selecting a range of numeric cells. Which interface element is displaying
this information?
A. The Formula Bar, which automatically calculates and displays summary statistics for selected ranges.
B. The Status Bar, which can be customized to show Average, Count, Numerical Count, Minimum,
Maximum, and Sum for the selected range. [CORRECT]
C. The Backstage View, accessible via the File tab, which provides live calculation summaries.
D. The Quick Access Toolbar, which displays quick statistics when range selections are active.
Correct Answer: B — The Status Bar, which can be customized to show Average, Count,
Numerical Count, Minimum, …
Rationale
The Status Bar, located at the bottom of the Excel window, displays contextual information including automatic
aggregations (Average, Count, Sum, Min, Max) for the selected range. Users can right-click the Status Bar to customize
which statistics appear. This is a key productivity feature emphasized in WGU C268. Option A is incorrect because the
Formula Bar shows the active cell's content, not range summaries. Options C and D incorrectly attribute the feature to the
Backstage View and QAT respectively.
Q5: A user needs to access commands for printing, saving, exporting, and managing workbook options in
one centralized location. Which interface area should they use?
A. The Home tab on the ribbon, which contains all file-related commands in the File group.
B. The Backstage View, accessed by clicking the File tab, which centralizes file management, printing,
exporting, account settings, and Excel Options. [CORRECT]
C. The Quick Access Toolbar, which by default includes Print, Save, and Export commands.
D. The View tab on the ribbon, which contains the Workbook Views group for file operations.
Correct Answer: B — The Backstage View, accessed by clicking the File tab, which centralizes
file management, …
Rationale
Comprehensive 100-Question Practice Examination Page 3
, C268 Practice Exam Questions and Answers · Edition WGU · Spreadsheets
The Backstage View, opened via the green File tab, consolidates all document-level operations including Save, Save As,
Print, Export, Share, Account, and Options. This is a foundational concept in WGU C268's interface navigation module.
Option A is incorrect because the Home tab contains cell-formatting commands, not file operations. Option C is incorrect
because the default QAT includes only Save, Undo, and Redo. Option D is incorrect because the View tab controls
worksheet display options, not file management.
Q6: A colleague asks, 'What is the difference between a workbook and a worksheet in Excel?' Which
response is most accurate according to the C268 curriculum?
A. A workbook is a single sheet of cells; a worksheet is the entire file containing multiple sheets.
B. A workbook is the entire Excel file (.xlsx) that can contain multiple worksheets; a worksheet is a single
tabbed page of cells within that workbook. [CORRECT]
C. A workbook is a saved file; a worksheet is an unsaved temporary calculation area that disappears when closed.
D. A workbook contains only charts and graphs; a worksheet contains only numeric data.
Correct Answer: B — A workbook is the entire Excel file (.xlsx) that can contain multiple
worksheets; a worksh…
Rationale
A workbook is the complete Excel file (e.g., Budget.xlsx) and acts as a container for one or more worksheets, each of
which is a tabbed grid of cells. This distinction is fundamental in the WGU C268 syllabus and MOS Excel certification.
Option A reverses the relationship. Option C incorrectly implies worksheets are temporary. Option D misrepresents both
terms entirely.
Q7: A user types 'Q2_Sales' into the Name Box (located to the left of the formula bar) and presses Enter.
What is the most likely result?
A. Excel creates a named range 'Q2_Sales' that refers to the currently selected cell or range, allowing it to
be referenced by name in formulas. [CORRECT]
B. Excel renames the active worksheet tab to 'Q2_Sales'.
C. Excel opens the Find and Replace dialog with 'Q2_Sales' as the search term.
D. Excel saves the current workbook as 'Q2_Sales.xlsx'.
Correct Answer: A — Excel creates a named range 'Q2_Sales' that refers to the currently
selected cell or range…
Rationale
Typing a valid name into the Name Box creates a named range referencing the current selection, which is a core technique
taught in WGU C268 for improving formula readability and maintainability. Option B is incorrect because worksheet tabs
are renamed by double-clicking the tab itself. Option C is incorrect because Find and Replace is opened with Ctrl+F.
Option D is incorrect because saving uses Ctrl+S or File > Save As.
Q8: An analyst forgets which ribbon tab contains the 'PivotTable' command. What is the most efficient
way to locate and execute it without manually scanning each tab?
A. Press Alt+P to open the PivotTable shortcut menu directly.
B. Use the Search box (Tell Me) by typing 'PivotTable' in the search field at the top of the ribbon, then
select the desired command from the results. [CORRECT]
C. Press Ctrl+P to open the PivotTable dialog.
D. Right-click any ribbon tab and choose 'Find PivotTable' from the context menu.
Correct Answer: B — Use the Search box (Tell Me) by typing 'PivotTable' in the search field at
the top of the …
Comprehensive 100-Question Practice Examination Page 4
