
Excel Test (Standard)
Authored by Indra Setiawan
Computers
8th Grade
Used 1+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi SUM digunakan untuk:
Menghitung jumlah karakter
Menjumlahkan nilai numerik
Mencari nilai tertinggi
Mencari nilai terendah
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus untuk menghitung rata-rata dari sel A1 sampai A5 adalah:
=MEAN(A1:A5)
=SUM(A1:A5)/5
=AVERAGE(A1:A5)
=AVG(A1:A5)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi MIN digunakan untuk:
Menjumlahkan nilai
Menentukan nilai maksimum
Menentukan nilai minimum
Menghitung rata-rata
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus yang tepat untuk mencari nilai tertinggi dari sel B1 sampai B10 adalah:
=MIN(B1:B10)
=AVERAGE(B1:B10)
=COUNT(B1:B10)
=MAX(B1:B10)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi COUNT digunakan untuk:
Menghitung jumlah sel kosong
Menghitung jumlah karakter
Menghitung jumlah data pada cell yang diseleksi
Menghitung jumlah teks
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa hasil dari rumus =IF(A1>70, "Lulus", "Tidak Lulus") jika A1 berisi 85?
Lulus
Tidak Lulus
Error
FALSE
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk mencari data secara vertikal dari tabel, fungsi yang digunakan adalah:
HLOOKUP
SEARCH
FIND
VLOOKUP
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
16 questions
Asas Sains Komputer Tingkatan 2 Kuiz Ulangkaji
Quiz
•
8th Grade
20 questions
PH BAB 7 ALGORITMA DAN PEMROGRAMMAN KELAS 8
Quiz
•
8th Grade
15 questions
Excel informática octavo
Quiz
•
8th Grade
20 questions
MS Excel - Bilimkana
Quiz
•
8th Grade - University
20 questions
quiz dasar python
Quiz
•
1st Grade - University
15 questions
Blogger
Quiz
•
7th - 9th Grade
12 questions
KT GHK2 Tin 7
Quiz
•
6th - 8th Grade
15 questions
EXCEL
Quiz
•
8th Grade
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Computers
10 questions
Exploring Valentine's Day with Charlie Brown
Interactive video
•
6th - 10th Grade
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
10 questions
Valentine's Day History and Traditions
Interactive video
•
6th - 10th Grade
20 questions
Laws of Exponents
Quiz
•
8th Grade
11 questions
Valentines Day
Quiz
•
6th - 8th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
25 questions
7th Reading STAAR Vocabulary
Quiz
•
6th - 8th Grade
25 questions
Valentine's Day Trivia
Quiz
•
8th Grade