excel question 3

Sales Orders-Instructions

INSTRUCTIONS
Add a column after Price per Unit called "Total Sales"
Change the format of the Total Sales to Currency without "$" and 2 decimals
Make the Title Row BOLD
Right justify all columns and adjust widths to show full cell contents
Make five new tabs making copies of this data set and label Sales Orders 1, Sales Orders 2, Sales Orders 3…Sales Orders 5
Sales Orders 1
Add Total Row to bottom of data set and use SUM function to find Total Sales
Sort the data by Region and then by Quantity in Descending Order
Sales Orders 2
Convert data to Table
Add Total Row to Table
Use the Filter Button to filter by Order Date and include orders from January - June 2019 only
Question: Which January through June period sold more- 2018 or 2019?
Sales Orders 3
Calculate the following:		Total Sales for East Region
Use the Sort or Filter Method
Use the Sumif Formula
Use the Sumif Formula with an INPUT cell
Sales Orders 4
Calculate the following:		Total Sales for Pens in Central Region
Use Sumif Formula with two input cells
Tip: Use filter to check your answer
Sales Orders 5
Calculate the following:		Number of times sales were over $500
Use the Sort or Filter Method
Use the Countif Formula
Use theCountif Formula with an INPUT cell
Question: Which region has had the most Total Sales?

Sales Orders- Data

Order Date	Region	Rep Name	Item Name	Quantity	Price per Unit
1/23/18	Central	Kivell	Binder	50	19.99
4/1/18	East	Jones	Binder	60	4.99
6/8/18	East	Jones	Binder	60	8.99
7/12/18	East	Howard	Binder	29	1.99
7/29/18	East	Parent	Binder	81	19.99
10/5/18	Central	Morgan	Binder	28	8.99
1/15/19	Central	Gill	Binder	46	8.99
2/1/19	Central	Smith	Binder	87	15.00
2/18/19	East	Jones	Binder	4	4.99
3/7/19	West	Sorvino	Binder	7	19.99
5/31/19	Central	Gill	Binder	80	8.99
10/14/19	West	Thompson	Binder	57	19.99
11/17/19	Central	Jardine	Binder	11	4.99
12/4/19	Central	Jardine	Binder	94	19.99
12/21/19	Central	Andrews	Binder	28	4.99
9/1/18	Central	Smith	Desk	2	125.00
6/17/19	Central	Kivell	Desk	5	125.00
8/24/19	West	Sorvino	Desk	3	275.00
2/26/18	Central	Gill	Pen	27	19.99
10/22/18	East	Jones	Pen	64	8.99
11/8/18	East	Parent	Pen	15	19.99
4/27/19	East	Howard	Pen	96	4.99
9/27/19	West	Sorvino	Pen	76	1.99
9/18/18	East	Jones	Pen Set	16	15.99
11/25/18	Central	Kivell	Pen Set	96	4.99
12/29/18	East	Parent	Pen Set	74	15.99
3/24/19	Central	Jardine	Pen Set	50	4.99
7/4/19	East	Jones	Pen Set	62	4.99
7/21/19	Central	Morgan	Pen Set	55	12.49
8/7/19	Central	Kivell	Pen Set	42	23.95
1/6/18	East	Jones	Pencil	95	1.99
2/9/18	Central	Jardine	Pencil	36	4.99
3/15/18	West	Sorvino	Pencil	56	2.99
4/18/18	Central	Andrews	Pencil	75	1.99
5/5/18	Central	Jardine	Pencil	90	4.99
5/22/18	West	Thompson	Pencil	32	1.99
6/25/18	Central	Morgan	Pencil	90	4.99
8/15/18	East	Jones	Pencil	35	4.99
12/12/18	Central	Smith	Pencil	67	1.29
4/10/19	Central	Andrews	Pencil	66	1.99
5/14/19	Central	Gill	Pencil	53	1.29
9/10/19	Central	Gill	Pencil	7	1.29
10/31/19	Central	Andrews	Pencil	14	1.29