C268 Practice Exam Actual Exam 2026/2027: Complete
Exam-Style Questions with Detailed Rationales | 100% Verified |
Pass Guaranteed – A+ Graded
TABLE OF CONTENTS
Section 1 | Spreadsheet Fundamentals & Navigation | Q1 – Q10
Section 2 | Formulas, Functions & Calculations | Q11 – Q20
Section 3 | Data Analysis & What-If Tools | Q21 – Q30
Section 4 | Charts, Tables & Data Visualization | Q31 – Q40
Section 5 | Advanced Functions & Business Applications | Q41 – Q50
Instructions: Choose the single best answer. Pass: 80% in 90 minutes.
══════════════════════════════════════
SECTION 1: SPREADSHEET FUNDAMENTALS & NAVIGATION Q1 – Q10
══════════════════════════════════════
Question 1 of 50
A 29-year-old administrative assistant is setting up a new budget workbook. She needs
to quickly select all cells in the current worksheet to apply a uniform font. She tries
clicking individual column headers but finds this tedious. What keyboard shortcut
accomplishes this selection in one action?
A. Press Ctrl+A to select the entire worksheet ✓ CORRECT
B. Press Ctrl+Shift+End to select from A1 to the last used cell
C. Press Ctrl+Home to select all cells in the worksheet
D. Press Ctrl+Space to select all cells across the worksheet
Correct Answer: A
Rationale: Pressing Ctrl+A selects the entire worksheet instantly, allowing you to apply
formatting globally without tedious manual selection. Ctrl+Shift+End selects only from
the active cell to the last used cell, which is useful but does not capture the whole sheet.
,Mastering this shortcut saves considerable time when preparing large workbooks for
distribution.
Question 2 of 50
A 34-year-old inventory manager notices that when he enters "00123" into a cell, Excel
displays it as "123". He needs to preserve the leading zeros for product codes. What is
the most appropriate method to ensure the leading zeros remain visible?
A. Precede each entry with an apostrophe and then type the number
B. Format the cells as Text before entering the values ✓ CORRECT
C. Enter the values and then apply the Comma format
D. Increase the column width to accommodate the full number
Correct Answer: B
Rationale: Formatting the cells as Text before data entry forces Excel to treat the input
as a string, preserving leading zeros for product codes and IDs. Preceding a single entry
with an apostrophe works for one-off values but is impractical when entering or
importing hundreds of rows. Many inventory databases export codes with leading zeros,
so formatting entire columns as Text upfront prevents data corruption.
Question 3 of 50
A 42-year-old financial analyst is reviewing a workbook created by a colleague. She sees
a formula in cell B5 that reads "=Sheet2!D8". Her colleague explained this pulls data
from another worksheet. What does the exclamation point indicate in this formula
structure?
A. It converts the reference to an absolute reference
B. It separates the workbook name from the cell address
C. It separates the worksheet name from the cell address ✓ CORRECT
D. It indicates the formula contains an error condition
Correct Answer: C
, Rationale: The exclamation point in a formula separates the worksheet name from the
cell address, enabling cross-sheet references like "=Sheet2!D8". A common
misconception is that it indicates an absolute reference, but absolute references use
dollar signs rather than punctuation. Understanding cross-sheet syntax is essential
when consolidating data from multiple departmental worksheets.
Question 4 of 50
A 31-year-old project coordinator wants to print only the range A1:G25 from a large
worksheet rather than the entire sheet. She highlighted the range and expected the print
preview to reflect her selection, but it still shows all columns. What step did she likely
omit?
A. She forgot to save the workbook before printing
B. She neglected to set the page orientation to Landscape
C. She failed to adjust the scaling to Fit Sheet on One Page
D. She did not formally define the selection as the Print Area through the Page Layout
tab ✓ CORRECT
Correct Answer: D
Rationale: Simply highlighting a range does not restrict printing; you must formally
define the Print Area through the Page Layout tab for Excel to recognize the boundary.
Changing orientation or scaling affects how content fits on the page but does not limit
which cells appear in the print preview. Always verify the print preview after setting the
print area to confirm the output matches your intent before distributing reports.
Question 5 of 50
A 27-year-old data entry clerk is transferring sales figures from a PDF into Excel. He
notices that when he pastes multiple rows of data, everything lands in a single column.
What Excel feature should he use to properly distribute the data into separate columns?
Exam-Style Questions with Detailed Rationales | 100% Verified |
Pass Guaranteed – A+ Graded
TABLE OF CONTENTS
Section 1 | Spreadsheet Fundamentals & Navigation | Q1 – Q10
Section 2 | Formulas, Functions & Calculations | Q11 – Q20
Section 3 | Data Analysis & What-If Tools | Q21 – Q30
Section 4 | Charts, Tables & Data Visualization | Q31 – Q40
Section 5 | Advanced Functions & Business Applications | Q41 – Q50
Instructions: Choose the single best answer. Pass: 80% in 90 minutes.
══════════════════════════════════════
SECTION 1: SPREADSHEET FUNDAMENTALS & NAVIGATION Q1 – Q10
══════════════════════════════════════
Question 1 of 50
A 29-year-old administrative assistant is setting up a new budget workbook. She needs
to quickly select all cells in the current worksheet to apply a uniform font. She tries
clicking individual column headers but finds this tedious. What keyboard shortcut
accomplishes this selection in one action?
A. Press Ctrl+A to select the entire worksheet ✓ CORRECT
B. Press Ctrl+Shift+End to select from A1 to the last used cell
C. Press Ctrl+Home to select all cells in the worksheet
D. Press Ctrl+Space to select all cells across the worksheet
Correct Answer: A
Rationale: Pressing Ctrl+A selects the entire worksheet instantly, allowing you to apply
formatting globally without tedious manual selection. Ctrl+Shift+End selects only from
the active cell to the last used cell, which is useful but does not capture the whole sheet.
,Mastering this shortcut saves considerable time when preparing large workbooks for
distribution.
Question 2 of 50
A 34-year-old inventory manager notices that when he enters "00123" into a cell, Excel
displays it as "123". He needs to preserve the leading zeros for product codes. What is
the most appropriate method to ensure the leading zeros remain visible?
A. Precede each entry with an apostrophe and then type the number
B. Format the cells as Text before entering the values ✓ CORRECT
C. Enter the values and then apply the Comma format
D. Increase the column width to accommodate the full number
Correct Answer: B
Rationale: Formatting the cells as Text before data entry forces Excel to treat the input
as a string, preserving leading zeros for product codes and IDs. Preceding a single entry
with an apostrophe works for one-off values but is impractical when entering or
importing hundreds of rows. Many inventory databases export codes with leading zeros,
so formatting entire columns as Text upfront prevents data corruption.
Question 3 of 50
A 42-year-old financial analyst is reviewing a workbook created by a colleague. She sees
a formula in cell B5 that reads "=Sheet2!D8". Her colleague explained this pulls data
from another worksheet. What does the exclamation point indicate in this formula
structure?
A. It converts the reference to an absolute reference
B. It separates the workbook name from the cell address
C. It separates the worksheet name from the cell address ✓ CORRECT
D. It indicates the formula contains an error condition
Correct Answer: C
, Rationale: The exclamation point in a formula separates the worksheet name from the
cell address, enabling cross-sheet references like "=Sheet2!D8". A common
misconception is that it indicates an absolute reference, but absolute references use
dollar signs rather than punctuation. Understanding cross-sheet syntax is essential
when consolidating data from multiple departmental worksheets.
Question 4 of 50
A 31-year-old project coordinator wants to print only the range A1:G25 from a large
worksheet rather than the entire sheet. She highlighted the range and expected the print
preview to reflect her selection, but it still shows all columns. What step did she likely
omit?
A. She forgot to save the workbook before printing
B. She neglected to set the page orientation to Landscape
C. She failed to adjust the scaling to Fit Sheet on One Page
D. She did not formally define the selection as the Print Area through the Page Layout
tab ✓ CORRECT
Correct Answer: D
Rationale: Simply highlighting a range does not restrict printing; you must formally
define the Print Area through the Page Layout tab for Excel to recognize the boundary.
Changing orientation or scaling affects how content fits on the page but does not limit
which cells appear in the print preview. Always verify the print preview after setting the
print area to confirm the output matches your intent before distributing reports.
Question 5 of 50
A 27-year-old data entry clerk is transferring sales figures from a PDF into Excel. He
notices that when he pastes multiple rows of data, everything lands in a single column.
What Excel feature should he use to properly distribute the data into separate columns?
