
LATIHAN EXCEL
Quiz
•
Information Technology (IT)
•
9th Grade
•
Practice Problem
•
Hard
Komang Mahayani
Used 13+ times
FREE Resource
Enhance your content in a minute
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
Already have an account?
Similar Resources on Wayground
20 questions
Kelas 8 - Halaman 27 (UH Bab 2)
Quiz
•
8th Grade - University
15 questions
Asesmen Diagnostik Kelas 9
Quiz
•
9th Grade
20 questions
SOAL UJIAN INFORMATIKA KELAS IX
Quiz
•
9th Grade
20 questions
Uji Kompetensi 1
Quiz
•
7th Grade - University
20 questions
ASESMEN DIAGNOSTIK INFORMATIKA KELAS 8
Quiz
•
8th Grade - University
20 questions
UH BAB 3 TEKNOLOGI INFORMASI DAN KOMUNIKASI
Quiz
•
9th Grade
20 questions
Pengenalan Bahasa Pemrograman Python
Quiz
•
9th Grade - University
20 questions
PTS KELAS 7
Quiz
•
9th - 12th Grade
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
15 questions
4:3 Model Multiplication of Decimals by Whole Numbers
Quiz
•
5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
The Best Christmas Pageant Ever Chapters 1 & 2
Quiz
•
4th Grade
12 questions
Unit 4 Review Day
Quiz
•
3rd Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
Discover more resources for Information Technology (IT)
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
28 questions
Ser vs estar
Quiz
•
9th - 12th Grade
20 questions
Christmas Movie Trivia
Quiz
•
9th - 12th Grade
10 questions
Exploring the Energy Cycle: Photosynthesis and Cellular Respiration
Interactive video
•
6th - 10th Grade
25 questions
photosynthesis and cellular respiration
Quiz
•
9th Grade
10 questions
Guess the Christmas Movie by the Scene Challenge
Interactive video
•
6th - 10th Grade
