Microsoft Excel
Authored by Eko Prasetiyo
Computers
10th Grade
Used 9+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
9 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus untuk mendapatkan isian "NAMA OBAT" pada cell D6 adalah ... .
=IF(B6="BR";"BODREX";"PUYER")
=IF(B6="BR";"ASAM MEFENAMAT";"PARASETAMOL")
=IF(B6="BR";"OBH";"BODREX")
=IF(B6="BR";"CTM";"ASAM MEFENAMAT")
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus untuk mendapatkan isian "HARGA OBAT" pada cell E7 adalah ... .
=IF(B7="BR";"15000";"10000")
=IF(B7="BR";"20000";"12000")
=IF(B7="BR";"10000";"8000")
=IF(B7="BR";"18000";"9000")
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus untuk mendapatkan isian "ONGKOS KIRIM" pada cell F8 adalah ... .
=IF(B8="BR";10%*E8;0%*E8)
=IF(B8="BR";5%*E8;0%*E8)
=IF(B8="BR";3%*E8;0%*E8)
=IF(B8="BR";7%*E8;0%*E8)
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus untuk mendapatkan isian "JUMLAH DISKON" pada cell G8 adalah ... .
=IF(C8>5;5%*E8;0%*E8)
=IF(C8>10;10%*E8;0%*E8)
=IF(C8>3;3%*E8;0%*E8)
=IF(C8>7;7%*E8;0%*E8)
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus untuk mendapatkan isian "JUMLAH PEMBAYARAN" pada cell H8 adalah ... .
=((E8+F8)/C8)-G8
=((E8*F8)*C8)-G8
=((E8*F8)+C8)-G8
=((E8-F8)*C8)-G8
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus untuk mendapatkan isian "TOTAL PENDAPATAN" pada cell H9 adalah ... .
=SUM(H6-H8)
=SUM(H6*H8)
=SUM(H6;H8)
=SUM(H6:H8)
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus untuk mendapatkan isian "PENDAPATAN TERTINGGI" pada cell H10 adalah ... .
=MAX(H6-H8)
=MAX(H6*H8)
=MAX(H6,H8)
=MAX(H6:H8)
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
JavaScript Cert Prep
Quiz
•
9th - 12th Grade
11 questions
10 сынып 1
Quiz
•
10th Grade
14 questions
Структура HTML-коду. Текстові елементи на вебсторінці
Quiz
•
10th Grade
10 questions
10Б html
Quiz
•
10th Grade
10 questions
Основные термины html
Quiz
•
10th Grade
12 questions
HTML
Quiz
•
9th - 12th Grade
10 questions
HTML. Теги для оформления
Quiz
•
10th Grade
13 questions
DASAR HTML
Quiz
•
10th Grade
Popular Resources on Wayground
8 questions
2 Step Word Problems
Quiz
•
KG - University
20 questions
Comparing Fractions
Quiz
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Latin Bases claus(clois,clos, clud, clus) and ped
Quiz
•
6th - 8th Grade
22 questions
fractions
Quiz
•
3rd Grade
7 questions
The Story of Books
Quiz
•
6th - 8th Grade
