Excel Certification Exam
Questions with Correct
Solutions||100% Guaranteed
Pass!!||Updated 2025/2026
Syllabus||Already
Graded!!||<<Newest Version>>
What is the exact match command, which you will use when using the
VLOOKUP() function? - ANSWER ✓ FALSE
What is one requirement for using the TRUE command when using the
VLOOKUP() function? - ANSWER ✓ Data in the table must be sorted.
When merging two tables, what data would be included in an Outer Join? -
ANSWER ✓ All data from both tables
The first step in using Power Query is to turn your data table into an Excel table.
How do you do this step? - ANSWER ✓ Press the <Ctrl> + T key combination.
All of the following statements regarding the Power Query tool in Excel are true
EXCEPT: - ANSWER ✓ Power Query works only if the tables getting merged
both have the exact same number of rows with data.
What is the term used for synthesizing multiple pieces of data into a single piece
of data? - ANSWER ✓ Aggregation
What is the result of the function MIN(B17:B52)? - ANSWER ✓ The result is the
lowest value of the values in cells B17 through B52.
Pivot tables are powerful aggregation tools that first do what with the data before
aggregating? - ANSWER ✓ Sort the data in categories
, To prepare your data for creating a pivot table, the data must be "tidy." What does
it mean to have tidy data? - ANSWER ✓ Every column has a column header, and
the cells within that column contain the data indicated by that header.
Choose the best answer. Which of the following contains data that a pivot table
can help aggregate? - ANSWER ✓ 1. Average sales by day for an online clothing
business during the month of May
2. Average weight loss by gender for participants eating a keto diet vs. counting
calories
3. Total sales by product for six new products released for the summer line
Which of the following types of charts enables you to visually represent part-to-
whole relationships? - ANSWER ✓ Treemap
What is one significant difference between a bar chart and a histogram? -
ANSWER ✓ A histogram requires one set of data whereas a bar chart requires two
sets of data.
All of the following chart types can be created from within a pivot table except: -
ANSWER ✓ Scatter plot.
What is the name of an important filter in pivot tables that filters the entire
worksheet before it is ever aggregated? - ANSWER ✓ Report filter
What are slicers in a pivot table? - ANSWER ✓ Visual filters
What is data stratification? - ANSWER ✓ The process of dividing a population
into subpopulations, each of which is a group of sampling units that have similar
characteristics
What is the main reason you should consider sampling rather than polling an
entire population? - ANSWER ✓ You do not have available resources to poll the
entire population.
What is a probability distribution? - ANSWER ✓ The mathematical function that
provides the chance that each of several possible outcomes will occur
Questions with Correct
Solutions||100% Guaranteed
Pass!!||Updated 2025/2026
Syllabus||Already
Graded!!||<<Newest Version>>
What is the exact match command, which you will use when using the
VLOOKUP() function? - ANSWER ✓ FALSE
What is one requirement for using the TRUE command when using the
VLOOKUP() function? - ANSWER ✓ Data in the table must be sorted.
When merging two tables, what data would be included in an Outer Join? -
ANSWER ✓ All data from both tables
The first step in using Power Query is to turn your data table into an Excel table.
How do you do this step? - ANSWER ✓ Press the <Ctrl> + T key combination.
All of the following statements regarding the Power Query tool in Excel are true
EXCEPT: - ANSWER ✓ Power Query works only if the tables getting merged
both have the exact same number of rows with data.
What is the term used for synthesizing multiple pieces of data into a single piece
of data? - ANSWER ✓ Aggregation
What is the result of the function MIN(B17:B52)? - ANSWER ✓ The result is the
lowest value of the values in cells B17 through B52.
Pivot tables are powerful aggregation tools that first do what with the data before
aggregating? - ANSWER ✓ Sort the data in categories
, To prepare your data for creating a pivot table, the data must be "tidy." What does
it mean to have tidy data? - ANSWER ✓ Every column has a column header, and
the cells within that column contain the data indicated by that header.
Choose the best answer. Which of the following contains data that a pivot table
can help aggregate? - ANSWER ✓ 1. Average sales by day for an online clothing
business during the month of May
2. Average weight loss by gender for participants eating a keto diet vs. counting
calories
3. Total sales by product for six new products released for the summer line
Which of the following types of charts enables you to visually represent part-to-
whole relationships? - ANSWER ✓ Treemap
What is one significant difference between a bar chart and a histogram? -
ANSWER ✓ A histogram requires one set of data whereas a bar chart requires two
sets of data.
All of the following chart types can be created from within a pivot table except: -
ANSWER ✓ Scatter plot.
What is the name of an important filter in pivot tables that filters the entire
worksheet before it is ever aggregated? - ANSWER ✓ Report filter
What are slicers in a pivot table? - ANSWER ✓ Visual filters
What is data stratification? - ANSWER ✓ The process of dividing a population
into subpopulations, each of which is a group of sampling units that have similar
characteristics
What is the main reason you should consider sampling rather than polling an
entire population? - ANSWER ✓ You do not have available resources to poll the
entire population.
What is a probability distribution? - ANSWER ✓ The mathematical function that
provides the chance that each of several possible outcomes will occur
