Rumus Date Time
Authored by Annisa Aulia
Computers
1st - 10th Grade
Used 79+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Fungsi pada TIME yang digunakan untuk mencari detik adalah
DAY
DATE
HOUR
MINUTE
SECOND
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus yang tepat untuk mengisi sel B3 adalah
=DAY(A3)
=MONTH(A3)
=YEAR(A3)
=DAY(B3)
=MONTH(B3)
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus untuk mengisi sel B4 yang benar adalah
=MONTH(A4)
=MONTH(B4)
=DAY(A3)
=DAY(A4)
=DAY(A5)
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Fungsi DATE yang digunakan untuk mencari tahun dari suatu tanggal adalah
DAY
MONTH
YEAR
DATE
DAYS360
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus yang tepat untuk mengisi sel C18 adalah
=DAY(A18;B18)
=DAYS360(A18;B18)
=DAY(A18-B18)
=DAYS360(A18-B18)
=DAYS360(A18;C18)
6.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Cara yang tepat untuk mengisi sel - sel yang diberi warna biru adalah
ketik =YEAR(A3), tekan Enter, tarik tanda + pada pojok sel B3 hingga ke sel B5
ketik =YEAR(B3), tekan Enter, tarik tanda + pada pojok sel B3 hingga ke sel B5
ketik =YEAR(A2), tekan Enter, tarik tanda + pada pojok sel B3 hingga ke sel B5
ketik =YEAR(B2), tekan Enter, tarik tanda + pada pojok sel B3 hingga ke sel B5
ketik =YEAR(A3;A5), tekan Enter, tarik tanda + pada pojok sel B3 hingga ke sel B5
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk merubah angka bilangan menjadi format waktu dalam spreadsheet adalah
DATE
TIME
DAY
MINUTE
SECOND
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
10 questions
Soal dasar-dasar Excel
Quiz
•
10th Grade
14 questions
BÀI 14- THUẬT TOÁN TÌM KIẾM TUẦN TỰ
Quiz
•
6th Grade - University
12 questions
Excel
Quiz
•
8th Grade
12 questions
Електронні таблиці Exel
Quiz
•
1st - 12th Grade
10 questions
Excel sorular 1
Quiz
•
10th Grade
10 questions
Excel - formules en functies
Quiz
•
10th - 12th Grade
10 questions
Kiểm tra GHK2 lớp 4 (2023)
Quiz
•
4th Grade
10 questions
Informatika
Quiz
•
5th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
