Question

How can you filter the Profits worksheet to display only flavors with a cost that is above the average cost?

a) Use the "Sort and Filter" option and select "Above Average"
b) Manually hide rows with below-average costs
c) Apply a filter to the "Cost" column and choose "Above Average"
d) Use conditional formatting to highlight above-average

Answer 1

To display only the flavors with a cost above the average on a Profits worksheet, apply a filter to the 'Cost' column and select the 'Above Average' option in the data filtering features of spreadsheet software like Microsoft Excel.

Step-by-step explanation:

The question is asking how to filter data in a Profits worksheet to show only the flavors that have a cost above the average cost. Among the options provided, the correct answer is to apply a filter to the "Cost" column and choose "Above Average". This is typically done through the data filtering features in spreadsheet software like Microsoft Excel.

First, you would ensure that your dataset is organized in a table format with clearly labeled columns for each category - such as 'output', 'total cost', 'marginal cost', 'average cost', 'variable cost', and 'average variable cost'. Once your table is set up, you would go to the 'Data' tab in Excel, and then use the 'Sort & Filter' group to select 'Filter'. Clicking on the dropdown menu in the "Cost" column header, you would then select the 'Number Filters' option, followed by 'Above Average', which will automatically filter out any entries where the cost is not above the average cost for the dataset.