IRA WIHERTI
Authored by Ira Wiherti
Computers
10th Grade
Used 2+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
8 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Pertemuan kolom dan baris disebut
formula bar
sel
ribbon
toolbar
range
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Tombol pada keyboard yang digunakan untuk memperbaiki kesalahan pengetikan adalah ....
F1
F3
F2
F4
F5
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk menjumlah pada Ms. Excel adalah ....
SUM
MAX
MIN
Average
fn
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
fungsi untuk membaca data dari tabel secara vertikal adalah....
LOOKUP
HLOOKUP
OR
AND
VLOOKUP
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus untuk mencari jumlah pada tabel adalah....
SUM(A2:A8)
=SUM(B2:B8)
=SUM(B2;B8)
=SUM(A1:A8)
=SUM(B1:B8)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus untuk mengisi kolom gaji pokok adalah ....
=IF(C4="A":1200000;IF(C4="B";1000000;850000)
=IF(C4="A":1200000;IF(C4="B":1000000;850000))
=IF(C4="A";1200000;(C4="B";1000000;850000))
=IF(C4="A";1200000;IF(C4="B";1000000;850000)
=IF(C4="A";1200000;IF(C4="B";1000000;850000))
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bentuk penulisan fungsi VLOOKUP adalah ....
=VLOOKUP(look_value;table_array;col_index_num;range_lookup)
=HLOOKUP(look_value;table_array;col_index_num;range_lookup)
=CLOOKUP(look_value;table_array;col_index_num;range_lookup)
=RLOOKUP(look_value;table_array;col_index_num;range_lookup)
=SLOOKUP(look_value;table_array;col_index_num;range_lookup)
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?
