Required

Which option allows you to display the values as percentages in a pivot table? $(1$ Point$)*$

Use the "Show Values As$"$ option in value field settings and select $"\%$ of Column Total" as the calculation type

Apply the "Percentage" function from the "Formulas" tab in Excel to the value field

Use the "Percentage" tab under the "PivotTable Analyze" on the Excel ribbon

Right$-$click on the value field, select "Percentage Formatting," and choose the desired format

A bank employee needs to create a list of customers who have at least one account open at the bank. Many customers have both a checking and savings account. The bank employee exported a list, but each account is listed on a separate row so many customers are listed in the report multiple times. What functionality would the bank employee use to find the population they are looking for?

$(1$ Point$)*$