
Câu hỏi về hàm Excel

Quiz
•
Computers
•
University
•
Hard
Phương Anh Nguyễn
Used 3+ times
FREE Resource
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
Create a free account and access millions of resources
Similar Resources on Wayground
68 questions
TN Tin

Quiz
•
10th Grade - University
71 questions
chương 5

Quiz
•
University
69 questions
An toàn UD Web và CSDL (C1)

Quiz
•
University
68 questions
586354

Quiz
•
University
71 questions
C5_KTMT

Quiz
•
University
71 questions
Function 1: การเข้าใจดิจิทัล (Digital Literacy)

Quiz
•
University
72 questions
Câu hỏi trắc nghiệm công nghệ thông tin

Quiz
•
University
72 questions
70 cau đầu na

Quiz
•
University
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition

Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12

Lesson
•
11th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
Discover more resources for Computers
20 questions
Definite and Indefinite Articles in Spanish (Avancemos)

Quiz
•
8th Grade - University
7 questions
Force and Motion

Interactive video
•
4th Grade - University
36 questions
Unit 5 Key Terms

Quiz
•
11th Grade - University
7 questions
Figurative Language: Idioms, Similes, and Metaphors

Interactive video
•
4th Grade - University
15 questions
Properties of Equality

Quiz
•
8th Grade - University
38 questions
WH - Unit 3 Exam Review*

Quiz
•
10th Grade - University
21 questions
Advise vs. Advice

Quiz
•
6th Grade - University
12 questions
Reading a ruler!

Quiz
•
9th Grade - University