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 2
WGU D100 · Introduction to Spreadsheets

WGU D100 Practice Questions – Set 2

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

Question 1 of 50

Which of the following is a method for freezing rows and columns in Excel?

Question 2 of 50

What does Excel display when the width of a column is too narrow to display the entire content of a cell?

Question 3 of 50

Which of the following features can be used to display the formula used in a cell?

Question 4 of 50

How can you modify the width of a column to automatically fit the longest entry?

Question 5 of 50

Which of the following Excel functions returns the highest value in a range of cells?

Question 6 of 50

In Excel, what is the use of a PivotTable?

Question 7 of 50

What is the shortcut to quickly duplicate the contents of a cell into another cell directly below it?

Question 8 of 50

What does the VLOOKUP function do in Excel?

Question 9 of 50

What is the function of the “Merge & Center” button?

Question 10 of 50

Which of the following is the correct formula to calculate the total of a range of cells?

Question 11 of 50

How do you add a comment to a cell in Excel?

Question 12 of 50

What function in Excel can be used to calculate the average of a set of numbers?

Question 13 of 50

Which of the following would you use to lock cells so they cannot be edited?

Question 14 of 50

What does the PMT function calculate?

Question 15 of 50

What key combination is used to open the Find and Replace dialog box?

Question 16 of 50

What feature is used to create a series based on a pattern of values?

Question 17 of 50

What is the default number format applied to cells in Excel?

Question 18 of 50

What formula would you use to find the smallest value in a range of cells?

Question 19 of 50

Which feature allows you to limit the type of data entered in a cell?

Question 20 of 50

Which keyboard shortcut inserts a new worksheet in Excel?

Question 21 of 50

How can you format cells to display values as percentages?

Question 22 of 50

What does the COUNT function do in Excel?

Question 23 of 50

Which of the following tools automatically totals the selected cells in Excel?

Question 24 of 50

Which tool allows you to organize and view large datasets by category?

Question 25 of 50

What type of chart is used to show trends over time?

Question 26 of 50

What function would you use to return the current date in a cell?

Question 27 of 50

Which of the following is NOT a valid argument in the IF function?

Question 28 of 50

How can you quickly remove the formatting from a range of cells?

Question 29 of 50

Which of the following can be used to compare the parts of a whole?

Question 30 of 50

What does the CONCATENATE function do in Excel?

Question 31 of 50

Which of the following represents an absolute cell reference?

Question 32 of 50

What is the shortcut to display formulas instead of their results in Excel?

Question 33 of 50

What type of chart is best used to display the relationship between two variables?

Question 34 of 50

How do you repeat the last action in Excel?

Question 35 of 50

What feature allows you to visualize the magnitude of values in Excel cells with colors?

Question 36 of 50

Which function calculates the number of non-empty cells in a range?

Question 37 of 50

What would you use to remove duplicate values from a dataset in Excel?

Question 38 of 50

How do you apply a filter to a dataset in Excel?

Question 39 of 50

What is the default alignment for text in Excel cells?

Question 40 of 50

Which Excel function rounds a number to a specified number of decimal places?

Question 41 of 50

What is the shortcut to open the Format Cells dialog box?

Question 42 of 50

How can you create a chart from a selected range of cells in Excel?

Question 43 of 50

Which of the following tools checks for errors in a worksheet’s formulas?

Question 44 of 50

What does the TRIM function do in Excel?

Question 45 of 50

How do you remove gridlines from a worksheet in Excel?

Question 46 of 50

What feature allows you to identify cells that influence the value of a selected cell?

Question 47 of 50

What is the shortcut to hide selected rows in Excel?

Question 48 of 50

How can you display the contents of a long text entry on multiple lines in a single cell?

Question 49 of 50

Which of the following is NOT a function in Excel?

Question 50 of 50

Which of the following will you use to generate a random number in Excel?

Set 2 complete

You scored 0%

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

Next: Set 3

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