Skip to content
Layer 1
Ask Questions
  • Arts
  • Business ▾
    • Leadership And Managemnet
  • Computer Science ▾
    • Design and Product
  • Data Science ▾
    • Data Analysis
    • Machine Learning
  • Engineering
  • Information Technology
Quizerry
  • Business
  • Data Science
  • Computer Science
  • Engineering

Data Analysis

Data analysis courses address methods for managing and analyzing large datasets. Start your career as a data scientist by studying data
mining, big data applications, and data product development.

Layer 1

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?

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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?

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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?

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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?

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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?

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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.

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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.

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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?

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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?

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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?

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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?

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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?

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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?

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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?

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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.

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

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

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

You are working with a database that contains invoice data about online music purchases. You are only interested in invoices sent to customers located in the city of Paris. You want to sort the invoices by order total in ascending order. The order totals are listed in the total column.

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Layer 1

A data analyst uses a function to sort a spreadsheet range between cells H1 and K65. They sort in ascending order by the first column, Column H. What is the syntax they are using?

Layer 1 View Answers
Layer 1 Ask Question
Data Analysis Data Science Questions

Post navigation
Older posts
Newer posts
← Previous Page1 … Page5 Page6 Page7 … Page27 Next →
+ Load More Questions

Recent Q&A

  • As a project manager, you’re trying to take all the right steps to prepare for the project. What steps should you take? Select all that apply.
  • Project managers should follow which three best practices when assigning tasks to complete milestones?
  • When assigning tasks to team members, what two factors should you mainly consider?
  • Fill in the blank: During the planning phase of a project, you take steps that help you _____ to achieve your project goals.
  • Fill in the blank: After the stakeholders assign the project manager, the goals of the project have to be approved, as well as the scope of the project and its _____.
About Us | Advertise With Us | Quizerry | Privacy Policy | Contact Us
Next Page »
  • Business
  • Data Science
  • Computer Science
  • Engineering