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

WGU D100 Practice Questions – Set 4

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

Question 1 of 50

What does the CONCAT function do in Excel?

Question 2 of 50

What is the shortcut for saving a workbook in Excel?

Question 3 of 50

Which of the following functions returns the current date in Excel?

Question 4 of 50

How do you quickly switch to the next worksheet in Excel?

Question 5 of 50

Which chart type is best for showing parts of a whole?

Question 6 of 50

What does the MAX function do in Excel?

Question 7 of 50

What is the purpose of the Fill Handle in Excel?

Question 8 of 50

Which of the following functions can you use to return the current day of the week in Excel?

Question 9 of 50

What is the default file extension for Excel workbooks?

Question 10 of 50

How do you create a comment in an Excel cell?

Question 11 of 50

What does the COUNTA function do in Excel?

Question 12 of 50

What is a Sparkline in Excel?

Question 13 of 50

Which of the following functions calculates the number of years between two dates in Excel?

Question 14 of 50

How do you merge two or more cells in Excel?

Question 15 of 50

What is the shortcut to insert a new worksheet in Excel?

Question 16 of 50

What does the ROUND function do in Excel?

Question 17 of 50

Which of the following error messages indicates a divide-by-zero error?

Question 18 of 50

How can you convert text to columns in Excel?

Question 19 of 50

What is the result of the formula =AVERAGE(10, 20, 30)?

Question 20 of 50

What is the purpose of Freeze Panes in Excel?

Question 21 of 50

What is the purpose of the TRIM function in Excel?

Question 22 of 50

How can you quickly duplicate a worksheet in Excel?

Question 23 of 50

Which of the following formulas returns the current date and time?

Question 24 of 50

How do you open the “Find and Replace” feature in Excel?

Question 25 of 50

What is the shortcut for hiding a row in Excel?

Question 26 of 50

Which of the following functions would you use to find the smallest number in a range?

Question 27 of 50

What does the LEN function do in Excel?

Question 28 of 50

What is the shortcut to open a new workbook in Excel?

Question 29 of 50

Which of the following Excel features allows you to perform what-if analysis?

Question 30 of 50

What is the default number of sheets in a new Excel workbook?

Question 31 of 50

How do you insert a new row in Excel?

Question 32 of 50

What does the IF function do in Excel?

Question 33 of 50

How do you clear all the formatting in a cell?

Question 34 of 50

What is the purpose of the CONCATENATE function in Excel?

Question 35 of 50

What does Ctrl + D do in Excel?

Question 36 of 50

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

Question 37 of 50

What does the ISBLANK function do in Excel?

Question 38 of 50

How do you copy the contents of a cell to the clipboard in Excel?

Question 39 of 50

Which of the following features enables you to view two parts of a worksheet at once?

Question 40 of 50

What is the shortcut for opening the Print dialog in Excel?

Question 41 of 50

What does the RANK function do in Excel?

Question 42 of 50

How do you toggle between displaying formulas and values in Excel?

Question 43 of 50

What is the purpose of Data Validation in Excel?

Question 44 of 50

Which Excel function would you use to count cells that meet a specific condition?

Question 45 of 50

What is the purpose of conditional formatting in Excel?

Question 46 of 50

How do you remove duplicates in a dataset in Excel?

Question 47 of 50

How do you insert a column chart in Excel?

Question 48 of 50

What is the shortcut for selecting an entire row in Excel?

Question 49 of 50

Which of the following is a use of the SUMIF function?

Question 50 of 50

What is the default alignment for text in Excel?

Set 4 complete

You scored 0%

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

Next: Set 5

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