WGU D465
Study online at https://quizlet.com/_gom8o5
1. Which task is an analyst performing in a spreadsheet Filtering Data
when they isolate data that meets specific, exclusive
criteria?
2. Which command should an analyst use to identify FROM
which table to access in a database using a Structured
Query Language (SQL)?
3. How can an analyst sort all areas of Microsoft Excel "sort sheet"
and Google Sheets spreadsheets to organize data for
analysis?
4. Which method can an analyst use to categorize data Write a sort function
based on a specific metric in Microsoft Excel and
Google Sheets spreadsheets for data analysis?
5. An analyst needs to manipulate and categorize data Sort and Filter data
using a spreadsheet and Structured Query Language
(SQL).How can they format and adjust data for analy-
sis?
6. How does an analyst reorganize the layout of data in SORT function
Microsoft Excel or Google Sheets spreadsheets based
on product type while keeping all rows visible?
7. How does a pivot table custom list sort by default for In ascending order first
analysis?
8. An analyst is working with data in a Google Sheet Use the CONVERT function
spreadsheet that lists temperatures in Fahrenheit but
needs the data to be in Celsius.How can the analyst
change the unit of measurement?
, WGU D465
Study online at https://quizlet.com/_gom8o5
9. An analyst is working with a Microsoft Excel spread- To control the type of data
sheet that will later be shared with a project team.Why entered
would the analyst use the validation function on this
sheet?
10. An analyst wants to format all data in a column to Data will be converted to a
YYYY-MM-DD format to be represented by dates and datetime value.
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 com-
mand do to the data?
11. Why does an analyst use the LEN function in Microsoft To determine the length of
Excel and Google Sheets spreadsheets? a string
12. Why does an analyst use the CONCAT_WS function in To add two or more strings
Structured Query Language (SQL)? together with a separator
13. Which programming language can handle trillions of Structured Query Lan-
rows of data and is now a standard language for work- guage (SQL)
ing with database programs?
14. An analyst is working on a project with a lot of Create a data validation
milestones to track and wants to create a spread- menu in cells with prede-
sheet that everyone can use to track their individ- termined options
ual progress.How could the analyst sort and filter
progress milestones?
15. An analyst working with data in two different Google VLOOKUP
Sheets needs information from both spreadsheets to
connect together in a matching column on a single
sheet.Which function should the analyst use?
, WGU D465
Study online at https://quizlet.com/_gom8o5
16. An analyst working to aggregate data in databases INNER JOIN
uses a Structured Query Language (SQL) command
that returns all matching records in two tables and the
key values in each.Which command has the analyst
used?
17. An analyst working to aggregate data in databases AS
wants to create a temporary name for a table with a
complex name to make Structured Query Language
(SQL) queries simpler. Which command should the
analyst use?
18. An analyst working to aggregate data in databases FROM
uses a Structured Query Language (SQL) command
to create a temporary name for a table and receives
an ERROR message when the command is used.Which
command does the analyst use to create a temporary
name for a table?
19. An analyst working in a spreadsheet needs to deter- COUNT DISTINCT
mine the total quantity of numerical values within a
specific range that are unique.Which function should
the analyst use?
20. An analyst is working in a database and needs to use The table mentioned first
a function that will return all the records from one is on the left.
table and only the matching records from a second
table. How does the analyst determine the order of
the tables using a JOIN function?
21. An analyst is working on a spreadsheet and notices Lock the table array part of
that rows and columns that should remain unchanged the function
are changing when they are copied. This data set is
Study online at https://quizlet.com/_gom8o5
1. Which task is an analyst performing in a spreadsheet Filtering Data
when they isolate data that meets specific, exclusive
criteria?
2. Which command should an analyst use to identify FROM
which table to access in a database using a Structured
Query Language (SQL)?
3. How can an analyst sort all areas of Microsoft Excel "sort sheet"
and Google Sheets spreadsheets to organize data for
analysis?
4. Which method can an analyst use to categorize data Write a sort function
based on a specific metric in Microsoft Excel and
Google Sheets spreadsheets for data analysis?
5. An analyst needs to manipulate and categorize data Sort and Filter data
using a spreadsheet and Structured Query Language
(SQL).How can they format and adjust data for analy-
sis?
6. How does an analyst reorganize the layout of data in SORT function
Microsoft Excel or Google Sheets spreadsheets based
on product type while keeping all rows visible?
7. How does a pivot table custom list sort by default for In ascending order first
analysis?
8. An analyst is working with data in a Google Sheet Use the CONVERT function
spreadsheet that lists temperatures in Fahrenheit but
needs the data to be in Celsius.How can the analyst
change the unit of measurement?
, WGU D465
Study online at https://quizlet.com/_gom8o5
9. An analyst is working with a Microsoft Excel spread- To control the type of data
sheet that will later be shared with a project team.Why entered
would the analyst use the validation function on this
sheet?
10. An analyst wants to format all data in a column to Data will be converted to a
YYYY-MM-DD format to be represented by dates and datetime value.
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 com-
mand do to the data?
11. Why does an analyst use the LEN function in Microsoft To determine the length of
Excel and Google Sheets spreadsheets? a string
12. Why does an analyst use the CONCAT_WS function in To add two or more strings
Structured Query Language (SQL)? together with a separator
13. Which programming language can handle trillions of Structured Query Lan-
rows of data and is now a standard language for work- guage (SQL)
ing with database programs?
14. An analyst is working on a project with a lot of Create a data validation
milestones to track and wants to create a spread- menu in cells with prede-
sheet that everyone can use to track their individ- termined options
ual progress.How could the analyst sort and filter
progress milestones?
15. An analyst working with data in two different Google VLOOKUP
Sheets needs information from both spreadsheets to
connect together in a matching column on a single
sheet.Which function should the analyst use?
, WGU D465
Study online at https://quizlet.com/_gom8o5
16. An analyst working to aggregate data in databases INNER JOIN
uses a Structured Query Language (SQL) command
that returns all matching records in two tables and the
key values in each.Which command has the analyst
used?
17. An analyst working to aggregate data in databases AS
wants to create a temporary name for a table with a
complex name to make Structured Query Language
(SQL) queries simpler. Which command should the
analyst use?
18. An analyst working to aggregate data in databases FROM
uses a Structured Query Language (SQL) command
to create a temporary name for a table and receives
an ERROR message when the command is used.Which
command does the analyst use to create a temporary
name for a table?
19. An analyst working in a spreadsheet needs to deter- COUNT DISTINCT
mine the total quantity of numerical values within a
specific range that are unique.Which function should
the analyst use?
20. An analyst is working in a database and needs to use The table mentioned first
a function that will return all the records from one is on the left.
table and only the matching records from a second
table. How does the analyst determine the order of
the tables using a JOIN function?
21. An analyst is working on a spreadsheet and notices Lock the table array part of
that rows and columns that should remain unchanged the function
are changing when they are copied. This data set is
