WGU D465 Data Applications Complete EXAM

3/22/26, 11:43 AM WGU Student Portal

Help Articles

PRE-ASSESSMENT: DATA APPLICATIONS (WBO1) (PWBO)

Attempt #2
Status: Passed

1. Which task is an analyst performing in a spreadsheet when they isolate data that meets specific,
exclusive criteria?
YOUR CORRECT
ANSWER ANSWER


Filtering data


Combining data


Expanding data


Visualizing data


2. Which command should an analyst use to identify which table to access in a database using a
Structured Query Language (SQL)?
YOUR CORRECT
ANSWER ANSWER


WHERE


JOIN


FROM


CAST


3. How can an analyst sort all areas of Microsoft Excel and Google Sheets spreadsheets to organize
data for analysis?
YOUR CORRECT
ANSWER ANSWER


“Sort Range”


JOIN


“Sort Sheet”


ORDER BY
Accessibility Policy Accessibility Settings

https://my.wgu.edu/coaching-report/preassessment-report/v1/studentPidm/972295/assessmentCode/PWBO/testDate/1774068503 1/23

,3/22/26, 11:43 AM WGU Student Portal



4. Which method can an analyst use to categorize data based on a specific metric in Microsoft Excel
and Google Sheets spreadsheets for data analysis?
YOUR CORRECT
ANSWER ANSWER


Revise the cells


Write a sort function


Write a filter function


Select columns and rows


5. An analyst needs to manipulate and categorize data using a spreadsheet and Structured Query
Language (SQL).

How can they format and adjust data for analysis?
YOUR CORRECT
ANSWER ANSWER


Input and value data


Open and restrict access to others


Sort and filter data


Release and revise data


6. How does an analyst reorganize the layout of data in Microsoft Excel or Google Sheets spreadsheets
based on product type while keeping all rows visible?
YOUR CORRECT
ANSWER ANSWER


AVERAGE function


SUM function


SORT function


FILTER function


7. How does a pivot table custom list sort by default for analysis?
YOUR CORRECT
ANSWER ANSWER


By last entry first
Accessibility Policy Accessibility Settings

https://my.wgu.edu/coaching-report/preassessment-report/v1/studentPidm/972295/assessmentCode/PWBO/testDate/1774068503 2/23

, 3/22/26, 11:43 AM WGU Student Portal
YOUR CORRECT
ANSWER ANSWER


By first entry last


In ascending order first


In descending order first


8. An analyst is working with data in a Google Sheet spreadsheet that lists temperatures in
Fahrenheit but needs the data to be in Celsius.

How can the analyst change the unit of measurement?
YOUR CORRECT
ANSWER ANSWER


Use the CONVERT function


Use the TO TEXT function


Go through the Format tab


Go through the File tab


9. An analyst is working with a Microsoft Excel spreadsheet that will later be shared with a project
team.

Why would the analyst use the validation function on this sheet?
YOUR CORRECT
ANSWER ANSWER


To protect the privacy of any sensitive data


To sort for updated values


To limit the data shown


To control the type of data entered


10. An analyst wants to format all data in a column to YYYY-MM-DD format to be represented by dates
and times with values ranging from 00:00:00 to 11:59:59 using Structured Query Language (SQL).

The analyst uses the DATETIME command.

What does this command do to the data?


Accessibility Policy Accessibility Settings

https://my.wgu.edu/coaching-report/preassessment-report/v1/studentPidm/972295/assessmentCode/PWBO/testDate/1774068503 3/23