Data Analytics

In Excel, what is the difference between "count" and "numerical count"? Correct answer "Count" will count everything, including text and numbers, while "numerical count" will count only numbers. "Count" will count only text, while "numerical count" will count only numbers. Attempted incorrect option There is no difference between "count" and "numerical count," and they can be used interchangeably.

"Count" will count everything, including text and numbers, while "numerical count" will count only numbers.

Which tool can you use to find duplicates in Excel? Flash Fill VLOOKUP Attempted correct option Conditional Formatting Concatenation

Conditional Formating

If your company says that you are not allowed to access existing data, what should you do? Create your own data. Attempted correct option Follow company rules. Access any data you can on your own.

Follow company rules.

Which function in Excel determines what happens if a condition is true or false? MATCH INT Attempted correct option IF NOT

IF

On the Home tab in Power Query, what should you select if you want to merge your two datasets into one? Merge Datasets as New Merge Datasets Merge Queries as New Attempted correct option Merge Queries

Merge Queries

If you learn Power Query in Excel, in which other platform will you also know how to use it? Metabase Google Data Studio Attempted correct option Power BI Superset

Power BI

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? Tableau Desktop Attempted correct option Power Query Visual Basic Editor

Power Query

Which two basic SQL statements are needed for a select query? SELECT and ORDER BY SELECT and WHERE Attempted correct option SELECT and FROM

SELECT and FROM

What is an example of a logical function? the all function Attempted correct option the IF function the sum function

The IF function

If you want to change a selected column from lowercase to uppercase, what should you select? Replace Values Change Type Attempted correct option Transform

Transform

How do you combine fields in Power Query? Use the concatenate function. Use the VLOOKUP function. Use Conditional Column. Attempted correct option Use Merge Columns on the fields.

Use Merge Columns on the fields.

When you edit and clean a macro in Excel, you can also learn more about which programming language? Attempted correct option VBA Perl Java Python

VBA

What is a benefit of maintaining your original data? Cleanup is remembered for future projects. Changes are automatically saved. Attempted correct option You are provided with an audit trail.

You are provided with an audit trail.

When you add two tables to a query window and you do not have a join type selected, what is created? Attempted incorrect option an inner join a right outer join Correct answer a cross join a left outer join

a cross join

Who is most likely responsible for processing, visualizing, and reporting from data to improve a business? Attempted correct option a data analyst a data engineer a data architect

a data analyst

When you have a lot of ground to cover in a meeting, what can you use to stay on track? sticky notes Attempted incorrect option a timer note cards Correct answer a slide deck

a slide deck

Which data has a type? Attempted correct option all data data with numbers data with text data with strings

all data

Combining the definitions of three words describes a data analyst. What are the three words? Attempted incorrect option analysis, analyze, and technology data, programs, and analysis analyze, data, and programs Correct answer data, analysis, and analyze

data, analysis, and analyze

When you develop data for other people, you should ensure the copy that you are providing them is _____. Correct answer disconnected from that data Attempted incorrect option connected to that data saved as a flat file

disconnected from that data

At what level of an organization do you find the key area of data? Attempted correct option every level the end-user level the top level the bottom level

every level

You are starting a new data project. What is one of the best sources to help you begin? Attempted incorrect option technical documentation queries the database Correct answer existing reports

existing reports

ETL, a critical process of data warehousing, stands for which three words? extract, transcribe, and leverage enter, translate, and leverage enter, transform, and leave Attempted correct option extract, transform, and load

extract, transform, and load

What is the biggest advantage of working with reusable datasets? It provides automated updates. It protects against viruses. Attempted correct option It saves time. It reduces errors.

it saves time

When using queries to model your data, what else will you leverage to create the datasets you need? source data flat files Attempted correct option joins and join types

joins and join types

What is an example of cleaning data? building pivots Attempted correct option removing unnecessary columns connecting the data in the database

removing unnecessary columns

Why is it important to note where your source data comes from? Correct answer so you have a path to follow if something is off in your data Attempted incorrect option so you can have the source data file at hand even when changes are made so you are in data governance compliance

so you have a path to follow if something is off in your data

Which function is used to create aggregated datasets in Power Query? the Group function Attempted correct option the Group By function the sort function

the Group By function

Where can you go for assistance and examples regarding a program's syntax? a friend the help desk Attempted correct option the Help menu

the Help menu

What does Power Query use to change to what it determines is the appropriate data type? the headers Attempted correct option the first real row of data data in the formula bar

the first real row of data

If you are joining data with queries, what must you know in order to validate your dataset? Correct answer the record counts Attempted incorrect option whether duplicated data exists the field headings

the record counts

Why should you only request access to the data you need? to save on costs for the company to prevent copyright infringements Attempted correct option to protect yourself and your organization

to protect yourself and your organization

When you connect directly to the data, when does the data in your file get updated? when your company runs its regular software updates Attempted correct option when the data and the source system are updated when you are given an updated file

when the data and the source system are updated