Microsoft Excel Functions and Formulas
12th Grade
•20 Qs
Similar activities
KUIS 3_US SIMKD
12th Grade
•20 Qs
REMEDIAL PH 1 INFORMATIKA Genap 2020/2021 KLS IXA
12th Grade
•15 Qs
ULANGAN 1 TLJ KELAS XII
KG - Professional Development
•20 Qs
Informatika Kelas 5 Bab 2
5th Grade - University
•19 Qs
asj materi kontrol dan monitoring jaringan
12th Grade
•20 Qs
QUIZ INFORMATIKA KELAS VIII DAMPAK MEDIA SOSIAL
12th Grade
•20 Qs
ASPEK LEGAL TIK XII
12th Grade
•20 Qs
Pengayaan Informatika
12th Grade
•20 Qs
Microsoft Excel Functions and Formulas
Quiz
•
Computers
•
12th Grade
•
Practice Problem
•
Hard
Indrastuti Ristiyani
Used 3+ times
FREE Resource
Enhance your content in a minute
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk membuat penanggalan yang data tanggalnya terletak pada beberapa sel seperti pada gambar tersebut, digunakan fungsi ...
Fungsi Date
Fungsi Day
Fungsi Month
Fungsi Year
Fungsi Today
2.
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)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Berdasarkan tabel Daftar Penjualan Barang diatas. Analisislah rumus yang tepat digunakan untuk mencari data "nama barang" adalah …
=HLOOKUP(C3;tabel_data;3)
=HLOOKUP($B$3;tabel_data;2,0)
=VLOOKUP(C3;tabel_data;3;0)
=VLOOKUP(B3;tabel_data;2;0)
=VLOOKUP(B3;tabel_data;3;0)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Berdasarkan tabel Daftar Penjualan Barang diatas. Analisislah rumus yang tepat digunakan untuk mencari data "Jumlah" adalah …
=HLOOKUP(C3;tabel_data;3)
=HLOOKUP($B$3;tabel_data;2,0)
=VLOOKUP(C3;tabel_data;3;0)
=VLOOKUP(B3;tabel_data;3;0)
=VLOOKUP(B3;tabel_data;2;0)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perangkat lunak mempunyai fungsi dan kegunaan sendiri-sendiri sesuai dengan kebutuhan penggunanya, fungsi utama program Microsoft Excel adalah …
Mengelola dokumen
Mencari informasi
Pengolah data angka
Pengolah kata
Membuat angka
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Nadiya membuat tabel gaji karyawan dengan menggunakan microsoft exel . Bagaimanakah cara memberi bingkai pada sel, menu yang harus dipilih pada kotak Format Cells adalah…
Number
Allignment
Borders
Font
Merge & Center
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika isi suatu cell terdapat kesalahan, maka perlu perbaikan. Untuk memperbaiki isi suatu cell terlebih dahulu menekan tombol….
Esc
Ctrl
Spacebar
F1
F2
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
15 questions
Pemrograman
Quiz
•
9th - 12th Grade
15 questions
MVC-PHP
Quiz
•
12th Grade
15 questions
PTS Informatika Genap
Quiz
•
9th - 12th Grade
20 questions
TIK KD 3
Quiz
•
1st - 12th Grade
20 questions
Latihan Soal SIMKOMDIG
Quiz
•
12th Grade
20 questions
PEMBOLEHUBAH,PEMALAR DAN JENIS DATA
Quiz
•
7th - 12th Grade
20 questions
Latihan PSAS Kelas 9
Quiz
•
9th Grade - University
15 questions
Soal Pra UKK 2024 - Paket 2
Quiz
•
12th 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