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?
Similar Resources on Wayground
10 questions
ICT Project Quiz Class IX
Quiz
•
9th - 10th Grade
10 questions
CPU DAN GPU
Quiz
•
8th Grade - University
10 questions
Programación 4to - IVBim
Quiz
•
10th Grade
10 questions
Excel
Quiz
•
1st - 12th Grade
10 questions
TIK-Ms Excel
Quiz
•
10th Grade
10 questions
CSEC ICT June 2020 Paper 1 Part 3
Quiz
•
9th - 10th Grade
10 questions
REVIEW AD KLS 9
Quiz
•
9th Grade - University
10 questions
Excellente
Quiz
•
1st - 10th Grade
Popular Resources on Wayground
8 questions
Spartan Way - Classroom Responsible
Quiz
•
9th - 12th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
14 questions
Boundaries & Healthy Relationships
Lesson
•
6th - 8th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
3 questions
Integrity and Your Health
Lesson
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
9 questions
FOREST Perception
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
