3.7 Fungsi Date & Time
Quiz
•
Computers
•
10th Grade
•
Practice Problem
•
Medium
Aris Muhammad
Used 78+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Pada Microsoft Excel, sering kita jumpai data yang berbentuk suatu tanggal, hari bulan tahun. Simbol pemisah untuk tanggal (date) pada Microsoft Excel, adalah ....
:
&
"
/ dan -
; dan +
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Perhatikan gambar berikut!
Untuk membuat penanggalan yang data tanggalnya terletak pada beberapa sel seperti pada gambar disamping, digunakan fungsi ...
Fungsi Date
Fungsi Day
Fungsi Month
Fungsi Year
Fungsi Today
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi Date banyak digunakan dalam pencatatan transaksi akuntansi. Bentuk penulisan fungsi Date yang benar, adalah ....
=Date()
=Date(serial_number)
=Date(year/month/day)
=Date(year;month;day)
=Date(day;month;year)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan gambar berikut!
Untuk mengambil angka bulan saja dari data tanggal pada sel D3, digunakan ....
Fungsi Date
Fungsi Day
Fungsi Month
Fungsi Year
Fungsi Today
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan gambar berikut!
Untuk memasukkan data berupa tanggal hari ini saja, seperti pada Sel B1, digunakan ....
Fungsi Date
Fungsi Day
Fungsi Today
Fungsi Now
Fungsi Days360
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan gambar berikut!
Untuk menampilkan data tanggal dan jam sekarang sesuai waktu sebenarnya di komputer, seperti pada Sel B3, digunakan ....
Fungsi Date
Fungsi Day
Fungsi Today
Fungsi Now
Fungsi Days360
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan gambar berikut! Untuk mencari nilai selisih diantara dua tanggal pada sel D2, rumusnya adalah ....
=DAYS(B2;C2)
=DAYS360(B2;C2)
=DAYS360(C2;B2)
=DAYS360(B2-C2)
=DAYS360(C2-D2)
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
14 questions
Malware And Hackers
Quiz
•
KG - University
14 questions
BÀI 14- THUẬT TOÁN TÌM KIẾM TUẦN TỰ
Quiz
•
6th Grade - University
11 questions
Access
Quiz
•
10th Grade - University
14 questions
iGCSE ICT Revision
Quiz
•
7th - 10th Grade
14 questions
Cyber Security - Social Engineering
Quiz
•
10th - 11th Grade
12 questions
Computing laws
Quiz
•
9th - 12th Grade
10 questions
PARTS OF MOTHERBOARD
Quiz
•
10th Grade
10 questions
Microsoft Office Word
Quiz
•
10th Grade
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
