1|Page
WGU D100 OBJECTIVE ASSESSMENT V1 AND V2 NEWEST 2026
TEST BANK | D100 INTRODUCTION TO SPREADSHEETS OA
EXAM WITH COMPLETE QUESTIONS AND CORRECT VERIFIED
ANSWERS / ALREADY GRADED A+ (MOST RECENT!!)
1. A sales manager wants to calculate the total revenue generated from
products sold during the month. The sales values are listed in cells
B2:B25. Which Excel formula should be used?
A. =COUNT(B2:B25)
B. =SUM(B2:B25)
C. =AVERAGE(B2:B25)
D. =MAX(B2:B25)
Answer: B. =SUM(B2:B25)
Rationale: The SUM function adds all numeric values within the
specified range and is commonly used to calculate totals.
2. A worksheet contains employee salaries in cells C2:C30. You want to
calculate the average salary for all employees. Which formula is
correct?
A. =AVERAGE(C2:C30)
,2|Page
B. =SUM(C2:C30)
C. =COUNT(C2:C30)
D. =MEDIAN(C2:C30)
Answer: A. =AVERAGE(C2:C30)
Rationale: The AVERAGE function calculates the arithmetic mean of
the selected values.
3. A formula in cell D2 is copied down several rows. The formula must
always reference the tax rate stored in cell F1. Which reference should
be used?
A. F1
B. $F$1
C. F$1
D. $F1
Answer: B. $F$1
Rationale: An absolute reference ($F$1) prevents both the row and
column from changing when the formula is copied.
,3|Page
4. Which Excel feature summarizes large amounts of data by grouping
and calculating totals, averages, and counts?
A. Conditional Formatting
B. PivotTable
C. Data Validation
D. Freeze Panes
Answer: B. PivotTable
Rationale: PivotTables quickly summarize and analyze large datasets
without changing the original data.
5. A worksheet contains monthly sales figures. Which chart type is
generally the best choice for displaying sales trends over time?
A. Pie Chart
B. Scatter Plot
C. Line Chart
D. Doughnut Chart
Answer: C. Line Chart
, 4|Page
Rationale: Line charts clearly display trends and changes across time
periods.
6. Before sorting a worksheet by employee name, what should you do
first?
A. Delete duplicate values.
B. Select the entire dataset, including related columns.
C. Protect the worksheet.
D. Convert all numbers to text.
Answer: B. Select the entire dataset, including related columns.
Rationale: Selecting the complete dataset ensures that related
information remains together after sorting.
7. Which Excel function counts only cells containing numeric values?
A. COUNTA
B. COUNT
C. COUNTIF
D. ROWS
WGU D100 OBJECTIVE ASSESSMENT V1 AND V2 NEWEST 2026
TEST BANK | D100 INTRODUCTION TO SPREADSHEETS OA
EXAM WITH COMPLETE QUESTIONS AND CORRECT VERIFIED
ANSWERS / ALREADY GRADED A+ (MOST RECENT!!)
1. A sales manager wants to calculate the total revenue generated from
products sold during the month. The sales values are listed in cells
B2:B25. Which Excel formula should be used?
A. =COUNT(B2:B25)
B. =SUM(B2:B25)
C. =AVERAGE(B2:B25)
D. =MAX(B2:B25)
Answer: B. =SUM(B2:B25)
Rationale: The SUM function adds all numeric values within the
specified range and is commonly used to calculate totals.
2. A worksheet contains employee salaries in cells C2:C30. You want to
calculate the average salary for all employees. Which formula is
correct?
A. =AVERAGE(C2:C30)
,2|Page
B. =SUM(C2:C30)
C. =COUNT(C2:C30)
D. =MEDIAN(C2:C30)
Answer: A. =AVERAGE(C2:C30)
Rationale: The AVERAGE function calculates the arithmetic mean of
the selected values.
3. A formula in cell D2 is copied down several rows. The formula must
always reference the tax rate stored in cell F1. Which reference should
be used?
A. F1
B. $F$1
C. F$1
D. $F1
Answer: B. $F$1
Rationale: An absolute reference ($F$1) prevents both the row and
column from changing when the formula is copied.
,3|Page
4. Which Excel feature summarizes large amounts of data by grouping
and calculating totals, averages, and counts?
A. Conditional Formatting
B. PivotTable
C. Data Validation
D. Freeze Panes
Answer: B. PivotTable
Rationale: PivotTables quickly summarize and analyze large datasets
without changing the original data.
5. A worksheet contains monthly sales figures. Which chart type is
generally the best choice for displaying sales trends over time?
A. Pie Chart
B. Scatter Plot
C. Line Chart
D. Doughnut Chart
Answer: C. Line Chart
, 4|Page
Rationale: Line charts clearly display trends and changes across time
periods.
6. Before sorting a worksheet by employee name, what should you do
first?
A. Delete duplicate values.
B. Select the entire dataset, including related columns.
C. Protect the worksheet.
D. Convert all numbers to text.
Answer: B. Select the entire dataset, including related columns.
Rationale: Selecting the complete dataset ensures that related
information remains together after sorting.
7. Which Excel function counts only cells containing numeric values?
A. COUNTA
B. COUNT
C. COUNTIF
D. ROWS
