NEW
Font size
WorksheetsExcel Post-Assessment 3
Total questions: 10
Worksheet time: 5mins
What is the primary purpose of Power Query in Excel?
To create complex formulas
To connect, clean, transform, and load data from various sources
To perform statistical analysis
To design pivot table layouts
After performing transformations in the Power Query Editor, what must you do to apply changes to your Excel worksheet?
Save the file
Click "Close & Apply"
Refresh all connections
Copy the M code
When you unpivot a table in Power Query, what are you typically doing?
Converting rows into columns
Converting columns into rows to create a normalised data structure
Deleting unnecessary columns
Aggregating numerical data
Which area of a Pivot Table Field List is used to display data as a total or subtotal at the end of a row?
Filters
Columns
Rows
Values
You want to show your sales data as a percentage of the column total for each region. Which Pivot Table value setting do you use?
Show Values As → % of Row Total
Show Values As → % of Parent Row Total
Show Values As → % of Grand Total
Show Values As → % of Column Total
What is the key difference between a Pivot Table and a standard Excel table?
Pivot Tables can only use numeric data
Pivot Tables dynamically summarise and aggregate data without formulas
Standard tables have more formatting options
There is no significant difference
You have a Pivot Table showing monthly sales for two product lines over a year. Which chart type is often least effective for this comparison?
Clustered Column Chart
Line Chart
Pie Chart
Combo Chart (Column and Line)
When you create a chart from a Pivot Table, what feature allows you to filter the chart data directly from the chart itself?
Chart Styles
PivotChart Filter Pane (with field buttons)
Data Validation
The "Select Data" dialog box
Which combination is ideal for visualising actual values vs. a target (e.g., monthly sales vs. a fixed quota line)?
Stacked Bar Chart
Clustered Column Chart with a Target Line (often using a Combo Chart)
3-D Pie Chart
Scatter Plot
What is the recommended workflow for creating a dynamic report in Excel?
Create Charts first, then Pivot Table, then get data
Get and clean data with Power Query → Create Pivot Table → Build PivotChart
Type data manually into a worksheet and then build formulas
Create a Pivot Table from raw, uncleaned data and then format it
