WGU C268 Introduction to Spreadsheets 2026 Excel & Spreadsheet Fundamentals,

WGU C268 Introduction to Spreadsheets 2026 Excel & Spreadsheet
Fundamentals,..

WGU C268 Introduction to Spreadsheets - Practice Questions (2026)

Based on the WGU C268 Spreadsheets course competencies and exam structure,
here are 210 practice questions covering the key topics tested on the Objective
Assessment .



SECTION 1: BASIC FUNCTIONS & FORMULAS (Questions 1-30)

1. Which Excel function adds the individual numbers or the numbers included in a
range?



A. COUNT()



B. SUM()



C. ADD()



D. TOTAL()



Answer: B. SUM()

,Rationale: The SUM function calculates the total of numbers in a specified range.
It is one of the most fundamental Excel functions tested on the OA .



2. Which function counts the number of cells in a range that contain numbers?



A. COUNT()



B. COUNTA()



C. COUNTIF()



D. SUM()



Answer: A. COUNT()

Rationale: COUNT() only counts cells containing numeric values. COUNTA() counts
all non-blank cells regardless of content type .



3. Which function returns the largest value in a set of numbers?



A. MAX()

,B. LARGE()



C. HIGHEST()



D. TOP()



Answer: A. MAX()

Rationale: MAX() identifies the highest numeric value in a specified range .



4. Which function returns the smallest value in a set of numbers?



A. MIN()



B. SMALL()



C. LOWEST()



D. BOTTOM()

, Answer: A. MIN()

Rationale: MIN() identifies the lowest numeric value in a specified range .



5. Which function counts the number of cells in a range that are not blank?



A. COUNT()



B. COUNTA()



C. COUNTBLANK()



D. COUNTIF()



Answer: B. COUNTA()

Rationale: COUNTA() counts all non-empty cells regardless of data type (numbers,
text, dates) .



6. A spreadsheet contains employee names in column A and their salaries in
column B. To find the highest salary, which formula should you use?