Data Analytics Foundations Questions and Answers
2024
An "Orders" table has 30 columns, and the report only needs the order total by date.
Which transformation should you perform? *** Remove the other columns. Group by
using the date column and aggregate the appropriate total field.
You're creating a PivotTable and a number field titled "ProductID" defaults to the SUM
aggregate function. Which transformation can you apply so that it defaults to COUNT
instead of SUM? *** Change the value to COUNT in the Value Field Settings.
Combining the definitions of three words describes a data analyst. What are the three
words? *** data, analysis, and analyze
What does Power Query use to change to what it determines is the appropriate data
type? *** the first real row of data
When you have a lot of ground to cover in a meeting, what can you use to stay on
track? *** Correct answer
a slide deck
If you want to change a selected column from lowercase to uppercase, what should you
select? *** Transform
Which tool can you use to find duplicates in Excel? *** Attempted correct option
Conditional Formatting
When you add two tables to a query window and you do not have a join type selected,
what is created? *** a cross join
What is an example of a logical function?
Select an answer:
the all function
the IF function
the sum function *** the IF Function
In Excel, what is the difference between "count" and "numerical count"? *** "Count"
will count everything, including text and numbers, while "numerical count" will count only
numbers.
If you are joining data with queries, what must you know in order to validate your
dataset? *** the record counts
Contact for help with assignments and revision materials
2024
An "Orders" table has 30 columns, and the report only needs the order total by date.
Which transformation should you perform? *** Remove the other columns. Group by
using the date column and aggregate the appropriate total field.
You're creating a PivotTable and a number field titled "ProductID" defaults to the SUM
aggregate function. Which transformation can you apply so that it defaults to COUNT
instead of SUM? *** Change the value to COUNT in the Value Field Settings.
Combining the definitions of three words describes a data analyst. What are the three
words? *** data, analysis, and analyze
What does Power Query use to change to what it determines is the appropriate data
type? *** the first real row of data
When you have a lot of ground to cover in a meeting, what can you use to stay on
track? *** Correct answer
a slide deck
If you want to change a selected column from lowercase to uppercase, what should you
select? *** Transform
Which tool can you use to find duplicates in Excel? *** Attempted correct option
Conditional Formatting
When you add two tables to a query window and you do not have a join type selected,
what is created? *** a cross join
What is an example of a logical function?
Select an answer:
the all function
the IF function
the sum function *** the IF Function
In Excel, what is the difference between "count" and "numerical count"? *** "Count"
will count everything, including text and numbers, while "numerical count" will count only
numbers.
If you are joining data with queries, what must you know in order to validate your
dataset? *** the record counts
Contact for help with assignments and revision materials
