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

WGU D100 Practice Questions – Set 5

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 the shortcut to open the “Format Cells” dialog box?

Question 2 of 50

What does the VLOOKUP function do in Excel?

Question 3 of 50

What does the SUBTOTAL function in Excel do?

Question 4 of 50

How do you protect a worksheet in Excel?

Question 5 of 50

Which Excel function is used to count only cells that contain numbers?

Question 6 of 50

What happens when you double-click the fill handle in Excel?

Question 7 of 50

What is the main purpose of the PivotTable feature in Excel?

Question 8 of 50

Which of the following error codes represents an invalid cell reference?

Question 9 of 50

How can you insert multiple rows at once in Excel?

Question 10 of 50

Which of the following is the correct syntax for the IF function?

Question 11 of 50

How do you apply a filter to a data range in Excel?

Question 12 of 50

Which of the following features allows you to apply specific formatting based on cell values?

Question 13 of 50

What is the main purpose of the “Goal Seek” feature in Excel?

Question 14 of 50

Which of the following is the shortcut for creating a new chart?

Question 15 of 50

How do you lock a specific cell to prevent it from changing when copying a formula?

Question 16 of 50

What does the CONCATENATE function do in Excel?

Question 17 of 50

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

Question 18 of 50

What does pressing Ctrl + Z do in Excel?

Question 19 of 50

Which of the following functions is used to return the current date and time in Excel?

Question 20 of 50

What does the term “cell range” refer to in Excel?

Question 21 of 50

What is the purpose of the HLOOKUP function in Excel?

Question 22 of 50

Which of the following is a valid Excel formula?

Question 23 of 50

Which of the following tools helps visualize data in Excel?

Question 24 of 50

How do you group rows or columns in Excel?

Question 25 of 50

What is the purpose of the TEXT function in Excel?

Question 26 of 50

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

Question 27 of 50

What is the purpose of the FIND function in Excel?

Question 28 of 50

How do you remove gridlines from a worksheet in Excel?

Question 29 of 50

What does the MATCH function do in Excel?

Question 30 of 50

How do you create a named range in Excel?

Question 31 of 50

What is the shortcut for switching between worksheets in Excel?

Question 32 of 50

What does the LEFT function do in Excel?

Question 33 of 50

What is the purpose of the OFFSET function in Excel?

Question 34 of 50

How do you create a drop-down list in Excel?

Question 35 of 50

What is the purpose of the SUBSTITUTE function in Excel?

Question 36 of 50

What does the MID function do in Excel?

Question 37 of 50

What is the correct formula to calculate the square root of a number in Excel?

Question 38 of 50

How do you remove all formulas from a worksheet while keeping the results?

Question 39 of 50

Which of the following is the correct function to return the remainder of a division in Excel?

Question 40 of 50

What is the purpose of the INDIRECT function in Excel?

Question 41 of 50

How do you insert a new worksheet in Excel?

Question 42 of 50

What does pressing Ctrl + A do in Excel?

Question 43 of 50

What does the COUNTA function do in Excel?

Question 44 of 50

How do you apply borders to a selected range of cells in Excel?

Question 45 of 50

Which of the following tools is used to track changes made to a workbook?

Question 46 of 50

What is the shortcut for selecting the entire column in Excel?

Question 47 of 50

Which of the following is the purpose of the CHOOSE function in Excel?

Question 48 of 50

What does the CLEAN function do in Excel?

Question 49 of 50

How do you delete multiple worksheets at once in Excel?

Question 50 of 50

What does the LARGE function do in Excel?

Set 5 complete

You scored 0%

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

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