
Câu hỏi về hàm Excel
Authored by Phương Anh Nguyễn
Computers
University
Used 3+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
72 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Câu 152 : Để đếm số lượng nhân viên thuộc một phòng ban nào đó , dùng hàm:
COUNTIF
COUNT
COUNTA
Cả A,B,C đều sai
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Câu 153 : Để tính tổng các ô từ A1 đến A7, công thức nào dưới đây là đúng
=SUM(A1):SUM(A7)
=SUM(A1- A7)
=SUM(A1:A7)
=SUM(A1);SUM(A7)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Câu 154 : Địa chỉ $AC$3 là địa chỉ
Tuyệt đối
Tương đối
Biểu diễn sai
Hỗn hợp
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Câu 155 : Giả sử ô A1 có giá trị 7.263 và ô A2 có giá trị 5.326. Công thức =ROUND(A1,2)-INT(A2) cho kết quả:
1.901
2.26
2
2.2
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Câu 156 : Giả sử ô có địa chỉ B3 chứa chuỗi "Micrsoft Excel". Hàm nào trả về chuỗi "soft":
MID(B3,4,4)
MID(B3,4,6)
MID(B3,6,4)
MID(B3,5,4)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Câu 157 : Hàm DAY("20/10/1994") cho kết quả:
20
1994
10
20/10/1994
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Câu 158 : Hàm MONTH("20/10/1994") cho kết quả:
20
1994
10
20/10/1994
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
69 questions
EXCEL TỔNG QUÁT
Quiz
•
University
70 questions
KTMT - CH02 - Logic
Quiz
•
University
71 questions
TIN HỌC 6_1,2,3
Quiz
•
6th Grade - University
72 questions
PRIMER EXAMEN COMPUTACIÓN - CUP (1-86)
Quiz
•
University
71 questions
Câu hỏi về Cơ khí Động lực
Quiz
•
11th Grade - University
70 questions
UAS PTI TA GENAP 2024/2025
Quiz
•
University
73 questions
Bài 3. 73 câu
Quiz
•
University
76 questions
HỌC PHẦN 1:SỬ DỤNG INTERNET CƠ BẢN
Quiz
•
University
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 Computers
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
20 questions
Endocrine System
Quiz
•
University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
30 questions
W25: PSYCH 250 - Exam 2 Practice
Quiz
•
University
5 questions
Inherited and Acquired Traits of Animals
Interactive video
•
4th Grade - University
20 questions
Implicit vs. Explicit
Quiz
•
6th Grade - University
7 questions
Comparing Fractions
Interactive video
•
1st Grade - University
38 questions
Unit 8 Review - Absolutism & Revolution
Quiz
•
10th Grade - University