Microsoft Excel

Quiz
•
Computers
•
10th Grade
•
Hard
Eko Prasetiyo
Used 7+ times
FREE Resource
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)
8.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus untuk mendapatkan isian "PENDAPATAN TERENDAH" pada cell H11 adalah ... .
=MIN(H6-H8)
=MIN(H6:H8)
=MIN(H6,H8)
=MIN(H6*H8)
9.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus untuk mendapatkan isian "RATA-RATA TERENDAH" pada cell H12 adalah ... .
=AVERAGE(H6-H8)
=AVERAGEA(H6*H8)
=AVERAGE(H6:H8)
=AVERAGEA(H6:H8)
Similar Resources on Wayground
14 questions
HTML - tagy

Quiz
•
9th - 12th Grade
5 questions
S3 HTML implementation starter

Quiz
•
10th Grade - University
10 questions
ASESMEN SUMATIF (HTML)

Quiz
•
9th - 12th Grade
13 questions
QUIZ - Microsoft Excel

Quiz
•
10th Grade
11 questions
Basic HTML Tags I

Quiz
•
9th - 12th Grade
10 questions
Lección Excel

Quiz
•
10th Grade
14 questions
HTML Quiz

Quiz
•
9th Grade - University
10 questions
Basic HTML Tags Quiz

Quiz
•
9th - 11th Grade
Popular Resources on Wayground
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
10 questions
Nouns, nouns, nouns

Quiz
•
3rd Grade
10 questions
9/11 Experience and Reflections

Interactive video
•
10th - 12th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
11 questions
All about me

Quiz
•
Professional Development
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
9 questions
Tips & Tricks

Lesson
•
6th - 8th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
10 questions
1.2 OSI & TCP IP Models Quiz

Quiz
•
10th Grade
20 questions
Digital Citizenship

Quiz
•
8th - 12th Grade
35 questions
Computer Baseline Examination 2025-26

Quiz
•
9th - 12th Grade
13 questions
Problem Solving Process

Quiz
•
9th - 12th Grade
20 questions
Hardware vs. Software Quiz

Quiz
•
7th - 10th Grade
10 questions
Understanding Algorithms with Pseudocode and Flowcharts

Interactive video
•
9th - 12th Grade
19 questions
AP CSP Unit 1 Review (code.org)

Quiz
•
10th - 12th Grade