Data Analysis Required

Questions to be answered from provided data spreadsheet:

Column A: Identification number – each row represents a unique customer
Column B: How many propositions does that customer have
Column C: Total that the customer has spent on their product in the last 6 months
Column D: Total that the customer has spent on their product in the last 6 months 12 months
Column E: 1 if they are enrolled in the Digital Product ABC and 0 if they are not
Column F: 1 if they are actively engaged (logging in once in the last 12 months) in the Digital Product ABC and 0 if they are not
Column G: Tells you with segment the customer is (Micro, Middle, Regional are the three types of customer segment)

Ideally, I need:
A chart showing the distribution of Digital Product ABC Enrolled Micro customers by number of cards in force, e.g., there are 2544 Micro customers with 1 card, 2486 Micro customers with 2 cards, etc…
A chart showing how many of those customers are active in Digital Product ABC (can be same chart or a new one)
A chart showing total spent for each card level (can be same chart or a new one)