Lecture 6_KNPTNLS_Dedh
Authored by Huu De Dinh
Science
11th Grade
Used 2+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
44 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bạn cần xếp loại điểm theo nhiều ngưỡng (≤4 “Yếu”, ≤6 “Trung bình”, ≤8 “Khá”, >8 “Giỏi”). Công thức phù hợp nhất ở ô B2, dựa vào điểm ở A2 (Excel 365)?
=IF(A2>8,"Giỏi","Khá")
=IFS(A2<=4,"Yếu",A2<=6,"Trung bình",A2<=8,"Khá",A2>8,"Giỏi")
=SWITCH(A2,4,"Yếu",6,"Trung bình",8,"Khá","Giỏi")
=CHOOSE(A2,"Yếu","Trung bình","Khá","Giỏi")
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bảng Tra có mã ở cột D và tên ở cột E. Bạn muốn tra cứu tên theo mã (khớp chính xác). Hàm đơn giản và linh hoạt nhất?
VLOOKUP
HLOOKUP
XLOOKUP
LOOKUP
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Tính tổng doanh thu cho Khu vực “HCM”:
=SUMIF(A2:A100,"HCM",C2:C100)
=SUM(C2:C100,"HCM")
=SUMIFS(A2:A100,"HCM",C2:C100)
=COUNTIF(A2:A100,"HCM")
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Tính tổng doanh thu cho Khu vực “HCM” và Tháng = 1:
=SUMIF(A2:A100,"HCM",B2:B100)
=SUMIFS(C2:C100,A2:A100,"HCM",B2:B100,1)
=SUM(C2:C100*(A2:A100=="HCM")*(B2:B100==1))
=SUMPRODUCT(A2:A100=="HCM",B2:B100==1,C2:C100)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Đếm số đơn hàng có Doanh thu > 1.000.000 (vùng C2:C100):
=COUNT(C2:C100>1000000)
=COUNTA(C2:C100>1000000)
=COUNTIF(C2:C100,">1000000")
=COUNTIFS(C2:C100,">1000000")
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Đếm số khách hàng ở “HCM” và nhóm “VIP” (Khu vực A2:A100, Nhóm B2:B100):
=COUNTIF(A2:A100,"HCM")+COUNTIF(B2:B100,"VIP")
=COUNTIFS(A2:A100,"HCM",B2:B100,"VIP")
=COUNTIFS(A2:A100,"HCM")*COUNTIFS(B2:B100,"VIP")
=COUNTIF(A2:A100&B2:B100,"HCMVIP")
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Làm sạch chuỗi A2 có nhiều khoảng trắng thừa (đầu, giữa, cuối):
=SUBSTITUTE(A2," ","")
=TRIM(A2)
=CLEAN(A2)
=PROPER(A2)
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
40 questions
Physical Science: Ch 4: Gravity and Satellite Motion
Quiz
•
9th - 12th Grade
46 questions
11.2.1 Sóng
Quiz
•
11th Grade
48 questions
Hidrocacbon không no
Quiz
•
9th - 12th Grade
44 questions
Chuyển động Brown
Quiz
•
11th Grade
40 questions
Asesmen Akhir Semester Ganjil IPA
Quiz
•
9th Grade - University
47 questions
OSN IPA SMP Simulasi OSN Tingkat Kabupaten (OSK) Tahun 2022
Quiz
•
9th Grade - University
40 questions
Physical Science: Chapter 1: Motion
Quiz
•
9th - 12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
10 questions
Probability Practice
Quiz
•
4th Grade
15 questions
Probability on Number LIne
Quiz
•
4th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
6 questions
Appropriate Chromebook Usage
Lesson
•
7th Grade
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade
Discover more resources for Science
14 questions
Natural Selection and Adaptation
Lesson
•
9th - 12th Grade
30 questions
Unit 2C Progress Check (Biosphere 3)
Quiz
•
9th - 12th Grade
15 questions
Punnett Square & Pedigree Charts- Review
Quiz
•
9th - 12th Grade
12 questions
Cellular Respiration
Interactive video
•
11th Grade
10 questions
ACT Science #1
Quiz
•
11th Grade
28 questions
Asexual vs. Sexual Reproduction
Quiz
•
9th - 12th Grade
12 questions
Homeostasis: Positive and Negative Feedback Loops
Interactive video
•
11th Grade
25 questions
Heredity and Punnett Squares
Quiz
•
9th - 12th Grade