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 drawer 199 600,000 119,400,000 5,970,000
TOTAL: ### 61,602,500

7/5/2024 7 5 2024
FREIGHT
TOTAL
COST
150,000 420,150,000 1) Automatically number in column No
75,000 7,950,000 2) Format the UNIT PRICE column with a thousands separator
87,000 73,167,000 3) PRICE = QUANTITY * UNIT PRICE
118,500 70,626,000 4) TAX = PRICE * 5%
138,000 19,458,000 5) FREIGHT COST = QUANTITY* 1500
330,000 577,830,000 6) Calculate the total of the columns PRICE, TAX, FREIGHT COST
298,500 125,668,500 7) Date: Use the function to get the current day, month, and year
1,197,000 ### 8) Present the spreadsheet
ousands separator

TAX, FREIGHT COST and TOTAL

y, month, and year
No Full Name Surname & Mid Name First Name
1 Bui Thi Minh Huong Bui Thi Minh Huong
2 Dang Thi Thu Ha Dang Thi Thu Ha
3 Dao Thi Huyen Dao Thi Huyen
4 Dao Thuy Huong Dao Thuy Huong
5 Doan Van An Doan Van An
6 Ho Tan Tai Ho Tan Tai
7 Hoang Thi Van Anh Hoang Thi Van Anh
8 Le Phuong Nam Le Phuong Nam
9 Le Thi Thanh Le Thi Thanh
10 Ngo Viet Hoang Ngo Viet Hoang
11 Nguyen Thi Ngoc Bich Nguyen Thi Ngoc Bich
12 Nguyen Thi Thu Nguyen Thi Thu
13 Nguyen Van Son Nguyen Van Son
14 Pham Van Tuan Pham Van Tuan
15 Phan Thu Hang Phan Thu Hang
16 Tran Quang Anh Tran Quang Anh
17 Tran Van The Tran Van The
18 Vu Thi Mai Trinh Vu Thi Mai Trinh

7/5/2024 5
 Position
Working Total
Position Basic Salary allowanc Advance
days Salary
e
NV 1,000 26 100 26,000 17,000
NV 1,000 24 100 24,000 16,000
NV 1,000 26 100 26,000 17,000
NV 1,000 26 100 26,000 17,000
TP 3,000 25 300 75,000 25,000
NV 1,000 26 100 26,000 17,000
KT 1,200 28 250 33,600 23,000
TP 3,000 30 300 90,000 25,000
GĐ 5,000 28 500 140,000 25,000
NV 1,000 26 100 26,000 17,000
NV 1,000 26 100 26,000 17,000
PGĐ 4,000 26 400 104,000 25,000
KT 1,200 30 250 36,000 24,000
NV 1,000 26 100 26,000 17,000
BV 800 30 100 24,000 16,000
KT 1,200 28 250 33,600 23,000
TP 2,000 29 300 58,000 25,000
NV 1,000 26 100 26,000 17,000
Remaining
9,100 1) Add sequential number automatically for No column.
8,100 2) Split column Full name into 2 columns: Surname & Middle na
9,100 3) Reorder the list alphabetically A, B, C...
9,100 3) Position allowance is calculated based on position: (Using IF fu
50,300 + GĐ: 500
9,100 + PGĐ: 400
10,850 + TP: 300
65,300 + KT: 250
115,500 + Others: 100
9,100 4) Salary = Basic Salary * Working Days
9,100 5) The advance is calculated as follows:
79,400 - If (Position allowance + Salary)*2/3 < 25000 then Advance = (Po
12,250 - Otherwise: Advance = 25000
9,100 (Round to the nearest thousand)
8,100 6) Remaining = Position allowance + Salary - Advance.
10,850 7) Month: Use the function to get the current month.
33,300 8) Present the spreadsheet.
9,100
 No column.
Surname & Middle name and First name.

n position: (Using IF function)

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

y - Advance.
No. ID Grade Year Full name Surname & Mid Name
1 20182111 third-year studentHoàng Thị Vân Anh Hoàng Thị Vân
2 20182117 third-year studentTrần Quang Anh Trần Quang
3 20182119 third-year studentVũ Nhật Anh Vũ Nhật
4 20182121 third-year studentNguyễn Trọng Bảo Nguyễn Trọng
5 20182123 third-year studentNguyễn Thị Ngọc Bích Nguyễn Thị Ngọc
6 20182127 third-year studentPhạm Thị Ngọc Diệp Phạm Thị Ngọc
7 20182130 third-year studentNguyễn Trung Đức Nguyễn Trung
8 20182132 third-year studentTrịnh Tiến Dũng Trịnh Tiến
9 20182135 third-year studentĐặng Thị Thu Hà Đặng Thị Thu
10 20182139 third-year studentHoàng Công Hiển Hoàng Công
11 20182141 third-year studentBùi Trung Hiếu Bùi Trung
12 20182143 third-year studentVũ Minh Hiếu Vũ Minh
13 20182145 third-year studentNgô Việt Hoàng Ngô Việt
14 20182147 third-year studentBùi Thị Minh Hương Bùi Thị Minh
15 20182150 third-year studentNguyễn Thị Hương Nguyễn Thị
16 20182152 third-year studentNguyễn Thị Thanh Hương Nguyễn Thị Thanh
17 20182154 third-year studentĐào Thúy Hường Đào Thúy
18 20182163 third-year studentLưu Quang Linh Lưu Quang
19 20182165 third-year studentNguyễn Thị Kim Linh Nguyễn Thị Kim
20 20182167 third-year studentHoàng Mai Ly Hoàng Mai
21 20182175 third-year studentVũ Duy Mạnh Vũ Duy
22 20182177 third-year studentBùi Mai Nga Bùi Mai
23 20182181 third-year studentNguyễn Thị Như Nguyệt Nguyễn Thị Như
24 20182185 third-year studentTrần Thị Cẩm Nhung Trần Thị Cẩm
25 20182187 third-year studentBùi Thị Minh Phượng Bùi Thị Minh
26 20182189 third-year studentDương Hồng Quân Dương Hồng
27 20182191 third-year studentTrần Trung Quang Trần Trung
28 20182194 third-year studentPhan Văn Rơn Phan Văn
29 20182196 third-year studentLê Danh Sơn Lê Danh
30 20182198 third-year studentNguyễn Quang Thiện Nguyễn Quang
31 20182200 third-year studentNguyễn Thị Thoan Nguyễn Thị
32 20182202 third-year studentNguyễn Thị Lệ Thu Nguyễn Thị Lệ
33 20182204 third-year studentNguyễn Văn Toàn Nguyễn Văn
34 20182207 third-year studentTrần Thu Trang Trần Thu
35 20182209 third-year studentVũ Thị Mai Trinh Vũ Thị Mai
36 20182212 third-year studentPhạm Văn Tuân Phạm Văn
37 20190257 second-year studePhạm Thị Uyên Phạm Thị
38 20192113 second-year studeNgô Hoàng Anh Ngô Hoàng
39 20192115 second-year studeNguyễn Thị Vân Anh Nguyễn Thị Vân
40 20192137 second-year studePhan Thu Hằng Phan Thu
41 20192156 second-year studeĐào Thị Huyền Đào Thị
42 20192170 second-year studeLưu Thị Mai Lưu Thị
43 20192173 second-year studeVõ Thị Mai Võ Thị
44 20192179 second-year studeNgô Thị Hoàng Ngân Ngô Thị Hoàng
45 20192183 second-year studeTriệu Yến Nhi Triệu Yến
 Conversion Assessmen
First Name Mid-term Final Avg. point
point t
Anh 7.5 8 7.8 B Pass
Anh 3 7 5.4 D+ Pass
Anh 7.5 7.5 7.5 B Pass
Bảo 6.5 7 6.8 C+ Pass
Bích 6.5 7 6.8 C+ Pass
Diệp 7.5 8 7.8 B Pass
Đức 6.5 7 6.8 C+ Pass
Dũng 6.5 7 6.8 C+ Pass
Hà 7 6.5 6.7 C+ Pass
Hiển 7.5 8 7.8 B Pass
Hiếu 7 7.5 7.3 B Pass
Hiếu 6.5 7 6.8 C+ Pass
Hoàng 8 8 8 B+ Pass
Hương 8.5 7 7.6 B Pass
Hương 8 6.5 7.1 B Pass
Hương 8.5 8.5 8.5 A Pass
Hường 7.5 8.5 8.1 B+ Pass
Linh 7.5 7.5 7.5 B Pass
Linh 7.5 7 7.2 B Pass
Ly 7.5 8 7.8 B Pass
Mạnh 6 7.5 6.9 C+ Pass
Nga 7.5 8.5 8.1 B+ Pass
Nguyệt 8 7 7.4 B Pass
Nhung 7.5 6.5 6.9 C+ Pass
Phượng 7.5 8 7.8 B Pass
Quân 7 7.5 7.3 B Pass
Quang 6 7.5 6.9 C+ Pass
Rơn 5.5 7 6.4 C Pass
Sơn 7 6.5 6.7 C+ Pass
Thiện 7 7.5 7.3 B Pass
Thoan 7 7.5 7.3 B Pass
Thu 8.5 8 8.2 B+ Pass
Toàn 5.5 7 6.4 C Pass
Trang 6 9 7.8 B Pass
Trinh 7 6.5 6.7 C+ Pass
Tuân 7 6.5 6.7 C+ Pass
Uyên 7.5 7.5 7.5 B Pass
Anh 8.5 7 7.6 B Pass
Anh 7 8.5 7.9 B Pass
Hằng 7.5 6.5 6.9 C+ Pass
Huyền 7 6 6.4 C Pass
Mai 8.5 9 8.8 A Pass
Mai 8 9 8.6 A Pass
Ngân 8 7.5 7.7 B Pass
Nhi 3 5 4.2 D Fail
 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 column
4) Avg. point = (Mid-term*0,4 + Final*0,6), round up to 0.5
5) Conversion point and rank: (Using If function)
Conversio Assessmen
Avg. point
n point t
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

6) Insert Grade Year column, classify grade year of each student based on ID (2019 = second-year student; 2018 = th
Format the table
e. Freeze the First-name column.

= second-year student; 2018 = third-year student)