
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
Similar Resources on Wayground
20 questions
Quiz Berpikir Komputasional Kelas 8

Quiz
•
8th Grade - University
20 questions
PTS KELAS 7

Quiz
•
9th - 12th Grade
20 questions
Pengenalan Bahasa Pemrograman Python

Quiz
•
9th Grade - University
20 questions
Uji Kompetensi 1

Quiz
•
7th Grade - University
20 questions
Quiz Excel

Quiz
•
9th Grade
18 questions
Uji Pemahaman Microsoft Excel Kelas 8

Quiz
•
9th Grade
15 questions
Asesmen Diagnostik Kelas 9

Quiz
•
9th Grade
20 questions
ASESMEN DIAGNOSTIK INFORMATIKA KELAS 8

Quiz
•
8th Grade - University
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 Information Technology (IT)
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
24 questions
Scientific method and variables review

Quiz
•
9th Grade
20 questions
Getting to know YOU icebreaker activity!

Quiz
•
6th - 12th Grade
20 questions
Biomolecules

Quiz
•
9th Grade
12 questions
Graphing Inequalities on a Number Line

Quiz
•
9th Grade
20 questions
Cell Organelles

Quiz
•
9th Grade
20 questions
Oceans and Continents Quiz

Quiz
•
9th Grade