WGU D268 Practice Exam 2026 – 2 Versions with Verified Questions & Answers

1|Page




WGU D268 Practice Exam (NEW UPDATED 2 VERSION) LATEST
ACTUAL EXAM QUESTIONS AND CORRECT ANSWERS (VERIFIED
QUESTIONS AND ANSWERS) | GUARANTEED PASS A+ UPDATED 2026




WGU D268 Practice Exam

1. Which of the following is the correct formula to sum values in cells A1 through A10 in Excel?

A. =SUM(A1:A10)
B. =ADD(A1-A10)
C. =TOTAL(A1,A10)
D. =SUMM(A1 TO A10)
Answer: A



2. What is the primary purpose of conditional formatting in a spreadsheet?

A. To change the appearance of cells based on specific conditions
B. To enter formulas faster
C. To protect sheets
D. To sort data alphabetically
Answer: A



3. Which chart type is best for showing trends over time?

A. Line chart
B. Pie chart
C. Scatter plot
D. Bar chart
Answer: A




2026 2027 GRADED A+

,2|Page


4. In Excel, which function finds the average of a range of numbers?

A. =AVERAGE(range)
B. =SUM(range)/COUNT(range)
C. =MEAN(range)
D. =AVG(range)
Answer: A



5. What does the VLOOKUP function do?

A. Looks up a value in a table and returns a corresponding value from another column
B. Searches vertically for formatting issues
C. Summarizes data horizontally
D. Calculates the average of a column
Answer: A



6. Which keyboard shortcut is used to create a new worksheet in Excel?

A. Shift + F11
B. Ctrl + N
C. Alt + N
D. Ctrl + Shift + N
Answer: A



7. What type of reference changes when a formula is copied to another cell?

A. Relative reference
B. Absolute reference
C. Mixed reference
D. Fixed reference
Answer: A



8. Which symbol is used in Excel to denote an absolute reference?

A. $
B. &
C. #
D. @
Answer: A


2026 2027 GRADED A+

,3|Page




9. What is the purpose of the IF function?

A. To perform logical tests and return different values based on the result
B. To find averages
C. To sum cells only
D. To sort data
Answer: A



10. Which type of data visualization is best for comparing parts of a whole?

A. Pie chart
B. Line chart
C. Scatter plot
D. Histogram
Answer: A



11. What does the COUNTIF function do?

A. Counts the number of cells that meet a specific criterion
B. Counts all empty cells
C. Finds the total sum of a range
D. Calculates an average
Answer: A



12. What is the keyboard shortcut to paste a value without formatting?

A. Ctrl + Alt + V, then select Values
B. Ctrl + V
C. Ctrl + C
D. Alt + F4
Answer: A



13. Which function rounds a number to a specified number of digits?

A. =ROUND(number, num_digits)
B. =TRUNC(number)
C. =CEILING(number)



2026 2027 GRADED A+

, 4|Page


D. =FLOOR(number)
Answer: A



14. In Excel, what is the purpose of the Data Validation feature?

A. To restrict the type of data entered into a cell
B. To automatically sum numbers
C. To create charts
D. To format cells conditionally
Answer: A



15. Which of the following is true about pivot tables?

A. They summarize and analyze large datasets easily
B. They only work with text data
C. They cannot perform calculations
D. They replace the original data
Answer: A



16. Which chart type is best for showing the distribution of a single variable?

A. Histogram
B. Pie chart
C. Line chart
D. Scatter plot
Answer: A



17. What does the CONCATENATE or CONCAT function do?

A. Combines text from multiple cells into one cell
B. Splits text into multiple cells
C. Counts text occurrences
D. Searches for text
Answer: A




2026 2027 GRADED A+