The table contains information of 500 employees of a company. You are asked to represent information from the data based on the following instructions:

Create a column Sales Class where the value is A if an employees sales are greater or equal to 4000, B if sales are less than 4000 but greater or equal to 2000, and C if sales are less than 2000.

Create a column for commission, where an employee gets a 10% commission if their sales class is A, 5% if it is B, and 1% if it is C.

Color the Commission column based on its values. (Use conditional formatting.)

Calculate their total salary

The company has 4 different branches (Dhanmondi, Banani, Gulshan, and Uttara). Find the sales class distribution over these branches and show them in a bar chart.

Find the Gender proportion in the company and display it using a pie chart.

DATA EXAMPLE