Sunset in ur arms
New Member
- Joined
- Aug 27, 2020
- Messages
- 2
- Office Version
- 2016
- 2007
- Platform
- Windows
Hello guys,I’m new here and learning Excel.Kindly help me solve these questions.
Order Date Region Sales Rep Item Units
1/6/2019 East Jones Pencil 95
1/23/2019 Central Kivell Binder 50
2/9/2019 Central Jardine Pencil 36
2/26/2019 Central Gill Pen 27
3/15/2019 West Sorvino Pencil 56
4/1/2019 East Jones Binder 60
4/18/2019 Central Andrews Pencil 75
5/5/2019 Central Jardine Pencil 90
5/22/2019 West Thompson Pencil 32
6/8/2019 East Jones Binder 60
6/25/2019 Central Morgan Pencil 90
7/12/2019 East Howard Binder 29
7/29/2019 East Parent Binder 81
8/15/2019 East Jones Pencil 35
9/1/2019 Central Smith Desk 2
9/18/2019 East Jones Pen Set 16
10/5/2019 Central Morgan Binder 28
10/22/2019 East Jones Pen 64
11/8/2019 East Parent Pen 15
11/25/2019 Central Kivell Pen Set 96
12/12/2019 Central Smith Pencil 67
12/29/2019 East Parent Pen Set 74
1/15/2020 Central Gill Binder 46
2/1/2020 Central Smith Binder 87
2/18/2020 East Jones Binder 4
3/7/2020 West Sorvino Binder 7
3/24/2020 Central Jardine Pen Set 50
4/10/2020 Central Andrews Pencil 66
4/27/2020 East Howard Pen 96
5/14/2020 Central Gill Pencil 53
5/31/2020 Central Gill Binder 80
6/17/2020 Central Kivell Desk 5
7/4/2020 East Jones Pen Set 62
7/21/2020 Central Morgan Pen Set 55
8/7/2020 Central Kivell Pen Set 42
8/24/2020 West Sorvino Desk 3
9/10/2020 Central Gill Pencil 7
9/27/2020 West Sorvino Pen 76
10/14/2020 West Thompson Binder 57
10/31/2020 Central Andrews Pencil 14
11/17/2020 Central Jardine Binder 11
12/4/2020 Central Jardine Binder 94
12/21/2020 Central Andrews Binder 28
Given that the cost of the items as : Pencil 10; Binder 250; Pen 150; Penset 600; and Desk 3000.
Perform the under listed tasks
1. Produce total sales report per region and produce a graphic representation of the same.
2. Graphical representation of the item with the highest overall sales
3. Graphic representation of the product with the highest sales per region
4. Person with the minimum sales in a single date
Order Date Region Sales Rep Item Units
1/6/2019 East Jones Pencil 95
1/23/2019 Central Kivell Binder 50
2/9/2019 Central Jardine Pencil 36
2/26/2019 Central Gill Pen 27
3/15/2019 West Sorvino Pencil 56
4/1/2019 East Jones Binder 60
4/18/2019 Central Andrews Pencil 75
5/5/2019 Central Jardine Pencil 90
5/22/2019 West Thompson Pencil 32
6/8/2019 East Jones Binder 60
6/25/2019 Central Morgan Pencil 90
7/12/2019 East Howard Binder 29
7/29/2019 East Parent Binder 81
8/15/2019 East Jones Pencil 35
9/1/2019 Central Smith Desk 2
9/18/2019 East Jones Pen Set 16
10/5/2019 Central Morgan Binder 28
10/22/2019 East Jones Pen 64
11/8/2019 East Parent Pen 15
11/25/2019 Central Kivell Pen Set 96
12/12/2019 Central Smith Pencil 67
12/29/2019 East Parent Pen Set 74
1/15/2020 Central Gill Binder 46
2/1/2020 Central Smith Binder 87
2/18/2020 East Jones Binder 4
3/7/2020 West Sorvino Binder 7
3/24/2020 Central Jardine Pen Set 50
4/10/2020 Central Andrews Pencil 66
4/27/2020 East Howard Pen 96
5/14/2020 Central Gill Pencil 53
5/31/2020 Central Gill Binder 80
6/17/2020 Central Kivell Desk 5
7/4/2020 East Jones Pen Set 62
7/21/2020 Central Morgan Pen Set 55
8/7/2020 Central Kivell Pen Set 42
8/24/2020 West Sorvino Desk 3
9/10/2020 Central Gill Pencil 7
9/27/2020 West Sorvino Pen 76
10/14/2020 West Thompson Binder 57
10/31/2020 Central Andrews Pencil 14
11/17/2020 Central Jardine Binder 11
12/4/2020 Central Jardine Binder 94
12/21/2020 Central Andrews Binder 28
Given that the cost of the items as : Pencil 10; Binder 250; Pen 150; Penset 600; and Desk 3000.
Perform the under listed tasks
1. Produce total sales report per region and produce a graphic representation of the same.
2. Graphical representation of the item with the highest overall sales
3. Graphic representation of the product with the highest sales per region
4. Person with the minimum sales in a single date