Data Applications D465 -PA
Study online at https://quizlet.com/_g623z7
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 analysis?
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?
, Data Applications D465 -PA
Study online at https://quizlet.com/_g623z7
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 command 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 mile- Create a data validation
stones to track and wants to create a spreadsheet that menu in cells with prede-
everyone can use to track their individual progress. termined options
How could the analyst sort and filter progress mile-
stones?
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?
Study online at https://quizlet.com/_g623z7
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 analysis?
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?
, Data Applications D465 -PA
Study online at https://quizlet.com/_g623z7
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 command 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 mile- Create a data validation
stones to track and wants to create a spreadsheet that menu in cells with prede-
everyone can use to track their individual progress. termined options
How could the analyst sort and filter progress mile-
stones?
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?
