
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)
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
20 questions
Latihan Soal Informatika - Kelas 9
Quiz
•
9th Grade
20 questions
Quiz Keamanan Data dan Informasi
Quiz
•
9th Grade - University
25 questions
STS Informatika Kelas 8 Semester 1
Quiz
•
8th Grade - University
20 questions
Quiz Informatika 9.1
Quiz
•
9th Grade
20 questions
Quiz Mengenal Data VII
Quiz
•
7th Grade - University
20 questions
Soal PTS Informatika kelas 9
Quiz
•
9th Grade
25 questions
PTS Informatika Kelas 9 Semester 1
Quiz
•
9th Grade
20 questions
PTS INFORMATIKA SEMESTER GENAP
Quiz
•
8th Grade - University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
Discover more resources for Information Technology (IT)
20 questions
El Verbo IR Practice
Quiz
•
9th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
15 questions
Making Inferences
Quiz
•
7th - 12th Grade
15 questions
Main Idea and Supporting Details.
Quiz
•
4th - 11th Grade
18 questions
SAT Prep: Ratios, Proportions, & Percents
Quiz
•
9th - 10th Grade
12 questions
Exponential Growth and Decay
Quiz
•
9th Grade
12 questions
Add and Subtract Polynomials
Quiz
•
9th - 12th Grade
