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
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
