1) Which tool can you use to find duplicates in Excel? Select an answer: Flash Fill VLOOKUP Conditional Formatting Conca

[answerhappygod]

1)
Which tool can you use to find duplicates in Excel?
Select an answer:
Flash Fill
VLOOKUP
Conditional Formatting
Concatenation
2)
What does Power Query use to change to what it determines is theappropriate data type?
Select an answer:
the headers
the first real row of data
data in the formula bar
3)
Combining the definitions of three words describes a dataanalyst. What are the three words?
Select an answer:
analysis, analyze, and technology
data, programs, and analysis
analyze, data, and programs
data, analysis, and analyze
4)
When you add two tables to a query window and you do not have ajoin type selected, what is created?
Select an answer:
an inner join
a right outer join
a cross join
a left outer join
5)
In Excel, what is the difference between "count" and "numericalcount"?
Select an 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 countonly numbers.
There is no difference between "count" and "numerical count,"and they can be used interchangeably.
6)
If you are joining data with queries, what must you know inorder to validate your dataset?
Select an answer:
the record counts
whether duplicated data exists
the field headings
7)
You are starting a new data project. What is one of the bestsources to help you begin?
Select an answer:
technical documentation
queries
the database
existing reports
8)
On the Home tab in Power Query, what should you select if youwant to merge your two datasets into one?
Select an answer:
Merge Datasets as New
Merge Datasets
Merge Queries as New
Merge Queries
9)
When using queries to model your data, what else will youleverage to create the datasets you need?
Select an answer:
source data
flat files
joins and join types
10)
When using queries to model your data, what else will youleverage to create the datasets you need?
Select an answer:
source data
flat files
joins and join types