DATA ANALYTICS EXAM 2025
QUESTIONS AND ANSWERS
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 - ANS data, analysis, and analyze
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 - ANS 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?
sticky notes
Attempted incorrect option
a timer
note cards
Correct answer
a slide deck - ANS a slide deck
Copyright ©2025 BRIGHTSTARS ALL RIGHTS RESERVED 1
, If you want to change a selected column from lowercase to uppercase, what should you select?
Replace Values
Change Type
Attempted correct option
Transform - ANS Transform
Which tool can you use to find duplicates in Excel?
Flash Fill
VLOOKUP
Attempted correct option
Conditional Formatting
Concatenation - ANS Conditional Formating
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 - ANS a cross join
What is an example of a logical function?
the all function
Attempted correct option
the IF function
the sum function - ANS The IF function
In Excel, what is the difference between "count" and "numerical count"?
Copyright ©2025 BRIGHTSTARS ALL RIGHTS RESERVED 2
QUESTIONS AND ANSWERS
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 - ANS data, analysis, and analyze
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 - ANS 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?
sticky notes
Attempted incorrect option
a timer
note cards
Correct answer
a slide deck - ANS a slide deck
Copyright ©2025 BRIGHTSTARS ALL RIGHTS RESERVED 1
, If you want to change a selected column from lowercase to uppercase, what should you select?
Replace Values
Change Type
Attempted correct option
Transform - ANS Transform
Which tool can you use to find duplicates in Excel?
Flash Fill
VLOOKUP
Attempted correct option
Conditional Formatting
Concatenation - ANS Conditional Formating
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 - ANS a cross join
What is an example of a logical function?
the all function
Attempted correct option
the IF function
the sum function - ANS The IF function
In Excel, what is the difference between "count" and "numerical count"?
Copyright ©2025 BRIGHTSTARS ALL RIGHTS RESERVED 2
