DATA Quiz Test

Why should you only request access to the data you need?

Select an answer:

Why is it important to note where your source data comes from?

Select an answer:

Which function is used to create aggregated datasets in Power Query?

Select an answer:

What is a benefit of maintaining your original data?

Select an answer:

Which function in Excel determines what happens if a condition is true or false?

Select an answer:

If you learn Power Query in Excel, in which other platform will you also know how to use it?

Select an answer:

Where can you go for assistance and examples regarding a program's syntax?

Select an answer:

Which two basic SQL statements are needed for a select query?

Select an answer:

When you develop data for other people, you should ensure the copy that you are providing them is _____.

Select an answer:

Who is most likely responsible for processing, visualizing, and reporting from data to improve a business?

Select an answer:

ETL, a critical process of data warehousing, stands for which three words?

Select an answer:

Which data has a type?

Select an answer:

When you edit and clean a macro in Excel, you can also learn more about which programming language?

Select an answer:

Which tool in Excel lets you import or connect to external data, and then shape and analyze that data in ways that meet your needs?

Select an answer:

At what level of an organization do you find the key area of data?

Select an answer:

When you connect directly to the data, when does the data in your file get updated?

Select an answer:

If your company says that you are not allowed to access existing data, what should you do?

Select an answer:

When using queries to model your data, what else will you leverage to create the datasets you need?

Select an answer:

On the Home tab in Power Query, what should you select if you want to merge your two datasets into one?

Select an answer:

What is an example of cleaning data?

Select an answer:

What is the biggest advantage of working with reusable datasets?

Select an answer:

You are starting a new data project. What is one of the best sources to help you begin?

Select an answer:

How do you combine fields in Power Query?

Select an answer:

If you are joining data with queries, what must you know in order to validate your dataset?

Select an answer:

In Excel, what is the difference between "count" and "numerical count"?

Select an answer:

In Excel, what is the difference between "count" and "numerical count"?

Select an answer:

What is an example of a logical function?

Select an answer:

When you add two tables to a query window and you do not have a join type selected, what is created?

Select an answer:

Which tool can you use to find duplicates in Excel?

Select an answer:

If you want to change a selected column from lowercase to uppercase, what should you select?

Select an answer:

When you have a lot of ground to cover in a meeting, what can you use to stay on track?

Select an answer:

What does Power Query use to change to what it determines is the appropriate data type?

Select an answer:

 Combining the definitions of three words describes a data analyst. What are the three words?

Select an answer:

Combining the definitions of three words describes a data analyst. What are the three words?

Select an answer: