Quizerry - Study Smarter Not Harder

You are using a spreadsheet to organize a list of upcoming home repairs. Column A contains the list of repairs, and column B notes the priority of each item on the list: High Priority or Low Priority. What spreadsheet tool can you use to create a drop-down list of priorities for each cell in column B?

View Answers

Ask Question

Data Analysis Data Science Questions

You are using a spreadsheet to keep track of your newspaper subscriptions. You add color to indicate if a subscription is current or has expired. Which spreadsheet tool changes how cells appear when values meet each expiration date?

View Answers

Ask Question

Data Analysis Data Science Questions

You are working with a SQL database with tables for delivery routes in California. The table contains one column with the names of the pick-up locations. A different column in the same table contains the names of the drop-off locations. To create a new column that stores the combination of the pick-up and drop-off location names, which function do you use?

View Answers

Ask Question

Data Analysis Data Science Questions

A data analyst is working with a spreadsheet that has very long text strings. They use a function to count the number of characters in cell G11. What is the correct syntax?

View Answers

Ask Question

Data Analysis Data Science Questions

A data analyst at a symphony orchestra uses a spreadsheet to keep track of how many concerts require more than 80 musicians. They use a spreadsheet tool to change how cells appear when values equal 80 or more. What tool are they using?

View Answers

Ask Question

Data Analysis Data Science Questions

When working with a spreadsheet, data analysts can use the WHERE function to locate specific characters in a string.

View Answers

Ask Question

Data Analysis Data Science Questions

You are analyzing data about the capitals of different countries. In your SQL database, you have one column with the names of the countries and another column with the names of the capitals. What function can you use in your query to combine the countries and capitals into a new column?

View Answers

Ask Question

Data Analysis Data Science Questions

You are querying a database of museums to determine which ones will have a sculpture exhibit this year. For your project, you only need the first 50 records. What clause should you add to the following SQL query?

View Answers

Ask Question

Data Analysis Data Science Questions

Fill in the blank: A data analyst is working with a spreadsheet that has very long text strings. They use the LEN function to count the number of _____ in the text strings.

View Answers

Ask Question

Data Analysis Data Science Questions

Spreadsheet cell L6 contains the text string “Function”. To return the substring “Fun”, what is the correct syntax?

View Answers

Ask Question

Data Analysis Data Science Questions

An analyst notes that their data is formatted as Euros, but it should be formatted as pesos. What spreadsheet tool can help them select the right format?

View Answers

Ask Question

Data Analysis Data Science Questions

You are preparing a project tracker spreadsheet. Next to each project task, you need to add the name of the team member responsible. What spreadsheet tool will save you time by enabling you to create a drop-down list with team members’ names as the possible options?

View Answers

Ask Question

Data Analysis Data Science Questions

When working with a spreadsheet, data analysts use the find function to locate specific characters in a string. Find is case-sensitive, so it’s necessary to input the substring exactly how it appears.

View Answers

Ask Question

Data Analysis Data Science Questions

You are querying a database of ice cream flavors to determine which stores are selling the most mint chip. For your project, you only need the first 80 records. What clause should you add to the following SQL query?

View Answers

Ask Question

Data Analysis Data Science Questions

An analyst working for a British school system just downloaded a dataset that was created in the United States. The numerical data is correct but it is formatted as U.S. dollars, and the analyst needs it to be in British pounds. What spreadsheet tool can help them select the right format?

View Answers

Ask Question

Data Analysis Data Science Questions

A data analyst is working with a spreadsheet that has very long text strings. Rather than counting the characters themselves to determine the number of characters they contain, what tool can they use?

View Answers

Ask Question

Data Analysis Data Science Questions

Spreadsheet cell E13 contains the text string “Database”. To return the substring “Data”, what is the correct syntax?

View Answers

Ask Question

Data Analysis Data Science Questions

You are querying a database of keynote speakers to determine who has expertise in zoology. For your project, you only need the first 12 records. What clause should you add to the following SQL query?

View Answers

Ask Question

Data Analysis Data Science Questions

Fill in the blank: When working with a spreadsheet, data analysts can use the _____ function to locate specific characters in a string.

View Answers

Ask Question

Data Analysis Data Science Questions

A data analyst at a symphony orchestra uses a spreadsheet to keep track of how many concerts require more than 80 musicians. They use a spreadsheet tool to change how cells appear when values equal 80 or more. What tool are they using?

View Answers

Ask Question

Data Analysis Data Science Questions

In the data analysis process, which of the following refers to a phase of analysis? Select all that apply.

View Answers

Ask Question

Data Analysis Data Science Questions

Fill in the blank: Sorting ranks data based on a specific _____ that you select.

View Answers

Ask Question

Data Analysis Data Science Questions

Which of the following actions might occur when transforming data? Select all that apply.

View Answers

Ask Question

Data Analysis Data Science Questions

A data analyst is working on a dataset and begins the transform data phase of analysis. What are some of the actions that they will take? Select all that apply.

View Answers

Ask Question

Data Analysis Data Science Questions

+ Load More Questions

Study Smarter Not Harder

Get Commonly Asked Questions Answer From One Place

Arts

Business

Computer Science

Data Science

Engineering

Information Technology

You are using a spreadsheet to keep track of your newspaper subscriptions. You add color to indicate if a subscription is current or has expired. Which spreadsheet tool changes how cells appear when values meet each expiration date?

A data analyst is working with a spreadsheet that has very long text strings. They use a function to count the number of characters in cell G11. What is the correct syntax?

A data analyst at a symphony orchestra uses a spreadsheet to keep track of how many concerts require more than 80 musicians. They use a spreadsheet tool to change how cells appear when values equal 80 or more. What tool are they using?

When working with a spreadsheet, data analysts can use the WHERE function to locate specific characters in a string.

You are analyzing data about the capitals of different countries. In your SQL database, you have one column with the names of the countries and another column with the names of the capitals. What function can you use in your query to combine the countries and capitals into a new column?

You are querying a database of museums to determine which ones will have a sculpture exhibit this year. For your project, you only need the first 50 records. What clause should you add to the following SQL query?

Fill in the blank: A data analyst is working with a spreadsheet that has very long text strings. They use the LEN function to count the number of _____ in the text strings.

Spreadsheet cell L6 contains the text string “Function”. To return the substring “Fun”, what is the correct syntax?

An analyst notes that their data is formatted as Euros, but it should be formatted as pesos. What spreadsheet tool can help them select the right format?

You are preparing a project tracker spreadsheet. Next to each project task, you need to add the name of the team member responsible. What spreadsheet tool will save you time by enabling you to create a drop-down list with team members’ names as the possible options?

When working with a spreadsheet, data analysts use the find function to locate specific characters in a string. Find is case-sensitive, so it’s necessary to input the substring exactly how it appears.

You are querying a database of ice cream flavors to determine which stores are selling the most mint chip. For your project, you only need the first 80 records. What clause should you add to the following SQL query?

An analyst working for a British school system just downloaded a dataset that was created in the United States. The numerical data is correct but it is formatted as U.S. dollars, and the analyst needs it to be in British pounds. What spreadsheet tool can help them select the right format?

A data analyst is working with a spreadsheet that has very long text strings. Rather than counting the characters themselves to determine the number of characters they contain, what tool can they use?

Spreadsheet cell E13 contains the text string “Database”. To return the substring “Data”, what is the correct syntax?

You are querying a database of keynote speakers to determine who has expertise in zoology. For your project, you only need the first 12 records. What clause should you add to the following SQL query?

Fill in the blank: When working with a spreadsheet, data analysts can use the _____ function to locate specific characters in a string.

A data analyst at a symphony orchestra uses a spreadsheet to keep track of how many concerts require more than 80 musicians. They use a spreadsheet tool to change how cells appear when values equal 80 or more. What tool are they using?

In the data analysis process, which of the following refers to a phase of analysis? Select all that apply.

Fill in the blank: Sorting ranks data based on a specific _____ that you select.

Which of the following actions might occur when transforming data? Select all that apply.

A data analyst is working on a dataset and begins the transform data phase of analysis. What are some of the actions that they will take? Select all that apply.