PLS 021 Quiz 4

Veterinary

Create a Pivot Table on a new worksheet based on this data. Find the Average of Cost by Operation for Month 5. Which operation had the highest average cost?

1267

We no longer need the previous Pivot Table. Clear the fields and filters from the Pivot Table Builder. Now find the Sum of Operation hours for Operator: Carlos Perez, Cattle Type: Jersey during the Year 2019. ___ (Round to two decimal places, if needed)

Cheese

Clear the fields and filters from the Pivot Table Builder. Create a new pivot table and find which product (butter, cheese, cream, milk, and yogurt) incurred the highest Sum of Cost ___

True

Filtering can be used to display only data that matches specific conditions.

False

When naming a cell, or range of cells, you can have spaces in between the words of the name.

CTRL + Shift + Enter

What keys did you press to execute the array formula in question 4? (Order of Key matters)
4. In B8:G8, calculate the Average Total Meal Cost for each restaurant by creating an array formula to fill the entire range. Average Total Meal Cost = ((cheapest + expensive)/2) + tip