Skip to content
Pass Any WGU OA Exam Now & Pay After You Pass. Contact Us!
  1. Home
  2. WGU Exams
  3. WGU D100
  4. Set 3
WGU D100 · Introduction to Spreadsheets

WGU D100 Practice Questions – Set 3

50 multiple-choice questions with answers and detailed explanations. Untimed — choose an answer to check it instantly.

Question 1 of 50

Which key combination will you use to open the Find dialog box in Excel?

Question 2 of 50

What function will you use to calculate the future value of an investment based on periodic payments and a constant interest rate?

Question 3 of 50

What does the Excel function COUNTA do?

Question 4 of 50

Which Excel tool allows you to filter data based on specific criteria?

Question 5 of 50

What is the function of the AutoFill feature in Excel?

Question 6 of 50

How can you freeze the first row of a worksheet so it stays visible while scrolling?

Question 7 of 50

Which of the following Excel functions calculates the largest value in a range?

Question 8 of 50

Which function in Excel allows you to join the contents of two or more cells?

Question 9 of 50

What will be the result of the formula =A1+A2 if A1 contains 5 and A2 contains "3"?

Question 10 of 50

What is the purpose of a PivotChart in Excel?

Question 11 of 50

How do you apply a data validation rule to restrict the value in a cell to whole numbers only?

Question 12 of 50

What is the default alignment of numbers in Excel?

Question 13 of 50

How can you quickly delete all data in a worksheet without deleting the actual worksheet?

Question 14 of 50

Which function can be used to count the number of blank cells in a range?

Question 15 of 50

What is the purpose of the Goal Seek tool in Excel?

Question 16 of 50

How can you display all formulas in a worksheet at once?

Question 17 of 50

What is the function of the "TODAY" function in Excel?

Question 18 of 50

Which of the following Excel features allows you to check for inconsistencies in formulas?

Question 19 of 50

What type of chart would you use to compare the proportions of different categories in a dataset?

Question 20 of 50

Which Excel function can be used to calculate the median of a range of numbers?

Question 21 of 50

How can you force a formula to calculate the product of two ranges of numbers?

Question 22 of 50

Which of the following tools allows you to track changes made by multiple users in a workbook?

Question 23 of 50

What happens when you press Ctrl + Shift + L in Excel?

Question 24 of 50

Which of the following is the keyboard shortcut to insert a new row in Excel?

Question 25 of 50

What is the purpose of the ROUND function in Excel?

Question 26 of 50

Which of the following functions would you use to find the number of cells in a range that meet a certain condition?

Question 27 of 50

Which of the following is NOT a function related to text manipulation in Excel?

Question 28 of 50

How can you enable editing in a cell without using the mouse?

Question 29 of 50

What is the result of the formula =SUM(3,5,8,-2)?

Question 30 of 50

Which of the following is NOT an Excel error message?

Question 31 of 50

How do you create a named range in Excel?

Question 32 of 50

Which of the following tools allows you to highlight cells that meet a specific condition?

Question 33 of 50

What does the HLOOKUP function do in Excel?

Question 34 of 50

What happens if you press Ctrl + Home in Excel?

Question 35 of 50

Which of the following is a valid argument for the VLOOKUP function?

Question 36 of 50

What is the purpose of the IFERROR function?

Question 37 of 50

How can you quickly select an entire row in Excel?

Question 38 of 50

What function would you use to find the most frequently occurring value in a dataset?

Question 39 of 50

Which of the following is the shortcut to insert the current time in Excel?

Question 40 of 50

What is the purpose of the RANK function?

Question 41 of 50

How can you quickly adjust the width of a column to fit its content?

Question 42 of 50

Which of the following functions can be used to calculate monthly loan payments in Excel?

Question 43 of 50

What is the purpose of the LEN function in Excel?

Question 44 of 50

Which of the following will you use to restrict user input in a cell to only predefined values?

Question 45 of 50

Which function allows you to retrieve data from multiple worksheets at once?

Question 46 of 50

How do you switch between different open workbooks in Excel?

Question 47 of 50

What is the result of the formula =ROUND(15.75, 0)?

Question 48 of 50

Which function calculates the internal rate of return for a series of cash flows in Excel?

Question 49 of 50

How can you quickly copy the formatting of a cell to another cell in Excel?

Question 50 of 50

Which of the following will you use to create a summary of a dataset with totals and averages?

Set 3 complete

You scored 0%

0 correct out of 0 answered (50 questions in this set).

Next: Set 4

Struggling with WGU D100?

If this exam is giving you a hard time, let us be your helping hand. Contact us, and we'll provide the assistance you need to pass and move forward.

Chat Now