Pre-Test | E-workshop 2023 (Ms Excel)
Authored by Yesy Rosita
Professional Development
University
Used 52+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Pada Tab apakah fungsi untuk membuat Chart?
Home
Insert
Page Layout
Formulas
Data
2.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Kombinasi tombol apakah yang digunakan untuk berpindah ke Cell A1 secara otomatis?
Ctrl + Home
Ctrl + C
Ctrl + V
Ctrl + X
Ctrl + Backspace
3.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Yang bukan termasuk dari tipe data Excel adalah ...
Numerical Value
Alphanumerical Text Value
Formula
Function
XML
4.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
20
13
18
36
28
5.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Manakah di bawah ini yang benar dalam urutan penulisan formula SUMIF?
=SUMIF(criteria,range,[sum_range])
=SUMIF([sum_range],criteria,range)
=SUMIF([sum_range],range,criteria)
=SUMIF(range,criteria,[sum_range])
=SUMIF(range,[sum_range],criteria)
6.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Formula apakah yang digunakan:
Misalkan pada suatu data penjualan ingin menjumlahkan total penjualan berdasarkan dua parameter yaitu bulan dan lokasi tertentu?
SUMIF
SUMIFS
COUNTIF
COUNTIFS
AVERAGE
7.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Formula apakah yang digunakan:
Misalkaan pada suatu data penjualan ingin menjumlahkan total transaksi berdasarkan dua parameter yaitu bulan dan supllier tertentu?
SUMIF
SUMIFS
COUNTIF
COUNTIFS
AVERAGE
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
25 questions
Test dla Marianek
Quiz
•
1st Grade - University
30 questions
KUIS SKD CPNSPEDIA SESI 1
Quiz
•
12th Grade - Professi...
25 questions
ADULT BEGINNER CHAPTER 4
Quiz
•
1st Grade - Professio...
25 questions
kepribadian 0kt 2022
Quiz
•
University
25 questions
e-CAT Kuiz Alkitab Edisi Ke-39 Kitab Amsal Bab1 - Bab 31 (07.05.
Quiz
•
University
25 questions
e--CAT Edisi Ke-51 Kitab Ester & Kitab Solomo (30.07.2023)
Quiz
•
University
25 questions
Normal Distribution Probability
Quiz
•
University
25 questions
MSDM MODUL 1 DAN 2
Quiz
•
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 Professional Development
7 questions
How James Brown Invented Funk
Interactive video
•
10th Grade - University
5 questions
Helping Build the Internet: Valerie Thomas | Great Minds
Interactive video
•
11th Grade - University
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
23 questions
Subject Verb Agreement
Quiz
•
9th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
19 questions
Review2-TEACHER
Quiz
•
University
15 questions
Pre2_STUDENT
Quiz
•
University
20 questions
Ch. 7 Quadrilateral Quiz Review
Quiz
•
KG - University