untuk mencari nilai tertinggi kita dapat menggunakan formula ?
LATIHAN EXCEL
9th Grade
•20 Qs
Similar activities
Kuis Tambahan Excel
9th Grade
•15 Qs
PTS INFORMATIKA SEMESTER GENAP
8th Grade - University
•20 Qs
Latihan Soal Informatika - Kelas 9
9th Grade
•20 Qs
Sumatif 3_Analisis Data_Informatika Kelas VIII
8th Grade - University
•18 Qs
Excel grade 3
4th Grade - University
•19 Qs
Quis US Kelas IX
9th Grade
•18 Qs
LATIHAN SOAL.! PART 1
7th Grade - University
•20 Qs
SAS informatika kelas 8 S2
8th Grade - University
•15 Qs
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
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
Microsoft
Apple
Others
Similar Resources on Quizizz
20 questions
Analisis Data Kls 7
Quiz
•
9th Grade
25 questions
Berpikir Komputasional
Quiz
•
9th - 12th Grade
20 questions
Quiz Microsoft PowerPoint
Quiz
•
5th Grade - University
20 questions
SOAL SAS INFORMATIKA KELAS IX
Quiz
•
9th Grade
15 questions
Asesmen Awal Berpikir Komputasional
Quiz
•
9th - 12th Grade
15 questions
Quiz Analisis Data
Quiz
•
8th Grade - University
15 questions
Uji Pemahaman VLOOKUP dan HLOOKUP
Quiz
•
9th Grade
20 questions
Kelas 9 - Halaman 46 (UH Bab 2)
Quiz
•
9th Grade - University
Popular Resources on Quizizz
15 questions
Multiplication Facts
Quiz
•
4th Grade
20 questions
Math Review - Grade 6
Quiz
•
6th Grade
20 questions
math review
Quiz
•
4th Grade
5 questions
capitalization in sentences
Quiz
•
5th - 8th Grade
10 questions
Juneteenth History and Significance
Interactive video
•
5th - 8th Grade
15 questions
Adding and Subtracting Fractions
Quiz
•
5th Grade
10 questions
R2H Day One Internship Expectation Review Guidelines
Quiz
•
Professional Development
12 questions
Dividing Fractions
Quiz
•
6th Grade
Discover more resources for Information Technology (IT)
25 questions
Spanish preterite verbs (irregular/changed)
Quiz
•
9th - 10th Grade
10 questions
Identify Slope and y-intercept (from equation)
Quiz
•
8th - 9th Grade
10 questions
Juneteenth: History and Significance
Interactive video
•
7th - 12th Grade
8 questions
"Keeping the City of Venice Afloat" - STAAR Bootcamp, Day 1
Quiz
•
9th - 12th Grade
26 questions
June 19th
Quiz
•
4th - 9th Grade
27 questions
STAAR English 1 Review
Quiz
•
9th Grade
20 questions
Understanding Linear Equations and Slopes
Quiz
•
9th - 12th Grade