Excel - Hàm

Quiz
•
Computers
•
9th Grade - University
•
Medium
Tran Giang
Used 159+ times
FREE Resource
50 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Công thức nào phù hợp nhất để xác định giờ đến của chuyến bay tại ô C3
Value(mid(A3,4,2))
mid(A3,3,2)
Left(A3,2)
Right(A3,2)
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Tại ô địa chỉ N4. Công thức nào thực hiện xác định ngày sinh nhật trong năm nay của từng sinh viên
=date(2019,3,6)
=date(2019,month(E4),day(E4))
=date(year(today()), month(E4), day(E4))
=date(year(E4),month(E4),day(E4))
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Công thức nào tại ô E3 để xác định lịch bay của chuyến bay là Sáng(4-12h) Chiều(12-20h) hay Tối từ (20 -4h hôm sau)
=if(C3<4,"T",if(C3<12,"S",if(C3<20,"C","T")))
=if(C3>4,"S",if(C3>12,"C","T")
=if(C3>4,if(C3>12,if(C3>20,"T","C"),"S")))
=if(C3<20,"C",if(C3<12,"T","S"))
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Create a free account and access millions of resources
Similar Resources on Wayground
50 questions
ÔN TẬP GKII TIN 10

Quiz
•
10th Grade
53 questions
Kiểm tra kiến thức máy tính

Quiz
•
University
55 questions
Lý thuyết Word

Quiz
•
University
54 questions
ÔN TẬP GK 2 K9 24-25

Quiz
•
9th Grade
50 questions
Module 5 Microsoft Excel

Quiz
•
University
50 questions
EXCEL 51-100

Quiz
•
University
52 questions
MODULE 4

Quiz
•
12th Grade
50 questions
K10 - Giữa HK II

Quiz
•
10th Grade
Popular Resources on Wayground
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
10 questions
Nouns, nouns, nouns

Quiz
•
3rd Grade
10 questions
9/11 Experience and Reflections

Interactive video
•
10th - 12th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
11 questions
All about me

Quiz
•
Professional Development
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
9 questions
Tips & Tricks

Lesson
•
6th - 8th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
10 questions
1.2 OSI & TCP IP Models Quiz

Quiz
•
10th Grade
20 questions
Digital Citizenship

Quiz
•
8th - 12th Grade
30 questions
Introduction to Computers

Quiz
•
8th - 9th Grade
35 questions
Computer Baseline Examination 2025-26

Quiz
•
9th - 12th Grade
13 questions
Problem Solving Process

Quiz
•
9th - 12th Grade
20 questions
Hardware vs. Software Quiz

Quiz
•
7th - 10th Grade
10 questions
Understanding Algorithms with Pseudocode and Flowcharts

Interactive video
•
9th - 12th Grade