The Ultimate and Complete WGU C268 Spreadsheets Objective Assessment Study
Guide 2026–2027, Covering Microsoft Excel Fundamentals, Spreadsheet Navigation,
Workbooks and Worksheets, Cells and Ranges, Data Entry and Formatting, Relative
and Absolute Cell References, Formulas and Functions, Mathematical and Statistical
Functions, Logical Functions, Lookup Functions, Sorting and Filtering, Tables, Data
Validation, Conditional Formatting, Charts and Graphs, PivotTables, Data Analysis,
Spreadsheet Modeling, Business and Accounting Applications, Financial Functions,
What-If Analysis, Error Checking, Printing and Page Setup, Data Organization,
Spreadsheet Security, Formula Auditing, Practical Excel Scenarios, Practice
Questions With Detailed Solutions, Hands-On Spreadsheet Exercises, and
Comprehensive Preparation for the WGU C268 Spreadsheets Objective Assessment
Question 1: In a spreadsheet, which function is specifically designed to add together only
those cells within a specified range that meet a single, defined criterion?
A. SUMIF
B. SUMIFS
C. SUM
D. DSUM
CORRECT ANSWER: A. SUMIF
Rationale: The SUMIF function is the correct choice when you need to sum values based on a
single condition. SUMIFS is used for multiple criteria, SUM simply adds all numbers, and DSUM
is a database function.
Question 2: When using the VLOOKUP function, what is the correct order of the required
arguments?
A. lookup_value, table_array, col_index_num, [range_lookup]
B. table_array, lookup_value, col_index_num, [range_lookup]
C. lookup_value, col_index_num, table_array, [range_lookup]
D. col_index_num, lookup_value, table_array, [range_lookup]
CORRECT ANSWER: A. lookup_value, table_array, col_index_num, [range_lookup]
Rationale: The syntax for VLOOKUP is VLOOKUP(lookup_value, table_array, col_index_num,
[range_lookup]). The range_lookup is optional and determines if an exact or approximate
match is found.
Question 3: In a mixed cell reference, which part of the reference remains fixed when the
formula is copied to another cell?
,A. Both the column and the row
B. Neither the column nor the row
C. Either the column or the row, but not both
D. The entire reference
CORRECT ANSWER: C. Either the column or the row, but not both
Rationale: A mixed reference uses a dollar sign ($) before only the column letter or only the row
number (e.g., $A1 or A$1). This fixes the specified part, allowing the other part to change when
copied.
Question 4: What does the Excel function =PMT(rate, nper, pv, [fv], [type]) return?
A. The future value of an investment
B. The present value of a loan
C. The periodic payment for an annuity or loan
D. The total number of payment periods
CORRECT ANSWER: C. The periodic payment for an annuity or loan
Rationale: The PMT function calculates the constant periodic payment required to pay off a
loan or the payment for an annuity, given a constant interest rate and a constant payment
schedule.
Question 5: Which chart type is most effective for showing the proportion of individual parts
to the whole?
A. Column chart
B. Line chart
C. Bar chart
D. Pie chart
CORRECT ANSWER: D. Pie chart
Rationale: A pie chart visually represents data as slices of a circle, with each slice's size being
proportional to the value it represents, making it ideal for showing parts of a whole.
Question 6: How can you select non-adjacent cells in an Excel worksheet?
A. Click and drag over the cells
B. Hold the Ctrl key while clicking on the cells
,C. Hold the Shift key while clicking on the cells
D. Click the "Select All" button
CORRECT ANSWER: B. Hold the Ctrl key while clicking on the cells
Rationale: Holding the Ctrl key allows you to select multiple separate ranges that are not next
to each other. Shift selects a contiguous range from the initial selection.
Question 7: In Excel, what does the #REF! error indicate?
A. A cell reference is invalid
B. A value is not available
C. A division by zero has occurred
D. A name used in a formula is not recognized
CORRECT ANSWER: A. A cell reference is invalid
Rationale: The #REF! error occurs when a formula references a cell that no longer exists, often
due to deleting rows, columns, or entire sheets that the formula depended on.
Question 8: Which of the following is a valid date format that Excel will automatically
recognize?
A. Jan-1-2023
B. 2023/01/01
C. 1 Jan 2023
D. All of the above
CORRECT ANSWER: D. All of the above
Rationale: Excel has a wide range of built-in date formats it recognizes,
including mm/dd/yyyy, dd-mmm-yyyy, yyyy/mm/dd, and many other standard variations.
Question 9: The XLOOKUP function in Excel, when compared to VLOOKUP, offers which
significant advantage?
A. It can only search in the first column.
B. It can search in any direction (left, right, up, down).
C. It is slower and more memory-intensive.
D. It cannot return an error message if a value is not found.
CORRECT ANSWER: B. It can search in any direction (left, right, up, down).
, Rationale: Unlike VLOOKUP, which only searches vertically from left to right, XLOOKUP can look
up values both vertically and horizontally and can return a value from any column on either side
of the lookup column.
Question 10: To quickly add the values in a column, what is the shortcut key combination to
insert the AutoSum function?
A. Ctrl + Shift + A
B. Alt + =
C. Shift + Enter
D. Ctrl + S
CORRECT ANSWER: B. Alt + =
Rationale: The keyboard shortcut Alt + = instantly inserts the SUM function into the active cell,
usually with an intelligent guess as to the range you want to sum.
Question 11: Which feature in Excel allows you to view the same worksheet in two separate
windows simultaneously?
A. Split
B. Freeze Panes
C. New Window
D. Arrange All
CORRECT ANSWER: C. New Window
Rationale: The "New Window" feature opens a second window of the same workbook, allowing
you to view different parts of the same worksheet side-by-side, which is useful for comparing
data.
Question 12: What is the primary difference between the COUNT and COUNTA functions?
A. COUNT counts only cells with numbers; COUNTA counts cells with any data type (not empty).
B. COUNT counts all cells; COUNTA counts only text.
C. COUNT is a statistical function; COUNTA is a logical function.
D. There is no difference; they are synonyms.
CORRECT ANSWER: A. COUNT counts only cells with numbers; COUNTA counts cells with any
data type (not empty).
Guide 2026–2027, Covering Microsoft Excel Fundamentals, Spreadsheet Navigation,
Workbooks and Worksheets, Cells and Ranges, Data Entry and Formatting, Relative
and Absolute Cell References, Formulas and Functions, Mathematical and Statistical
Functions, Logical Functions, Lookup Functions, Sorting and Filtering, Tables, Data
Validation, Conditional Formatting, Charts and Graphs, PivotTables, Data Analysis,
Spreadsheet Modeling, Business and Accounting Applications, Financial Functions,
What-If Analysis, Error Checking, Printing and Page Setup, Data Organization,
Spreadsheet Security, Formula Auditing, Practical Excel Scenarios, Practice
Questions With Detailed Solutions, Hands-On Spreadsheet Exercises, and
Comprehensive Preparation for the WGU C268 Spreadsheets Objective Assessment
Question 1: In a spreadsheet, which function is specifically designed to add together only
those cells within a specified range that meet a single, defined criterion?
A. SUMIF
B. SUMIFS
C. SUM
D. DSUM
CORRECT ANSWER: A. SUMIF
Rationale: The SUMIF function is the correct choice when you need to sum values based on a
single condition. SUMIFS is used for multiple criteria, SUM simply adds all numbers, and DSUM
is a database function.
Question 2: When using the VLOOKUP function, what is the correct order of the required
arguments?
A. lookup_value, table_array, col_index_num, [range_lookup]
B. table_array, lookup_value, col_index_num, [range_lookup]
C. lookup_value, col_index_num, table_array, [range_lookup]
D. col_index_num, lookup_value, table_array, [range_lookup]
CORRECT ANSWER: A. lookup_value, table_array, col_index_num, [range_lookup]
Rationale: The syntax for VLOOKUP is VLOOKUP(lookup_value, table_array, col_index_num,
[range_lookup]). The range_lookup is optional and determines if an exact or approximate
match is found.
Question 3: In a mixed cell reference, which part of the reference remains fixed when the
formula is copied to another cell?
,A. Both the column and the row
B. Neither the column nor the row
C. Either the column or the row, but not both
D. The entire reference
CORRECT ANSWER: C. Either the column or the row, but not both
Rationale: A mixed reference uses a dollar sign ($) before only the column letter or only the row
number (e.g., $A1 or A$1). This fixes the specified part, allowing the other part to change when
copied.
Question 4: What does the Excel function =PMT(rate, nper, pv, [fv], [type]) return?
A. The future value of an investment
B. The present value of a loan
C. The periodic payment for an annuity or loan
D. The total number of payment periods
CORRECT ANSWER: C. The periodic payment for an annuity or loan
Rationale: The PMT function calculates the constant periodic payment required to pay off a
loan or the payment for an annuity, given a constant interest rate and a constant payment
schedule.
Question 5: Which chart type is most effective for showing the proportion of individual parts
to the whole?
A. Column chart
B. Line chart
C. Bar chart
D. Pie chart
CORRECT ANSWER: D. Pie chart
Rationale: A pie chart visually represents data as slices of a circle, with each slice's size being
proportional to the value it represents, making it ideal for showing parts of a whole.
Question 6: How can you select non-adjacent cells in an Excel worksheet?
A. Click and drag over the cells
B. Hold the Ctrl key while clicking on the cells
,C. Hold the Shift key while clicking on the cells
D. Click the "Select All" button
CORRECT ANSWER: B. Hold the Ctrl key while clicking on the cells
Rationale: Holding the Ctrl key allows you to select multiple separate ranges that are not next
to each other. Shift selects a contiguous range from the initial selection.
Question 7: In Excel, what does the #REF! error indicate?
A. A cell reference is invalid
B. A value is not available
C. A division by zero has occurred
D. A name used in a formula is not recognized
CORRECT ANSWER: A. A cell reference is invalid
Rationale: The #REF! error occurs when a formula references a cell that no longer exists, often
due to deleting rows, columns, or entire sheets that the formula depended on.
Question 8: Which of the following is a valid date format that Excel will automatically
recognize?
A. Jan-1-2023
B. 2023/01/01
C. 1 Jan 2023
D. All of the above
CORRECT ANSWER: D. All of the above
Rationale: Excel has a wide range of built-in date formats it recognizes,
including mm/dd/yyyy, dd-mmm-yyyy, yyyy/mm/dd, and many other standard variations.
Question 9: The XLOOKUP function in Excel, when compared to VLOOKUP, offers which
significant advantage?
A. It can only search in the first column.
B. It can search in any direction (left, right, up, down).
C. It is slower and more memory-intensive.
D. It cannot return an error message if a value is not found.
CORRECT ANSWER: B. It can search in any direction (left, right, up, down).
, Rationale: Unlike VLOOKUP, which only searches vertically from left to right, XLOOKUP can look
up values both vertically and horizontally and can return a value from any column on either side
of the lookup column.
Question 10: To quickly add the values in a column, what is the shortcut key combination to
insert the AutoSum function?
A. Ctrl + Shift + A
B. Alt + =
C. Shift + Enter
D. Ctrl + S
CORRECT ANSWER: B. Alt + =
Rationale: The keyboard shortcut Alt + = instantly inserts the SUM function into the active cell,
usually with an intelligent guess as to the range you want to sum.
Question 11: Which feature in Excel allows you to view the same worksheet in two separate
windows simultaneously?
A. Split
B. Freeze Panes
C. New Window
D. Arrange All
CORRECT ANSWER: C. New Window
Rationale: The "New Window" feature opens a second window of the same workbook, allowing
you to view different parts of the same worksheet side-by-side, which is useful for comparing
data.
Question 12: What is the primary difference between the COUNT and COUNTA functions?
A. COUNT counts only cells with numbers; COUNTA counts cells with any data type (not empty).
B. COUNT counts all cells; COUNTA counts only text.
C. COUNT is a statistical function; COUNTA is a logical function.
D. There is no difference; they are synonyms.
CORRECT ANSWER: A. COUNT counts only cells with numbers; COUNTA counts cells with any
data type (not empty).
