Sebutkan 10 rumus dasar serta kegunaannya dalam Microsoft Excel!
Quiz Soal Latihan Excel

Quiz
•
Others
•
KG
•
Hard
Stephanie Clarissa Lie
Used 1+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
SUM, AVERAGE, COUNTIF, MAX, MIN, IF, INDEX, MATCH, CONCATENATE, RIGHT
SUM, AVERAGE, COUNT, MAX, MIN, IF, CONCATENATE, LEFT, RIGHT, DATEDIF
SUM, AVERAGE, COUNT, MAX, MIN, IF, VLOOKUP, CONCATENATE, LEFT, DATEDIF
SUM, AVERAGE, COUNT, MAX, MIN, IF, VLOOKUP, HLOOKUP, CONCATENATE, LEFT
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus apa yang digunakan untuk menjumlahkan nilai 10 murid kelas 6?
AVERAGE
SUM
MAX
COUNT
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus apa yang digunakan untuk menghitung rata-rata data penjualan?
SUM
MAX
COUNTIF
AVERAGE
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus apa yang digunakan untuk mencari jumlah tinggi badan yang lebih dari 157?
MAX
AVERAGEIF
SUMIF
COUNTIF
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus apa yang digunakan untuk mencari nilai maksimum dari data berat badan?
MAX
AVERAGE
MIN
SUM
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus apa yang digunakan untuk memberi label pada data penjualan?
COUNT
AVERAGE
SUM
IF
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus apa yang digunakan untuk menghitung selisih antara tinggi badan tertinggi dan terendah?
MAX - MIN
COUNT
AVERAGE
SUM
Create a free account and access millions of resources
Similar Resources on Quizizz
10 questions
UH3 BDP

Quiz
•
KG
15 questions
latihan soal teknik mesin kelas Xi

Quiz
•
University
10 questions
Pretes Dasar Microsoft Excel

Quiz
•
11th Grade
11 questions
Dasar Penggunaan Leptop&Microsoft Office

Quiz
•
12th Grade
10 questions
Informatika IX

Quiz
•
9th Grade
12 questions
Uji Kemampuan Analisis Data dan Excel

Quiz
•
12th Grade
10 questions
TIK IX (Microsoft office dqn word)

Quiz
•
KG
10 questions
Canva Dasar

Quiz
•
4th Grade
Popular Resources on Quizizz
10 questions
Chains by Laurie Halse Anderson Chapters 1-3 Quiz

Quiz
•
6th Grade
20 questions
math review

Quiz
•
4th Grade
15 questions
Character Analysis

Quiz
•
4th Grade
12 questions
Multiplying Fractions

Quiz
•
6th Grade
30 questions
Biology Regents Review #1

Quiz
•
9th Grade
20 questions
Reading Comprehension

Quiz
•
5th Grade
20 questions
Types of Credit

Quiz
•
9th - 12th Grade
50 questions
Biology Regents Review: Structure & Function

Quiz
•
9th - 12th Grade
Discover more resources for Others
10 questions
Identifying equations

Quiz
•
KG - University
15 questions
Disney Trivia

Quiz
•
KG - 5th Grade
20 questions
Disney Characters

Quiz
•
KG
10 questions
Pixar Short "Piper"

Quiz
•
KG - 2nd Grade
20 questions
Kids shows

Quiz
•
KG
20 questions
Guess that Disney

Quiz
•
KG - 5th Grade
20 questions
Cartoon Characters!

Quiz
•
KG - 5th Grade
20 questions
Logos

Quiz
•
KG