UNIT

No PRODUCT NAME QUANTITY PRICE TAX

PRICE
1 Desk with iron legs 100 4,000,000 400,000,000 20,000,000
2 Tea table 50 150,000 7,500,000 375,000
3 3-tier shelf with many compartments 58 1,200,000 69,600,000 3,480,000
4 5-tier shelf 79 850,000 67,150,000 3,357,500
5 Vintage cabinet with 1 drawer 92 200,000 18,400,000 920,000
6 Vintage cabinet with 3 drawers 220 2,500,000 550,000,000 27,500,000
7 Blue and white cabinet with 2 high drawers 199 600,000 119,400,000 5,970,000
TOTAL: 1,232,050,000 61,602,500

1) Automatically number in column No

2) Format the UNIT PRICE column with a thousands separator

3) PRICE = QUANTITY * UNIT PRICE

4) TAX = PRICE * 5%

5) FREIGHT COST = QUANTITY* 1500

6) Calculate the total of the columns PRICE, TAX, FREIGHT COST and TOTAL

7) Date: Use the function to get the current day, month, and year

8) Present the spreadsheet

FREIGHT
TOTAL
COST
150,000 420,150,000
75,000 7,950,000
87,000 73,167,000
118,500 70,626,000
138,000 19,458,000
330,000 577,830,000
298,500 125,668,500
1,197,000 1,294,849,500
No Full Name Surname Middle Name

1 Doan Van An Doan Van

2 Hoang Thi Van Anh Hoang Thi Van
3 Tran Quang Anh Tran Quang
4 Nguyen Thi Ngoc Bich Nguyen Thi Ngoc
5 Dang Thi Thu Ha Dang Thi Thu
6 Phan Thu Hang Phan Thu
7 Ngo Viet Hoang Ngo Viet
8 Bui Thi Minh Huong Bui Thi Minh
9 Dao Thuy Huong Dao Thuy
10 Dao Thi Huyen Dao Thi
11 Le Phuong Nam Le Phuong
12 Nguyen Van Son Nguyen Van
13 Ho Tan Tai Ho Tan
14 Le Thi Thanh Le Thi
15 Tran Van The Tran Van
16 Nguyen Thi Thu Nguyen Thi
17 Vu Thi Mai Trinh Vu Thi Mai
18 Pham Van Tuan Pham Van
 Basic Working Position Total
First Name Position Advance
Salary days allowance Salary
An TP 3,000 25 300 75000 25000
Anh KT 1,200 28 250 33600 23000
Anh KT 1,200 28 250 33600 23000
Bich NV 1,000 26 100 26000 17000
Ha NV 1,000 24 100 24000 16000
Hang BV 800 30 100 24000 16000
Hoang NV 1,000 26 100 26000 17000
Huong NV 1,000 26 100 26000 17000
Huong NV 1,000 26 100 26000 17000
Huyen NV 1,000 26 100 26000 17000
Nam TP 3,000 30 300 90000 25000
Son KT 1,200 30 250 36000 24000
Tai NV 1,000 26 100 26000 17000
Thanh GĐ 5,000 28 500 140000 25000
The TP 2,000 29 300 58000 25000
Thu PGĐ 4,000 26 400 104000 25000
Trinh NV 1,000 26 100 26000 17000
Tuan NV 1,000 26 100 26000 17000
Remaining

50300 1) Add sequential number automatically for No column.

10850
10850 2) Split column Full name into 2 columns: Surname & Middle name and First n
9100
8100 3) Reorder the list alphabetically A, B, C...
8100
9100 3) Position allowance is calculated based on position: (Using IF function)
9100
9100 + GĐ: 500
9100
65300 + PGĐ: 400
12250
9100 + TP: 300
115500
33300 + KT: 250
79400
9100 + Others: 100
9100
4) Salary = Basic Salary * Working Days

5) The advance is calculated as follows:

- If (Position allowance + Salary)*2/3 < 25000 then Advance = (Position allowanc

- Otherwise: Advance = 25000

(Round to the nearest thousand)

6) Remaining = Position allowance + Salary - Advance.

7) Month: Use the function to get the current month.

8) Present the spreadsheet.

e & Middle name and First name.

n: (Using IF function)

Advance = (Position allowances + Salary)*2/3

 Full
No. ID Full name Year Surname &Middle Name

1 20182111 Hoàng Thị Vân Anh 2018 Hoàng Thị Vân

2 20182117 Vũ Thị Mai Trinh 2018 Vũ Thị Mai
3 20182119 Phạm Văn Tuân 2018 Phạm Văn
4 20182121 Trần Quang Anh 2018 Trần Quang
5 20182123 Ngô Việt Hoàng 2018 Ngô Việt
6 20182127 Bùi Thị Minh Hương 2018 Bùi Thị Minh
7 20182130 Nguyễn Thị Ngọc Bích 2018 Nguyễn Thị Ngọc
8 20182132 Đào Thúy Hường 2018 Đào Thúy
9 20182135 Đào Thị Huyền 2018 Đào Thị
10 20182139 Trịnh Tiến Dũng 2018 Trịnh Tiến
11 20182141 Đặng Thị Thu Hà 2018 Đặng Thị Thu
12 20182143 Phan Thu Hằng 2018 Phan Thu
13 20182145 Nguyễn Quang Thiện 2018 Nguyễn Quang
14 20182147 Nguyễn Thị Thanh Hương 2018 Nguyễn Thị Thanh
15 20182150 Vũ Minh Hiếu 2018 Vũ Minh
16 20182152 Nguyễn Thị Lệ Thu 2018 Nguyễn Thị Lệ
17 20182154 Nguyễn Văn Toàn 2018 Nguyễn Văn
18 20182163 Nguyễn Thị Hương 2018 Nguyễn Thị
19 20182165 Dương Hồng Quân 2018 Dương Hồng
20 20182167 Võ Thị Mai 2018 Võ Thị
21 20182175 Vũ Duy Mạnh 2018 Vũ Duy
22 20182177 Lưu Quang Linh 2018 Lưu Quang
23 20182181 Nguyễn Thị Kim Linh 2018 Nguyễn Thị Kim
24 20182185 Hoàng Mai Ly 2018 Hoàng Mai
25 20182187 Lưu Thị Mai 2018 Lưu Thị
26 20182189 Hoàng Công Hiển 2018 Hoàng Công
27 20182191 Bùi Trung Hiếu 2018 Bùi Trung
28 20182194 Phạm Thị Ngọc Diệp 2018 Phạm Thị Ngọc
29 20182196 Nguyễn Trung Đức 2018 Nguyễn Trung
30 20182198 Nguyễn Thị Như Nguyệt 2018 Nguyễn Thị Như
31 20182200 Triệu Yến Nhi 2018 Triệu Yến
32 20182202 Trần Thị Cẩm Nhung 2018 Trần Thị Cẩm
33 20182204 Bùi Thị Minh Phượng 2018 Bùi Thị Minh
34 20182207 Trần Trung Quang 2018 Trần Trung
35 20182209 Vũ Nhật Anh 2018 Vũ Nhật
36 20182212 Nguyễn Trọng Bảo 2018 Nguyễn Trọng
37 20190257 Nguyễn Thị Thoan 2019 Nguyễn Thị
38 20192113 Phan Văn Rơn 2019 Phan Văn
39 20192115 Lê Danh Sơn 2019 Lê Danh
40 20192137 Trần Thu Trang 2019 Trần Thu
41 20192156 Bùi Mai Nga 2019 Bùi Mai
42 20192170 Ngô Thị Hoàng Ngân 2019 Ngô Thị Hoàng
43 20192173 Ngô Hoàng Anh 2019 Ngô Hoàng
44 20192179 Nguyễn Thị Vân Anh 2019 Nguyễn Thị Vân
45 20192183 Phạm Thị Uyên 2019 Phạm Thị
 name Conversion
First Name Mid-term Final Avg. point Assessment
point
Anh 7.5 8 8 B+ Pass
Trinh 7 6.5 7 C+ Pass
Tuân 7 6.5 7 C+ Pass
Anh 3 7 5 B Pass
Hoàng 8 8 8 B+ Pass
Hương 8.5 7 8 B Pass
Bích 6.5 7 7 B Pass
Hường 7.5 8.5 8 A Pass
Huyền 7 6 6 C Pass
Dũng 6.5 7 7 B Pass
Hà 7 6.5 7 C+ Pass
Hằng 7.5 6.5 7 C+ Pass
Thiện 7 7.5 7 B Pass
Hương 8.5 8.5 9 A Pass
Hiếu 6.5 7 7 B Pass
Thu 8.5 8 8 B+ Pass
Toàn 5.5 7 6 B Pass
Hương 8 6.5 7 C+ Pass
Quân 7 7.5 7 B Pass
Mai 8 9 9 A Pass
Mạnh 6 7.5 7 B Pass
Linh 7.5 7.5 8 B Pass
Linh 7.5 7 7 B Pass
Ly 7.5 8 8 B+ Pass
Mai 8.5 9 9 A Pass
Hiển 7.5 8 8 B+ Pass
Hiếu 7 7.5 7 B Pass
Diệp 7.5 8 8 B+ Pass
Đức 6.5 7 7 B Pass
Nguyệt 8 7 7 B Pass
Nhi 3 5 4 D+ Pass
Nhung 7.5 6.5 7 C+ Pass
Phượng 7.5 8 8 B+ Pass
Quang 6 7.5 7 B Pass
Anh 7.5 7.5 8 B Pass
Bảo 6.5 7 7 B Pass
Thoan 7 7.5 7 B Pass
Rơn 5.5 7 6 B Pass
Sơn 7 6.5 7 C+ Pass
Trang 6 9 8 A Pass
Nga 7.5 8.5 8 A Pass
Ngân 8 7.5 8 B Pass
Anh 8.5 7 8 B Pass
Anh 7 8.5 8 A Pass
Uyên 7.5 7.5 8 B Pass
1) Add sequential numbers automatically in column No.

2) Ascending sort for column ID (Use Data/Sort),

3) Split column Full name into 2 columns: Surname & Middle name and First name. Freeze the First-name

4) Avg. point = (Mid-term*0,4 + Final*0,6), round up to 0.5

5) Conversion point and rank: (Using If function)

Avg. Conversion Assessme

point point nt
9,5 -10 A+ Pass
8,5 – < 9,5 A Pass
8 – < 8,5 B+ Pass
7–<8 B Pass
6,5 – < 7 C+ Pass
5,5 – < 6,5 C Pass
5- < 5,5 D+ Pass
4–<5 D Fail
<4 F Fail

1) Insert Grade Year column, classify grade year of each student based on ID (2019 = second-yea

Format the table

3 3
3
2
2
2
3
3
2
2
2
3
2
2
3
2
3
2
2
2
2
2
2
3
2
2
2
2
3
2
3
2
3
3
2
2
2
2
2
2
2
2
3
2
3
2
rst name. Freeze the First-name column.

based on ID (2019 = second-year student; 2018 = third-year student)