List step by step on how to fill out on excel

BA Exam Question 3: Bank Customers The table in the next worksheet entitled "PivotTable Data" shows information about 400 bank customers Instructions: Create a PivotTable to analyze the distribution of customers by AverageBalance and Age Add a PivotChart HINTS: Use Average Balance as ROWS (grouped by $2,000 starting with $0 ) Use Age as COLUMNS (grouped by 20 years starting with 21 years) Use Count of CustomerID as VALUES Use the created Pivot Table to answer the following questions: 1. How many customers have the Average Balance larger than $2,000 ? 2. How many customers are older than 60 years? 3. How many old customers (more than 60 years old) have the Average Balance larger than $2,000