services equal to the values in the range M$18$:M$19.$

$7.$ In cell N$24,$ create a formula using the DAVERAGE function to calculate the average sales for clients in New Jersey, using the data in the entire Sales table $($Sales$[$#AII$])$ and averaging the values in the Total Sales column $("$Total Sales"$)$ for clients in states equal to the values in the range M$22$:M$23.$

$8.$ Go to the Sales by Category worksheet. Nadia has created a PivotTable named CategoryPivot to list the sales by business category, date, and service type. The data would be easier to interpret if the dates appeared as quarter numbers. Group the Start Date field values by Quarters only. Change the report layout to Compact Form to make the PivotTable look less cluttered.