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

WGU D100 Practice Questions – Set 1

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

Question 1 of 50

Which tab contains the Zoom button in Excel?

Question 2 of 50

Where can you find the Goal Seek button in Excel?

Question 3 of 50

What is an interactive view of worksheet data in Excel called?

Question 4 of 50

What type of report is a visual representation of PivotTables?

Question 5 of 50

What describes how a value changes over time or the relationship between two variables?

Question 6 of 50

Which chart cannot have a trendline added to it?

Question 7 of 50

What is the value that measures the strength of a trend and ranges from 0 to 1?

Question 8 of 50

Where can you find the Move Chart button in Excel?

Question 9 of 50

In a PivotTable, what do data fields correspond to?

Question 10 of 50

Which tab contains the PivotTable button in Excel?

Question 11 of 50

What does the Report Layout button allow you to modify?

Question 12 of 50

What summary function estimates the standard deviation of all data in a PivotTable?

Question 13 of 50

Which summary function finds the smallest data value in a PivotTable?

Question 14 of 50

Where can you find the Field List button in a PivotTable?

Question 15 of 50

What are visual filters that make PivotCharts and PivotTables easier to interpret called?

Question 16 of 50

How do you connect Slicers to multiple PivotTables?

Question 17 of 50

Which tab allows you to change the height of a Slicer?

Question 18 of 50

What type of PivotTable is constantly updated as data changes?

Question 19 of 50

Which function allows you to examine which cells are referenced by formulas?

Question 20 of 50

What Excel tool allows you to specify up to 200 cells to adjust to solve a problem?

Question 21 of 50

What report shows the answer that Solver found, including the constraints used?

Question 22 of 50

What tool in Excel displays arrows to indicate relationships between formulas and cells?

Question 23 of 50

A cell containing a formula that references other cells is called what?

Question 24 of 50

Where can you find the Trace Precedents button?

Question 25 of 50

Which error code indicates that a cell reference in a formula is not valid?

Question 26 of 50

What Excel tool opens a window to monitor specific cells for changes?

Question 27 of 50

Which tool allows you to evaluate a formula step by step?

Question 28 of 50

What is NOT a type of data validation criteria in Excel?

Question 29 of 50

Where can you find the 'What-If Analysis' button?

Question 30 of 50

What Excel tool can help identify invalid data entered via formulas or automated tools like Goal Seek?

Question 31 of 50

What Solver parameter sets the number of possible answer value combinations to be tried?

Question 32 of 50

What are named combinations of values assigned to variables in an Excel model called?

Question 33 of 50

Which scenario is helpful to define in any Excel model to represent initial assumptions?

Question 34 of 50

What worksheet generated by the Scenario Manager provides an outline format of scenarios?

Question 35 of 50

Where can you restrict access to workbooks using Information Rights Management (IRM)?

Question 36 of 50

What Excel feature ensures that critical cells are not accidentally changed?

Question 37 of 50

What is created from column or row titles in a workbook?

Question 38 of 50

Where can you find the Financial button and PMT function?

Question 39 of 50

What is the function of data tables in Excel?

Question 40 of 50

What function returns the present value of an annuity?

Question 41 of 50

What is the path to the 'Protect Sheet' button in Excel?

Question 42 of 50

How do you hide a worksheet in Excel?

Question 43 of 50

What is a reference to a cell or range of cells in another workbook called?

Question 44 of 50

Which function is used when a table is organized horizontally in Excel?

Question 45 of 50

Which function is most commonly used in vertical tables?

Question 46 of 50

What type of formatting allows you to apply rules based on cell values?

Question 47 of 50

What do you call the left column values in a table array used for VLOOKUP?

Question 48 of 50

What is the path to the 'Total Row' check box for tables?

Question 49 of 50

How is data arranged when it is in ascending sequence?

Question 50 of 50

What is the path to the Format Painter button in Excel?

Set 1 complete

You scored 0%

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

Next: Set 2

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