Rumus Date Time
1st - 10th Grade
•10 Qs
Similar activities
DATA ANALYTICS USING EXCEL
7th Grade
•15 Qs
Introduction to spreadsheets
5th Grade
•9 Qs
TIK KELAS 8 - BAB 1
8th Grade
•10 Qs
KT GHK2 Tin 8
6th - 8th Grade
•12 Qs
Tin 7 bài 2
6th - 9th Grade
•10 Qs
Информатика база Excel
8th Grade
•12 Qs
Penilaian Harian Kelas 5 Akhir Semester 1
5th Grade
•10 Qs
Ulangan Harian Analisis Data
7th Grade
•11 Qs
Rumus Date Time
Quiz
•
Computers
•
1st - 10th Grade
•
Practice Problem
•
Medium
Annisa Aulia
Used 76+ times
FREE Resource
Enhance your content in a minute
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
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
10 questions
Informatika Aplikasi Perkantoran
Quiz
•
7th Grade
10 questions
Spreadsheet Rumus statistik
Quiz
•
10th Grade
10 questions
Excel
Quiz
•
10th - 11th Grade
10 questions
2.2 MAC Address
Quiz
•
9th - 10th Grade
15 questions
9-Sinf III chorak CHSB
Quiz
•
9th Grade
10 questions
SOAL INFORMATIKA UH 1 cLASS VII-7
Quiz
•
7th Grade
15 questions
Excel - basic
Quiz
•
9th Grade
10 questions
Quinto
Quiz
•
5th 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
Discover more resources for Computers
18 questions
Company Logos
Quiz
•
6th - 8th Grade
13 questions
PowerPoint Basics
Quiz
•
6th - 8th Grade
10 questions
App Creators Lesson 2.1-2.4
Quiz
•
8th Grade
10 questions
Exploring Computer Science Careers and Subfields
Interactive video
•
6th - 10th Grade
15 questions
AP CSP Unit 4
Quiz
•
10th - 12th Grade
23 questions
Prog 1 Python Q1 Practice
Quiz
•
9th - 12th Grade
20 questions
logo quiz
Quiz
•
3rd Grade