Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

How do LANs differ fromWANs and BNs?

Answered: 1 week ago