Excel & Sheets practice: Data Validation, Slicers & Pivot Reporting

In cell K2, write a formula using GETPIVOTDATA to pull the Total Revenue for the "North" region from the pivot table starting at A3.

You want to set a Data Validation rule on the Units column (column G) allowing only standard order quantities between 10 and 50 units inclusive. Test this custom validation rule formula in K2 (filled down to K21) — returning TRUE for valid order sizes and FALSE for outliers.

Write the custom validation formula for cell A2 that ensures the OrderID is unique across range $A$2:$A$21.

On Products, write a Data Validation rule formula in G2 (fill down to G8) ensuring Stock (column E) is at least the Reorder level (column F) — returning TRUE when Stock ≥ Reorder and FALSE when stock has fallen below reorder level.

You want a summary table showing total Revenue for each Rep down the rows, broken down by Category across the columns. Where should you drag the fields in the PivotTable Fields pane?

When you drag a column into the Values area, Excel automatically chooses Count instead of Sum. What causes this?

You have a Pivot Table showing Revenue by Region. You want to see each region's percentage share of overall company revenue without adding helper columns or outside formulas. Which setting provides this?

You built a dashboard with three separate Pivot Tables from the DemoACP Sales data. You insert a Region Slicer. How do you make clicking "North" filter all three Pivot Tables at once?

You create a Calculated Field named Commission with the formula =Revenue * 0.05. How does Excel evaluate this formula on a subtotal or grand total row?

When creating a custom report that references a Pivot Table, why is =GETPIVOTDATA("Revenue", $A$3, "Region", "North") more reliable than a direct cell reference like =B5?

Why is setting up in-cell Data Validation (List) on source data tables essential before building Pivot Tables?

In Excel Data Validation, which Error Alert style strictly blocks a user from entering invalid data, rather than allowing them to override it?

When is a formula-built report (UNIQUE + SUMIFS) a better choice than a pivot table?