
Quiz Ms Excel
Authored by hamid abdul
Computers
Professional Development
Used 5+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk Pilihan Pivot Table, terdapat pada Tab apa ?
Home Tab
Insert Tab
Formula Tab
View Tab
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Formula apakah yang digunakan untuk menghitung Nilai Rata-rata ?
=SUM()
=MIN()
=AVG()
=AVERAGE()
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Formula apa yang digunakan untuk mengambil data dari tabel lain, secara horisontal ?
=VLOOKUP()
=HLOOKUP()
=INDEX()
=MATCH()
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Formula apa yang digunakan untuk menghitung nilai maximal, minimal, penjumlahan, dan rata-rata ? (ber-urutan)
=min(), = max(), =sum(), avg()
=max(), =min(), =sum(), average()
=average(), max(), min(), =sum()
=sum(), min(), max(), average()
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Formula yang digunakan untuk mengambil sejumlah karakter dari posisi paling akhir
=Left()
=Right()
=Mid()
=Concatenate()
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apakah gunanya kita membuat Pivot Table ?
Berguna untuk menjumlahkan serangkaian data
Berguna untuk Membuat summary dari sebuah data
Berguna untuk membuat sebuah Chart
Supaya Terlihat keren
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Terdapat dalam Tab manakah action berikut ini : New window, Freeze pane, Zoom, Page Break
Home Tab
Insert Tab
View Tab
Formula Tab
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
10 questions
Quiz - Ls.4 - Advanced Features of Word Processor(Part 2)
Quiz
•
4th Grade - Professio...
10 questions
Iot
Quiz
•
10th Grade - Professi...
13 questions
Guess the Video Game Character 1
Quiz
•
KG - Professional Dev...
10 questions
Soal PTS Prakarya Kelas VIII
Quiz
•
Professional Development
10 questions
Sains Komputer Tingkatan 5 - 1.2.3 Mengkaji perbezaan
Quiz
•
1st Grade - Professio...
11 questions
MS-900 - Module 2 - Full quiz
Quiz
•
Professional Development
14 questions
napędy optyczne.
Quiz
•
Professional Development
10 questions
KDB Pengantunan Dalam Talian
Quiz
•
1st Grade - Professio...
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
44 questions
Would you rather...
Quiz
•
Professional Development
20 questions
Black History Month Trivia Game #1
Quiz
•
Professional Development
12 questions
Mardi Gras Trivia
Quiz
•
Professional Development
14 questions
Valentine's Day Trivia!
Quiz
•
Professional Development
7 questions
Copy of G5_U5_L14_22-23
Lesson
•
KG - Professional Dev...
16 questions
Parallel, Perpendicular, and Intersecting Lines
Quiz
•
KG - Professional Dev...
11 questions
NFL Football logos
Quiz
•
KG - Professional Dev...
12 questions
Valentines Day Trivia
Quiz
•
Professional Development