
LATIHAN EXCEL
Quiz
•
Information Technology (IT)
•
9th Grade
•
Hard
Komang Mahayani
Used 13+ times
FREE Resource
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 5 pts
untuk mencari nilai tertinggi kita dapat menggunakan formula ?
SUM
MAX
MIN
AVERAGE
2.
MULTIPLE CHOICE QUESTION
1 min • 5 pts
untuk mencari nilai terendah kita dapat menggunakan formula ?
SUM
MAX
MIN
AVERAGE
3.
MULTIPLE CHOICE QUESTION
1 min • 5 pts
untuk memberikan satu nilai jika kondisi benar dan nilai lain jika kondisi salah, kita dapat menggunakan formula ?
UNIQUE
COUNTIF
IF
VLOOKUP
4.
MULTIPLE CHOICE QUESTION
2 mins • 5 pts
untuk mengisi cel berwarna merah kita dapat membuat rumus berikut
=SUM(C3:F3)
=AVERAGE(C3:F3)
=SUM(C3;F3)
=AVERAGE(C3;F3)
5.
MULTIPLE CHOICE QUESTION
2 mins • 5 pts
untuk mengisi cel berwarna kuning kita dapat membuat rumus berikut
=MAX(C3:F3)
=MAX(C4:F4)
=MAX(C3:F4)
=MAX(C4:G4)
6.
MULTIPLE CHOICE QUESTION
2 mins • 5 pts
untuk mengisi cel berwarna hijau kita dapat membuat rumus berikut
=MIN(C3:F3)
=MIN(C4:F4)
=MIN(C5:F5)
=MIN(C3:F4)
7.
MULTIPLE CHOICE QUESTION
2 mins • 5 pts
untuk mengisi cel berwarna hijau kita dapat membuat rumus berikut
=IF(C3="CIAMIS";0;600000)
=IF(C3="CIAMIS";600000;0)
=IF("CIAMIS";0;600000)
=IF(G3="CIAMIS";0;600000)
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
20 questions
QUIS TIK BY FATAHUL
Quiz
•
9th - 12th Grade
20 questions
Pemrograman Blokly
Quiz
•
9th Grade - University
22 questions
Assesmen Awal berpikir Komputasional Kelas 9 2024
Quiz
•
9th Grade
20 questions
Informatika Kuis
Quiz
•
9th Grade
20 questions
KUIS BAB V PENGEMBANGAN APLIKASI MOBILE
Quiz
•
9th - 12th Grade
20 questions
S1 Pseudocode x Ekosistem Media Pers Digital
Quiz
•
9th Grade - University
17 questions
Brainware
Quiz
•
9th Grade - University
15 questions
XII INF-Asesmen Awal BK
Quiz
•
9th - 12th Grade
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
20 questions
ELA Advisory Review
Quiz
•
7th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
Discover more resources for Information Technology (IT)
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
20 questions
Distribute and Combine Like Terms
Quiz
•
7th - 9th Grade
12 questions
Graphing Inequalities on a Number Line
Quiz
•
9th Grade
11 questions
NFL Football logos
Quiz
•
KG - Professional Dev...
20 questions
Cell Organelles
Quiz
•
9th Grade
20 questions
Cell Transport
Quiz
•
9th Grade