Câu hỏi về MS Excel và Word
Quiz
•
Others
•
University
•
Practice Problem
•
Medium
Vũ Nguyên
Used 1+ times
FREE Resource
Enhance your content in a minute
119 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
MS Excel: Ô A1=Tuấn, Nguyễn Văn. Hãy cho biết kết quả công thức sau: =LEFT(A1,Find(",",A1)-1)
Tuấn
Nguyễn
Văn
Tuấn, Nguyễn
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
MS Excel: Ô A1= Tuấn, Nguyễn Văn. Hãy cho biết kết quả công thức sau: =RIGHT(A1,LEN(A1)-FIND(",",A1)-1)
Tuấn
Nguyễn Văn
Văn Tuấn
Nguyễn
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
MS Excel: Ô C1=DTU; C2=1; C3=A; C4=2. Hãy cho biết kết quả công thức sau: =COUNT(SUM(C2:C4),C1)
1
2
3
4
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
MS Excel: Công thức nào sau đây không có lỗi cú pháp
=MID(LEFT(RIGHT(A1,6),AVERAGE(1,2,3)),1,2)
=MIDLE(LEFT(RIGHT(A1,6),AVERAGE(1,2,3)),1,2)
=MID(LEFT(RIGHT(A1,6),AVERAGE(1,2,3)),1,2,3)
=MID(LEFT(RIGHT(A1,6,2),AVERAGE(1,2,3)),1,2)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
MS Excel: Hàm Vlookup trong Excel dùng để làm gì?
Tra cứu dữ liệu
Tính tổng theo điều kiện
Tính giá trị lớn nhất
Tính giá trị nhỏ nhất
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
MS Excel: Ô A1=DTU; A2=1; A3=2. Hãy cho biết kết quả công thức sau: =AND(LEFT(A1,A3)=RIGHT(A1,A2))
FALSE
TRUE
YES
NO
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
MS Excel: Ô A1=DTU; A2=1; A3=2. Hãy cho biết kết quả công thức sau: =OR(MID(A1,A2,A3)=LEFT(A1,2),2>4)
TRUE
FALSE
YES
NO
Create a free account and access millions of resources
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
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
9 questions
FOREST Community of Caring
Lesson
•
1st - 5th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
14 questions
General Technology Use Quiz
Quiz
•
8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
19 questions
Thanksgiving Trivia
Quiz
•
6th Grade
Discover more resources for Others
20 questions
Definite and Indefinite Articles in Spanish (Avancemos)
Quiz
•
8th Grade - University
7 questions
Force and Motion
Interactive video
•
4th Grade - University
9 questions
Principles of the United States Constitution
Interactive video
•
University
18 questions
Realidades 2 2A reflexivos
Quiz
•
7th Grade - University
10 questions
Dichotomous Key
Quiz
•
KG - University
25 questions
Integer Operations
Quiz
•
KG - University
7 questions
What Is Narrative Writing?
Interactive video
•
4th Grade - University
20 questions
SER vs ESTAR
Quiz
•
7th Grade - University